Case 3--A partial archive log was lost while doing a full recovery (recover database until cancel;)
1. Incomplete recovery based on cancel
--Simulation environment
Sql> Col table_name for A20
Sql> Col Tablespace_name for A10
Sql> select Table_name,tablespace_name from User_tables;
TABLE_NAME Tablespace
-------------------- ----------
DEPT USERS
EMP USERS
BONUS USERS
Salgrade USERS
EMPLOYEES USERS
EMP2 USERS
TB02 Cuug
TB01 TEST
Admin_ext_employees
EMP1 USERS
Ten rows selected.
Sql> Conn/as SYSDBA
Connected.
Sql> select * from SCOTT.TB02;
Id
----------
1
2
3
4
5
6
7
8
8 rows selected.
Sql> select * from V$log;
group# thread# sequence# BYTES members archived STATUS first_change#
---------- ---------- ---------- ---------- ---------- --------- ------------ ------------- -------------------
1 1 1 104857600 3 YES INACTIVE 851230 2012-03-23 16:04:13
4 1 4 104857600 3 NO current 851518 2012-03-23 16:13:25
3 1 3 104857600 3 YES INACTIVE 851509 2012-03-23 16:13:09
2 1 2 104857600 3 YES INACTIVE 851500 2012-03-23 16:12:53
sql> INSERT INTO SCOTT.TB02 values (9);
1 row created.
Sql> commit;
Commit complete.
Sql> alter system archive log current;
System altered.
sql> INSERT into SCOTT.TB02 values (10);
1 row created.
Sql> commit;
Commit complete.
Sql> alter system archive log current;
System altered.
sql> INSERT INTO SCOTT.TB02 values (11);
1 row created.
Sql> commit;
Commit complete.
Sql> alter system archive log current;
System altered.
Sql> select name from V$archived_log;
NAME
--------------------------------------------------
See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/