Background:
Now, I want to practice Incremental backup of RMAN. The original test database is in non-archive mode.
So after calling and shutdown an instance, the open instance fails to get started.
sys@ORACLE10> alter database open;alter database open*ERROR at line 1:ORA-00313: open failed for members of log group 1 of thread 1ORA-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
As you can know, the reorganization isNon-currentStatus, andArchived
Use the clear command to recreate the log file
sys@ORACLE10> alter database clear logfile group 1;Database altered.
If the log group alsoNo archive, You need:
Alter database clear Unarchived logfile group 1;
Open the database and back up the database again.
sys@ORACLE10> alter database open;Database altered.