[Oracle Log file recovery] archive and non-current Redo LogFile corruption issues

[Oracle Log file recovery] background of corrupted archived and non-current Redo LogFile: today, I want to practice the Incremental backup of rman. The original test database is in non-archive mode. After calling and shutdown the instance, the open instance cannot start [SQL] 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 [SQL] 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 can be known, the reorganization is not in the CURRENT state, and the log file has been archived and rebuilt with the clear command [SQL] sys @ ORACLE10> alter database clear logfile group 1; database altered. if the log group is not archived, You Need To: alter database clear unarchived logfile group 1; open the database, and then back up the database again [SQL] sys @ ORACLE10> alter database open; database altered.