Flashback - Migration

ORA-38754: FLASHBACK DATABASE not started; required redo log is not available

ORA-38754: FLASHBACK DATABASE not started; required redo log is not available

  • Cause
    • Oracle needs to have the required archive logs in the archive destination at the time of flashback.
  • Solution
    • Use rman to restore the missing archive logs. The sequence and thread numbers are in the error message.
      rman target /
      run{
         allocate channel t1 device type 'sbt_tape';=
         FLASHBACK DATABASE TO RESTORE POINT <restore point name>;=
         }

Resume the flashback process from the RESETLOGS step.

 

Advertisements
Standard