How to recover from a loss of all redo log members of an INACTIVE group

Scenario:

How to recover from a loss of all redo log members of an INACTIVE group

Solution:
1. If lost group is inactive & archived = yes, then recreate all member with “alter database clear logfile” command.

2. If lost group is inactive & archived = no, then recreate all member with “alter database clear unarchived logfile” command.

-

Remove/rename all members of group 3:

-

Shut immediate db:

-

Try to open & check alert log for errors:

-

Check v$log view: and clear log group:

-

 

-

Recovery done.

===

In case of loss of INACTIVE and NOT already ARCHIVED redo log group, then do following:

SQL> alter database clear unarchived logfile group 3;

Database altered.

Next step is to perform a complete backup via rman.

RMAN> backup database;