ERROR:
ORA-38760: This database instance failed to turn on flashback database
CAUSE:
When we are upgrading from 12c to 19c we faced below error,
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-38760: This database instance failed to turn on flashback database
SOLUTION:
Check if flashback database is disable or not. When checked the flashback status after disabling flashback, it shows ‘RESTORE POINT ONLY’ instead of ‘NO’.
SQL> select flashback_on from v$database;
FLASHBACK_ON
——————
RESTORE POINT ONLY
Check the name from v$restore_point view but that would also fail with same error:
SQL> select * from v$restore_point;
select * from v$restore_point
*
ERROR at line 1:
ORA-38701: Flashback database log 2 seq 2 thread 1: “+<Disk>/<db unique name>/flashback/log_2.2286.801367563”
ORA-17503: ksfdopn:2 Failed to open file +<Disk>/<db unique name>/flashback/log_2.2286.801367563
ORA-15012: ASM file ‘+<Disk>/<db unique name>/flashback/log_2.2286.801367563’ does not exist
Here we are not able to query v$restore _point to find out the name.
Now Dump the controlfile to get the restore point name:
SQL> oradebug setmypid
SQL> alter session set events ‘immediate trace name controlf level 9’;
SQL> oradebug tracefile_name
From trace file of controlfile dump, we could see below information:
***************************************************************************
RESTORE POINT RECORDS
***************************************************************************
(size = 212, compat size = 212, section max = 2048, section in-use = 1,
last-recid= 1, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 240, numrecs = 2048)
RESTORE POINT #1:
restore point name: <restore point test> guarantee flag: 1 incarnation: 2next record 0 <<<< Name of restore point
restore point scn: 0x0000.fbff3d87 12/07/2012 02:16:32
Now we have name of Guaranteed Restore Point:
SQL> Drop restore point <restore point test>;
SQL> alter database open;
Database Altered
