Recover from a loss of all redo log members of an INACTIVE group

We all know that redo log has three kinds of a group like active, inactive, current. They all have different use and as well as different meaning.Let’s simulate a loss of all redo log members of an inactive group.

If you have completely lost one redo log group your database won’t be able to open.
Next thing is to know the STATUS of the lost redo log group (we know it because we are simulating the loss, but…) and, just because this information is on V$LOG view, try to get also the ARCHIVED column.
Now if the redo log group lost was INACTIVE and archived (YES value) we can simply recreate all members with the “alter database clear logfile” command;
if it was INACTIVE and not archived (NO value) we’ll execute the “alter database clear unarchived logfile” command.