ORACLE数据库RMAN-06023 no backup or copy of datafile 4 found to restore错误
Apr272016
昨天在使用RMAN备份在异机恢复的时候，遇到了RMAN-06023错误。
RMAN> run{
2> allocate channel c1 device type disk ;
3> allocate channel c2 device type disk ;
4> allocate channel c3 device type disk ;
5> allocate channel c4 device type disk ;
6> set newname for datafile '/u01/app/oracle/oradata/ivldb/system01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/system01.dbf';
7> set newname for datafile '/u01/app/oracle/oradata/ivldb/sysaux01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/sysaux01.dbf';
8> set newname for datafile '/u01/app/oracle/oradata/ivldb/undotbs01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/undotbs01.dbf';
9> set newname for datafile '/u01/app/oracle/oradata/ivldb/users01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/users01.dbf';
10> set newname for datafile '/u01/app/oracle/oradata/ivldb/ts_ind_ful01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/ts_ind_ful01.dbf';
11> set newname for datafile '/u01/app/oracle/oradata/ivldb/ts_bsc01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/ts_bsc01.dbf';
12> set newname for datafile '/u01/app/oracle/oradata/ivldb/ts_ind_bsc01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/ts_ind_bsc01.dbf';
13> set newname for datafile '/u01/app/oracle/oradata/ivldb/ts_ord01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/ts_ord01.dbf';
14> set newname for datafile '/u01/app/oracle/oradata/ivldb/ts_inx_ord01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/ts_inx_ord01.dbf';
15> set newname for datafile '/u01/app/oracle/oradata/ivldb/ts_ful01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/ts_ful01.dbf';
16> set newname for datafile '/u01/app/oracle/oradata/ivldb/ts_ful_if01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/ts_ful_if01.dbf';
17> set newname for datafile '/u01/app/oracle/oradata/ivldb/ts_inx_ful_if01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/ts_inx_ful_if01.dbf';
18> set newname for datafile '/u01/app/oracle/oradata/ivldb/ts_tmp01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/ts_tmp01.dbf';
19> set newname for datafile '/u01/app/oracle/oradata/ivldb/ts_task01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/ts_task01.dbf';
20> set newname for datafile '/u01/app/oracle/oradata/ivldb/ts_mc01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/ts_mc01.dbf';
21> set newname for datafile '/u01/app/oracle/oradata/ivldb/ts_inxs_mc01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/ts_inxs_mc01.dbf';
22> set newname for datafile '/u01/app/oracle/oradata/ivldb/ts_bsc02.dbf' to '/data2/u01/app/oracle/oradata/ivldb/ts_bsc02.dbf';
23> restore database force;
24> switch datafile all;
25> release channel c1;
26> release channel c2;
27> release channel c3;
28> release channel c4;
29> }
allocated channel: c1
channel c1: SID=130 device type=DISK
allocated channel: c2
channel c2: SID=194 device type=DISK
allocated channel: c3
channel c3: SID=258 device type=DISK
allocated channel: c4
channel c4: SID=322 device type=DISK
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 26-APR-16
released channel: c1
released channel: c2
released channel: c3
released channel: c4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/26/2016 18:40:08
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
因为是在异机做的恢复，备份的目录位置不一样，数据文件的位置也不一样，因此，在恢复之前，使用delete expired backupset命令清理了控制文件中记录的，但是在异机上并不存在的备份，然后通过catalog命令注册了在异机上备份文件的新的位置。
RMAN > CROSSCHECK BACKUP; RMAN > delete expired backupset; RMAN > catalog start with '/data2/ivldb/';
接下来在还原数据文件时，就遇到了上面的错误，经过检查，备份已经成功注册到控制文件，而且权限也没有问题。而且在RMAN中，可以通过list命令，可以看到当前存在的备份是没有问题的。
RMAN> list backup of datafile 4;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4607 Full 2.94G DISK 00:00:00 17-APR-16
BP Key: 4607 Status: AVAILABLE Compressed: YES Tag: DBFULL
Piece Name: /data2/ivldb/dbfull_20160417/dbfull_adr37su4_4429_1_909374404
List of Datafiles in backup set 4607
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 128108093446 17-APR-16 /u01/app/oracle/oradata/ivldb/users01.dbf
RMAN> list backup of datafile 3;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4609 Full 1.12G DISK 00:00:00 17-APR-16
BP Key: 4609 Status: AVAILABLE Compressed: YES Tag: DBFULL
Piece Name: /data2/ivldb/dbfull_20160417/dbfull_afr37su4_4431_1_909374404
List of Datafiles in backup set 4609
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
3 Full 128108093448 17-APR-16 /u01/app/oracle/oradata/ivldb/undotbs01.dbf
这可能是incarnation出了问题，查询下当前的incarnation。
RMAN> list incarnation; List of Database Incarnations DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time ------- ------- -------- ---------------- --- ---------- ---------- 1 1 IVLDB 1372441993 PARENT 1 24-AUG-13 2 2 IVLDB 1372441993 PARENT 925702 10-SEP-15 3 3 IVLDB 1372441993 PARENT 127490194279 05-APR-16 4 4 IVLDB 1372441993 CURRENT 127495461205 08-APR-16
数据库并没有RESETLOGS打开过，incarnation怎么会出问题呢，将incarnation设置小一点，解决这个问题。
RMAN> reset database to incarnation 2; database reset to incarnation 2 RMAN> list incarnation; List of Database Incarnations DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time ------- ------- -------- ---------------- --- ---------- ---------- 1 1 IVLDB 1372441993 PARENT 1 24-AUG-13 2 2 IVLDB 1372441993 CURRENT 925702 10-SEP-15 3 3 IVLDB 1372441993 ORPHAN 127490194279 05-APR-16 4 4 IVLDB 1372441993 ORPHAN 127495461205 08-APR-16
再次还原，问题解决。
RMAN> run{
2> allocate channel c1 device type disk ;
3> allocate channel c2 device type disk ;
4> allocate channel c3 device type disk ;
5> allocate channel c4 device type disk ;
6> set newname for datafile '/u01/app/oracle/oradata/ivldb/system01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/system01.dbf';
7> set newname for datafile '/u01/app/oracle/oradata/ivldb/sysaux01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/sysaux01.dbf';
8> set newname for datafile '/u01/app/oracle/oradata/ivldb/undotbs01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/undotbs01.dbf';
9> set newname for datafile '/u01/app/oracle/oradata/ivldb/users01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/users01.dbf';
10> set newname for datafile '/u01/app/oracle/oradata/ivldb/ts_ind_ful01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/ts_ind_ful01.dbf';
11> set newname for datafile '/u01/app/oracle/oradata/ivldb/ts_bsc01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/ts_bsc01.dbf';
12> set newname for datafile '/u01/app/oracle/oradata/ivldb/ts_ind_bsc01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/ts_ind_bsc01.dbf';
13> set newname for datafile '/u01/app/oracle/oradata/ivldb/ts_ord01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/ts_ord01.dbf';
14> set newname for datafile '/u01/app/oracle/oradata/ivldb/ts_inx_ord01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/ts_inx_ord01.dbf';
15> set newname for datafile '/u01/app/oracle/oradata/ivldb/ts_ful01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/ts_ful01.dbf';
16> set newname for datafile '/u01/app/oracle/oradata/ivldb/ts_ful_if01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/ts_ful_if01.dbf';
17> set newname for datafile '/u01/app/oracle/oradata/ivldb/ts_inx_ful_if01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/ts_inx_ful_if01.dbf';
18> set newname for datafile '/u01/app/oracle/oradata/ivldb/ts_tmp01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/ts_tmp01.dbf';
19> set newname for datafile '/u01/app/oracle/oradata/ivldb/ts_task01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/ts_task01.dbf';
20> set newname for datafile '/u01/app/oracle/oradata/ivldb/ts_mc01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/ts_mc01.dbf';
21> set newname for datafile '/u01/app/oracle/oradata/ivldb/ts_inxs_mc01.dbf' to '/data2/u01/app/oracle/oradata/ivldb/ts_inxs_mc01.dbf';
22> set newname for datafile '/u01/app/oracle/oradata/ivldb/ts_bsc02.dbf' to '/data2/u01/app/oracle/oradata/ivldb/ts_bsc02.dbf';
23> restore database force;
24> switch datafile all;
25> release channel c1;
26> release channel c2;
27> release channel c3;
28> release channel c4;
29> }
allocated channel: c1
channel c1: SID=130 device type=DISK
allocated channel: c2
channel c2: SID=194 device type=DISK
allocated channel: c3
channel c3: SID=258 device type=DISK
allocated channel: c4
channel c4: SID=322 device type=DISK
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 26-APR-16
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00001 to /data2/u01/app/oracle/oradata/ivldb/system01.dbf
channel c1: restoring datafile 00002 to /data2/u01/app/oracle/oradata/ivldb/sysaux01.dbf
channel c1: restoring datafile 00003 to /data2/u01/app/oracle/oradata/ivldb/undotbs01.dbf
channel c1: restoring datafile 00005 to /data2/u01/app/oracle/oradata/ivldb/ts_ind_ful01.dbf
channel c1: restoring datafile 00008 to /data2/u01/app/oracle/oradata/ivldb/ts_ord01.dbf
channel c1: reading from backup piece /data2/ivldb/dbfull_20160417/dbfull_afr37su4_4431_1_909374404
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set
channel c2: restoring datafile 00004 to /data2/u01/app/oracle/oradata/ivldb/users01.dbf
channel c2: restoring datafile 00017 to /data2/u01/app/oracle/oradata/ivldb/ts_bsc02.dbf
channel c2: reading from backup piece /data2/ivldb/dbfull_20160417/dbfull_adr37su4_4429_1_909374404
channel c3: starting datafile backup set restore
channel c3: specifying datafile(s) to restore from backup set
channel c3: restoring datafile 00006 to /data2/u01/app/oracle/oradata/ivldb/ts_bsc01.dbf
channel c3: restoring datafile 00013 to /data2/u01/app/oracle/oradata/ivldb/ts_tmp01.dbf
channel c3: restoring datafile 00014 to /data2/u01/app/oracle/oradata/ivldb/ts_task01.dbf
channel c3: restoring datafile 00015 to /data2/u01/app/oracle/oradata/ivldb/ts_mc01.dbf
channel c3: restoring datafile 00016 to /data2/u01/app/oracle/oradata/ivldb/ts_inxs_mc01.dbf
channel c3: reading from backup piece /data2/ivldb/dbfull_20160417/dbfull_acr37su4_4428_1_909374404
channel c4: starting datafile backup set restore
channel c4: specifying datafile(s) to restore from backup set
channel c4: restoring datafile 00007 to /data2/u01/app/oracle/oradata/ivldb/ts_ind_bsc01.dbf
channel c4: restoring datafile 00009 to /data2/u01/app/oracle/oradata/ivldb/ts_inx_ord01.dbf
channel c4: restoring datafile 00010 to /data2/u01/app/oracle/oradata/ivldb/ts_ful01.dbf
channel c4: restoring datafile 00011 to /data2/u01/app/oracle/oradata/ivldb/ts_ful_if01.dbf
channel c4: restoring datafile 00012 to /data2/u01/app/oracle/oradata/ivldb/ts_inx_ful_if01.dbf
channel c4: reading from backup piece /data2/ivldb/dbfull_20160417/dbfull_aer37su4_4430_1_909374404
channel c1: piece handle=/data2/ivldb/dbfull_20160417/dbfull_afr37su4_4431_1_909374404 tag=DBFULL
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:14:36
channel c4: piece handle=/data2/ivldb/dbfull_20160417/dbfull_aer37su4_4430_1_909374404 tag=DBFULL
channel c4: restored backup piece 1
channel c4: restore complete, elapsed time: 00:19:46
channel c3: piece handle=/data2/ivldb/dbfull_20160417/dbfull_acr37su4_4428_1_909374404 tag=DBFULL
channel c3: restored backup piece 1
channel c3: restore complete, elapsed time: 00:27:26
channel c2: piece handle=/data2/ivldb/dbfull_20160417/dbfull_adr37su4_4429_1_909374404 tag=DBFULL
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:27:46
Finished restore at 26-APR-16
datafile 1 switched to datafile copy
input datafile copy RECID=20 STAMP=910206719 file name=/data2/u01/app/oracle/oradata/ivldb/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=21 STAMP=910206720 file name=/data2/u01/app/oracle/oradata/ivldb/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=22 STAMP=910206720 file name=/data2/u01/app/oracle/oradata/ivldb/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=23 STAMP=910206721 file name=/data2/u01/app/oracle/oradata/ivldb/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=24 STAMP=910206721 file name=/data2/u01/app/oracle/oradata/ivldb/ts_ind_ful01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=25 STAMP=910206722 file name=/data2/u01/app/oracle/oradata/ivldb/ts_bsc01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=26 STAMP=910206722 file name=/data2/u01/app/oracle/oradata/ivldb/ts_ind_bsc01.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=27 STAMP=910206723 file name=/data2/u01/app/oracle/oradata/ivldb/ts_ord01.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=28 STAMP=910206723 file name=/data2/u01/app/oracle/oradata/ivldb/ts_inx_ord01.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=29 STAMP=910206724 file name=/data2/u01/app/oracle/oradata/ivldb/ts_ful01.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=30 STAMP=910206724 file name=/data2/u01/app/oracle/oradata/ivldb/ts_ful_if01.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=31 STAMP=910206724 file name=/data2/u01/app/oracle/oradata/ivldb/ts_inx_ful_if01.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=32 STAMP=910206725 file name=/data2/u01/app/oracle/oradata/ivldb/ts_tmp01.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=33 STAMP=910206725 file name=/data2/u01/app/oracle/oradata/ivldb/ts_task01.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=34 STAMP=910206725 file name=/data2/u01/app/oracle/oradata/ivldb/ts_mc01.dbf
datafile 16 switched to datafile copy
input datafile copy RECID=35 STAMP=910206725 file name=/data2/u01/app/oracle/oradata/ivldb/ts_inxs_mc01.dbf
datafile 17 switched to datafile copy
input datafile copy RECID=36 STAMP=910206726 file name=/data2/u01/app/oracle/oradata/ivldb/ts_bsc02.dbf
released channel: c1
released channel: c2
released channel: c3
released channel: c4
还原后，还 需要恢复下，才能打开数据库，这里使用基于时间点的不完全恢复。
RMAN> run{
2> sql 'alter session set nls_date_format= "YYYY-MM-DD HH24:MI:SS"';
3> set until time '2016-04-17 05:00:00';
4> recover database;
5> }
sql statement: alter session set nls_date_format= "YYYY-MM-DD HH24:MI:SS"
executing command: SET until clause
Starting recover at 26-APR-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=130 device type=DISK
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=12072
channel ORA_DISK_1: reading from backup piece /data2/ivldb/dbfull_20160417/arch_b7r37tc0_4455_1_909374848
channel ORA_DISK_1: piece handle=/data2/ivldb/dbfull_20160417/arch_b7r37tc0_4455_1_909374848 tag=ARCH
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/data2/u01/app/ivldb_flash_recovery_area/IVLDB/archivelog/2016_04_26/o1_mf_1_12072_ckymp5ff_.arc thread=1 sequence=12072
channel default: deleting archived log(s)
archived log file name=/data2/u01/app/ivldb_flash_recovery_area/IVLDB/archivelog/2016_04_26/o1_mf_1_12072_ckymp5ff_.arc RECID=25304 STAMP=910207174
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=12073
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=12074
channel ORA_DISK_1: reading from backup piece /data2/ivldb/arc_20160418/arch_b9r3aha4_4457_1
channel ORA_DISK_1: piece handle=/data2/ivldb/arc_20160418/arch_b9r3aha4_4457_1 tag=ARCH
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
archived log file name=/data2/u01/app/ivldb_flash_recovery_area/IVLDB/archivelog/2016_04_26/o1_mf_1_12073_ckympcww_.arc thread=1 sequence=12073
channel default: deleting archived log(s)
archived log file name=/data2/u01/app/ivldb_flash_recovery_area/IVLDB/archivelog/2016_04_26/o1_mf_1_12073_ckympcww_.arc RECID=25305 STAMP=910207179
archived log file name=/data2/u01/app/ivldb_flash_recovery_area/IVLDB/archivelog/2016_04_26/o1_mf_1_12074_ckympcjr_.arc thread=1 sequence=12074
channel default: deleting archived log(s)
archived log file name=/data2/u01/app/ivldb_flash_recovery_area/IVLDB/archivelog/2016_04_26/o1_mf_1_12074_ckympcjr_.arc RECID=25306 STAMP=910207183
media recovery complete, elapsed time: 00:00:06
Finished recover at 26-APR-16
还原完成后，修改下online redo log的位置，以防止resetlogs的时候报错。
SQL> select member from v$logfile; MEMBER -------------------------------------------------------------------------------- /u01/app/oracle/oradata/ivldb/redo03.log /u01/app/oracle/oradata/ivldb/redo02.log /u01/app/oracle/oradata/ivldb/redo01.log /u01/app/oracle/oradata/ivldb/redo04.log /u01/app/oracle/oradata/ivldb/redo05.log /u01/app/oracle/oradata/ivldb/redo06.log /u01/app/oracle/oradata/ivldb/slog1.rdo /u01/app/oracle/oradata/ivldb/slog2.rdo /u01/app/oracle/oradata/ivldb/slog3.rdo /u01/app/oracle/oradata/ivldb/slog4.rdo /u01/app/oracle/oradata/ivldb/slog5.rdo /u01/app/oracle/oradata/ivldb/slog6.rdo 12 rows selected. SQL> alter database rename file '/u01/app/oracle/oradata/ivldb/redo03.log' to '/data2/u01/app/oracle/oradata/ivldb/redo03.log'; Database altered. SQL> alter database rename file '/u01/app/oracle/oradata/ivldb/redo04.log' to '/data2/u01/app/oracle/oradata/ivldb/redo04.log'; Database altered. SQL> alter database rename file '/u01/app/oracle/oradata/ivldb/redo05.log' to '/data2/u01/app/oracle/oradata/ivldb/redo05.log'; Database altered. SQL> alter database rename file '/u01/app/oracle/oradata/ivldb/redo01.log' to '/data2/u01/app/oracle/oradata/ivldb/redo01.log'; Database altered. SQL> alter database rename file '/u01/app/oracle/oradata/ivldb/redo02.log' to '/data2/u01/app/oracle/oradata/ivldb/redo02.log'; Database altered. SQL> alter database rename file '/u01/app/oracle/oradata/ivldb/redo06.log' to '/data2/u01/app/oracle/oradata/ivldb/redo06.log'; Database altered. SQL> alter database open resetlogs; Database altered.
Incarnation被称之为数据库实体，每次resetlogs打开数据库的时候，都会创建一个新的incarnation，这些信息都被记录在控制文件中，所以，如果通过RMAN来恢复误操作，resetlogs打开数据库后，发现数据不对，如果还需要再次往回推数据库的时候，正常情况下是不能再次使用备份来还原数据库的，这时就需要调整incarnation了。好像incarnation也是OCP考题的一部分，记不清了。
ORACLE数据库RMAN-06023 no backup or copy of datafile 4 found to restore错误：目前有2 条留言
发表评论
应该是这样吧：1.每一次resetlogs就会使incarnation + 1；2.如果想要恢复到之前incarnation的scn，就需要先恢复到之前的incarnation；
2016-04-28 10:43嗯，可以这么说
2016-04-28 13:03