RMAN-06023 no backup or copy of datafile 1 found to restore

错误详情：

1. RMAN> restore database from tag="NEAL_LV0";
   
2. 
   
3. Starting restore at 09-MAR-16
   
4. using channel ORA_DISK_1
   
5. RMAN-00571: ===========================================================
   
6. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
   
7. RMAN-00571: ===========================================================
   
8. RMAN-03002: failure of restore command at 03/09/2016 10:11:53
   
9. RMAN-06026: some targets not found - aborting restore
   
10. ......
    
11. RMAN-06023: no backup or copy of datafile 3 found to restore
    
12. RMAN-06023: no backup or copy of datafile 2 found to restore
    
13. RMAN-06023: no backup or copy of datafile 1 found to restore

检查了一下备份文件发现都是存在的。最后发现是incarnation的问题，由于之前做了一次不完全恢复，进行了alter database open resetlogs;

1. RMAN> list incarnation;
   
2. 
   
3. List of Database Incarnations
   
4. DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
   
5. ------- ------- -------- ---------------- --- ---------- ----------
   
6. 1 1 NEAL 4033362200 PARENT 1 24-AUG-13
   
7. 2 2 NEAL 4033362200 PARENT 925702 06-NOV-15
   
8. 3 3 NEAL 4033362200 PARENT 1623729 19-NOV-15
   
9. 4 4 NEAL 4033362200 PARENT 1716084 17-NOV-15
   
10. 5 5 NEAL 4033362200 CURRENT 7160370 09-MAR-16

解决方法：

将数据库重置到上一次的incarnation，这里即是4，然后还原数据库，问题解决。

1. RMAN> reset database to incarnation 4;
   
2. database reset to incarnation 4

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29812844/viewspace-2063693/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29812844/viewspace-2063693/