oracle_bkprvry_lost_redo_active

Losing Active redo log file is more serious than INACTIVE, because it still contains data that it might be needed. Generally you, the procedure to recover from loss of active member is:

Database is still UP

If the database is running, try to issue a checkpoint and clear the logs

  1. Issue a checkpoint
  2. Clear the logs

If the database is down

Since the active redo logs are used during crash recovery, trying to start up the database will cause the database the crash again during startup. As such your only choice is to:

  1. Perform incomplete recovery (Using the latest redo log files)

This of course will cause loss of data.

  • oracle_bkprvry_lost_redo_active.txt
  • Last modified: 2019/10/18 20:04
  • by 127.0.0.1