2 2 ORA10G 4061806388 PARENT 525876 2011-02-12-18:37:43
3 3 ORA10G 4061806388 PARENT 7781117 2011-05-23-13:24:09
4 4 ORA10G 4061806388 CURRENT 7787669 2011-05-23-15:51:11
RMAN> restore database;
Starting restore at 2011-07-17-21:29:21
Starting implicit crosscheck backup at 2011-07-17-21:29:21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=154 devtype=DISK
Crosschecked 1 objects
——————————其他输出省略——————————
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 9022073 generated at 07/17/2011 21:20:26 needed for thread 1
ORA-00289: suggestion :
/u01/app/flash_recovery_area/ORA10G/archivelog/2011_07_17/o1_mf_1_64_%u_.arc
ORA-00280: change 9022073 for thread 1 is in sequence #64
Specify log: {
ORA-00279: change 9022129 generated at 07/17/2011 21:21:35 needed for thread 1
ORA-00289: suggestion :
/u01/app/flash_recovery_area/ORA10G/archivelog/2011_07_17/o1_mf_1_65_%u_.arc
ORA-00280: change 9022129 for thread 1 is in sequence #65
ORA-00278: log file
'/u01/app/flash_recovery_area/ORA10G/archivelog/2011_07_17/o1_mf_1_64_725rh0wy_.
arc' no longer needed for this recovery
Specify log: {
ORA-00279: change 9022148 generated at 07/17/2011 21:22:01 needed for thread 1
ORA-00289: suggestion :
/u01/app/flash_recovery_area/ORA10G/archivelog/2011_07_17/o1_mf_1_66_%u_.arc
ORA-00280: change 9022148 for thread 1 is in sequence #66
ORA-00278: log file
'/u01/app/flash_recovery_area/ORA10G/archivelog/2011_07_17/o1_mf_1_65_725rhtt9_.
arc' no longer needed for this recovery
Specify log: {
ORA-00279: change 9022403 generated at 07/17/2011 21:23:46 needed for thread 1
ORA-00289: suggestion :
ORA-00280: change 9022403 for thread 1 is in sequence #67
ORA-00278: log file
'/u01/app/flash_recovery_area/ORA10G/archivelog/2011_07_17/o1_mf_1_66_725rm33n_.
arc' no longer needed for this recovery
Specify log: {
ORA-00308: cannot open archived log
'/u01/app/flash_recovery_area/ORA10G/archivelog/2011_07_17/o1_mf_1_67_%u_.arc'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 9022403 generated at 07/17/2011 21:23:46 needed for thread 1
ORA-00289: suggestion :
/u01/app/flash_recovery_area/ORA10G/archivelog/2011_07_17/o1_mf_1_67_%u_.arc
ORA-00280: change 9022403 for thread 1 is in sequence #67
Specify log: {
cancel
Media recovery cancelled.
四：恢复完后打开数据库，发现之前被truncate的表没有被成功恢复，这个时候就需要进行incarnation穿越
SQL> alter database open resetlogs;
Database altered.
SQL> select * from t043_other;
A
----------
1
2
3
4
SQL> select * from t043_incarnation;
no rows selected
五：关闭数据库后将数据库启动在mount状态，利用rman进行incarnation穿越，恢复t043_incarnation表
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.