[Oracle Logfile recovery] archived and non-current Redo LogFile is damaged

Background:

Now, I want to practice Incremental backup of rman. The original test database is in non-archive mode.

After the shutdown instance is shut down, the open instance cannot start.

Sys @ Oracle10> alter database open;
Alter database open
*
ERROR at line 1:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/oracle10/redo01.log'

Here, we can see that the log file in log group 1 is damaged.

View v $ log view

Sys @ ORACLE10> select group #, sequence #, archived, status from v $ log;

GROUP # SEQUENCE # ARC STATUS
---------------------------------------
1 2 YES INACTIVE
3 1 YES INACTIVE
2 3 NO CURRENT

You can know that the reorganization is not in the current status and has been archived.

Use the clear command to recreate the log file

Sys @ ORACLE10> alter database clear logfile group 1;

Database altered.

If the log group is not archived, you must:

Alter database clear unarchived logfile group 1;

Open the database and back up the database again.

Sys @ ORACLE10> alter database open;

Database altered.