Oracle 穿越incarnation恢复数据(一)

当进行不完全恢复后，可能没达到恢复的要求，这个时候数据库已经被resetlogs方式打开过了，如果在进行不完全恢复前没有对数据库进行全库备份，这个时候又想恢复上一个incarnation的某些数据，在这种场景下就需要进行incarnation穿越，下面来演示下这个场景！
一：准备实验基础数据
SQL> create table t043_incarnation(a varchar2(20)) tablespace example;
Table created.

SQL> insert into t043_incarnation values ('corss successful');
1 row created.

SQL> commit;
Commit complete.

SQL> create table t043_other (a number) tablespace example;
Table created.

SQL> insert into t043_other values (1);
1 row created.

SQL> insert into t043_other values (2);
1 row created.

SQL> commit;
Commit complete.

SQL> alter system switch logfile;
System altered.

SQL> insert into t043_other values (3);
1 row created.

SQL> alter system switch logfile;
System altered.

SQL> select sysdate from dual;

SYSDATE
-------------------
2011-07-17-21:22:30

SQL> truncate table t043_incarnation;
Table truncated.

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 64
Next log sequence to archive 66
Current log sequence 66
SQL> insert into t043_other values (4);
1 row created.

SQL> commit;
Commit complete.

SQL> alter system switch logfile;
System altered.