The Oracle (tm) Users' Co-Operative FAQ

How Do I Recover From Loss of a Inactive Redo Log Group?

Author's name: Allan W. Tham

Author's Email:

Date written: Feb 28 2002

Oracle version(s):

You suspected you lost the only copy of redo group. You did a check on v$logfile and found that there is an invalid status for a redo log group. You further checked that this group is inactive and archived is yes from v$log.

Back to index of questions

Work for Archive Log Mode ON

1. To investigate what status is the missing redo log is -
    a. select * from v$logfile shows which group is INVALID
    b. select * from v$log shows the status of the invalid group
2. Now that you are confirmed that the lost redo file is an INACTIVE redo log, shutdown the database - shutdown immediate
3. Mount the database - Startup mount
4. Since the redo log group is inactive and is archived, just clear the redo log -
    alter database clear logfile group N (where N is the group # of the lost redo log)
5. Open the database - Alter database open
6. Check status - select * from v$log shows a new redo with UNUSED status
7. Do a full backup if you want
8. Done

(Note: Being the easiest case to recover, inactive and archived redo logs recovery is quite straightforward. The difficulty level will be
    1. Lost of current redo
    2. Lost of active redo
    3. Lost of unarchived redo
    4. Lost of inactive redo
See Oracle9i User-Managed Backup and Recovery Guide for inactive and unarchived lost of redo log
Remember, it's always a good idea to multiplex the redo log groups)


Further reading:Metalink note 1060608.6, 1044466.6, Oracle9i User-Managed Backup and Recovery Guide

Back to top

Back to index of questions