How to drop a restore point after flashback logs are dropped
rax1809Oct 8 2008 — edited Oct 8 2008Hi Gents,
I want to disable flahback logging on my database and disable archiving. I've created few restore point with 'guarantee database' cluase. But ofcourse i'm can't disable archiving until i drop my all the guranteed restore point.
Now the issues is some of the flashback logs are accidently dropped. So i'm not able to drop restore point.
Below mention is the error:
ORA-38701: Flashback database log 20180 seq 20180 thread 1: "F:\ORACLE\ORADATA\DBABC\FLASH_RECOVERY_AREA\DBABC\FLASHBACK\O1_MF_4BBVYOJJ_.FLB"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Kindly help me to perform this action, as the issue is very urgent.
Immediate response would be highly appreciated.
Thanks in advance for your help.
Rakesh