Saturday, February 9, 2019

ORA-38760: This database instance failed to turn on flashback database


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>



1 comment:

Pramuditha said...

Thanks a lot. It worked to me.