rman 恢复--current redo 损坏的情况 - 数据库编程

able created.
SQL> insert into test33 values(1,'zhang');
1 row created.
SQL> /.
1 row created.
SQL> /
1 row created.
SQL> commit;
Commit complete.
SQL> select * from test33;
AAB001 AAB004
---------- -------------------
1 zhang
1 zhang
1 zhang
SQL> alter system switch logfile;
System altered.
SQL> select first_change#,next_change#,group#,sequence#,status from v$log;
FIRST_CHANGE# NEXT_CHANGE# GROUP# SEQUENCE# STATUS
------------- ------------ ---------- ---------- ----------------
1000076 1000117 1 10 ACTIVE
1000117 2.8147E+14 2 11 CURRENT
999426 1000076 3 9 ACTIVE
SQL> create table c_test(aac001 varchar2(10),name varchar2(13));
Table created.

SQL> insert into c_test values('1392027','haozg');
1 row created.
SQL> /
1 row created.
SQL> /.
1 row created.
SQL> /
1 row created.
SQL> commit;
Commit complete.
SQL> select * from c_test;
AAC001 NAME
---------- -------------
1392027 haozg
1392027 haozg
1392027 haozg
1392027 haozg
SQL> select first_change#,next_change#,group#,sequence#,status from v$log;
FIRST_CHANGE# NEXT_CHANGE# GROUP# SEQUENCE# STATUS
------------- ------------ ---------- ---------- ----------------
1000076 1000117 1 10 ACTIVE
1000117 2.8147E+14 2 11 CURRENT
999426 1000076 3 9 ACTIVE

rman 恢复--current redo 损坏的情况(二)