基于cancel的不完全恢复

过程：插数据56--查日志--关库--删文件，归档和当前日志组--起库报错--查询--转出文件--恢复报错--关库--重新转储所有数据文件--mount--不完全恢复--开库resetlogs

1、首先做一个全备份

sys@TEST0910>  @/u01/app/oracle/bak/cold_bak

 

2、插入三次数据，分别是提交归档，提交不归档，不提交不归档

 

sys@TEST0910> select count(*) from scott.test10;

  COUNT(*)

----------

        14

1 row selected.

sys@TEST0910> insert into scott.test10 select * from scott.emp;

14 rows created.

sys@TEST0910> commit;

Commit complete.

sys@TEST0910> alter system archive log current;

System altered.

sys@TEST0910> select count(*) from scott.test10;

  COUNT(*)

----------

        28

1 row selected.

sys@TEST0910> insert into scott.test10 select * from scott.emp;

14 rows created.

sys@TEST0910> commit;

Commit complete.

sys@TEST0910> select count(*) from scott.test10;

  COUNT(*)

----------

        42

1 row selected.

sys@TEST0910> insert into scott.test10 select * from scott.emp;

14 rows created.

sys@TEST0910> select count(*) from scott.test10;

  COUNT(*)

----------

        56

1 row selected.

 

 

3、查询当前日志组以及数据文件的位置

sys@TEST0910> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS           FIRST_