- Lost non-current online log under archiving mode
C: /> DEL D: /Oracle9/oradata/nbxtdb/redo03.log
C: /> EXIT
SQL> StartUporacle routines have been started.
Total System Global Area 378608760 Bytesfixed Size 453752 bytesvariable size 167772160 bytesdatabase buffers 209715200 BYTESREDO BUFFERS 667648 BYTES Database Loading. ORA-00313: Members of the log group 3 (thread 1) ORA-00312: Online log 3 thread 1: 'D: /oracle9/oradata/nbxtdb/redo03.log'
SQL> Select Group #, sequence #, archived, status from v $ log;
Group # sequence # arc status ---------- ---------------------------- 1 106 no current 2 104 Yes Inactive 3 105 Yes inactive - Discovery 3 is the right log, and has filed
SQL> ALTER DATABASE CLOGFILE GROUP 3;
- Use: ALTER DATABASE CLOAR UnarchiveD logfile group 3;
The database has been changed.
SQL> ALTABASE OPEN;
The database has been changed.
- If damage is a non-current online log file, only CLEAR only needs to rebuild the log file, but if the database is archived - but the log has not been archived, it requires strong CLEAR.
- Recommended after Clear, especially for a full backup of a database after the CLEAR
- Change method suitable for archiving and non-archive databases
