Today, I faced following error in one of old test database. flashback database was on and someone deleted a flashback log file.
so first I tried to off the flashback option then tried to open the database but it was reporting this error. then figured out that we had few restore points (guaranteed restore point) created before.
So solution came after dropping those restore points and then tried to open. you can see in below -
Database was in MOUNT mode.
SQL> conn / as sysdba
Connected.
SQL>
SQL>
SQL>
SQL> alter database open
2 /
alter database open
*
ERROR at line 1:
ORA-38760: This database instance failed to turn on flashback database
SQL> alter database flashback off ;
Database altered.
SQL>
SQL> alter database open ;
alter database open
*
ERROR at line 1:
ORA-38760: This database instance failed to turn on flashback database
SQL> select name from v$restore_point;
NAME
------------------------------------------------------
FB
RP
RP_TEST
SQL> drop restore point FB ;
Restore point dropped.
SQL>
SQL> drop restore point RP;
Restore point dropped.
SQL> drop restore point rp_test;
Restore point dropped.
SQL>
SQL> alter database open ;
Database altered.
SQL>
