Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

deleted files after drop restore point

ANNECAug 4 2023 — edited Aug 4 2023

We have some guranteed restore points created and then dropped after some important process.

In the alert log I see:

Drop guaranteed restore point JULY30_9_40AM

Guaranteed restore point JULY30_9_40AM dropped

Then I see a bunch of below statements in the alert log: My question is is :

Is below due to we dropped the guaranteed restore point, then it will automatically generate this log in the alert log, or below is some other delete commands that executed from sqlplus.exe to delete files, if so, what are the commands?

Deleted Oracle managed file F:\ORADATA\FAST_RECOVERY_AREA\PSPRODDB\FLASHBACK\O1_MF_L17JSL5V_.FLB

Deleted Oracle managed file F:\ORADATA\FAST_RECOVERY_AREA\PSPRODDB\FLASHBACK\O1_MF_LCOKH47O_.FLB

Deleted Oracle managed file F:\ORADATA\FAST_RECOVERY_AREA\PSPRODDB\FLASHBACK\O1_MF_KF9F77O2_.FLB

Thanks

This post has been answered by Solomon Yakobson on Aug 28 2023
Jump to Answer
Comments
Post Details
Added on Aug 4 2023
4 comments
424 views