Oracle Incomplete recovery based on user management (iv) loss of partial archive log when full recovery

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/