Oracle data recovery scenario 2-simulated redo log loss (1)

Oracle data recovery scenario 2-simulated redo log loss (1) Link: Oracle recovery scenario 1-simulated data file damage or loss http://www.bkjia.com/database/201206/137602.html Database recovery after oracle redo log (current or non-current log) corruption (1) (1) database no exception close db Version: Release 11.2.0.2.01. view the current log STATUS 01 www.2cto.com SQL> col GROUP # format 9; 02SQL> col TYPE format a8; 03SQL> col MEMBER format a40; 04SQL> col STATUS format a8; 05SQL> select t1.GROUP #, t1.MEMBER, t1.TYPE, t2.STATUS, t2.bytes from v $ logfile t1, v $ log t2 where t1.GROUP # = t2.GROUP #; 06 07 GROUP # member type status BYTES08 ------ bytes -------- ---------- 09 3/opt/oracle/oradata/oraddim/redo03.log online inactive 5242880010 2/opt/oracle/oradata/oraddim/redo02.log ONLINE CURRENT 5242880011 1/opt/oracle/oradata/oraddim/redo01.log online inactive 52428800 www.2cto.com 2. simulate database activity -- delete data 1 $ cat del. sql2delete from DBA_temp1 where rownum <100; 3 commit; 1SQL> @ del. sql2 3SQL> select count (*) from DBA_temp1; 4 COUNT (*) 5--------6 72683 3. simulate the deletion of current redo log1 www.2cto.com $ mv redo03.log .. 01SQL> @ del. sql0299 rows deleted.03Commit complete.04 05SQL> select count (*) from uas. DBA_temp1; 06 COUNT (*) 07----------08 7258409 10SQL>
4. simulate switching log 1SQL> alter system switch logfile; 2 System altered.3 4SQL> alter system switch logfile; 5 www.2cto.com System altered.6 7SQL> alter system switch logfile; -- switch a loop (to redo03 again) later, hang lives
5. view alter. log1Linux-x86_64 Error: 2: No such file or directory2Additional information: 33Wed Jul 04 18:10:22 20124 Errors in file/opt/oracle/diag/rdbms/oraddim/trace/usage: 5ORA-00313: open failed for members of log group 2 of thread 16ORA-00312: online log 2 thread 1: '/opt/oracle/oradata/oraddim/redo02.log '7ora-27037: unable to obtain file status 6. cancel log switching 1 SQL> alter system switch logfile; 2 alter system switch logfile3 * 4 ERROR at line 1: 5ORA-01013: user requested cancel of current operation6 www.2cto.com 7SQL> 7. clear unarchived log group 3 01SQL> alter database clear unarchived logfile group 3; 02 Database altered.03 04SQL> select t1.GROUP #, t1.MEMBER, t1.TYPE, t2.STATUS, t2.bytes from v $ logfile t1, v $ log t2 where t1.GROUP # = t2.GROUP #; 05 GROUP # member type status BYTES06 ------ bytes -------- ---------- 07 3/opt/oracle/oradata/oraddim/redo03.log online unused 5242880008 2/opt/oracle/oradata/oraddim/redo02.log ONLINE CURRENT 5242880009 1/opt/oracle/oradata/oraddim/redo01.log online inactive 5242880010 11SQL> select count (*) from uas. DBA_temp1; 12 COUNT (*) 13----------14 www.2cto.com 72584 8. switch log 01SQL> alter system switch logfile; 02 System altered.03 04SQL> alter system switch logfile; 05 System altered.06 07SQL> select t1.GROUP #, t1.MEMBER, t1.TYPE, t2.STATUS, t2.bytes from v $ logfile t1, v $ log t2 where t1.GROUP # = t2.GROUP #; 08 member group # member type status BYTES09 ------ bytes -------- ---------- 10 3/opt/oracle/oradata/oraddim/redo03.log online current 5242880011 2/opt/oracle/oradata/oraddim/redo02.log ONLINE ACTIVE 5242880012 1/opt/oracle/oradata/oraddim/redo01.log online inactive 52428800
Author Wang Zi's key