RMAN-06023 no backup or copy of datafile 1 found to restore
错误详情：
-
RMAN> restore database from tag="NEAL_LV0";
-
-
Starting restore at 09-MAR-16
-
using channel ORA_DISK_1
-
RMAN-00571: ===========================================================
-
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
-
RMAN-00571: ===========================================================
-
RMAN-03002: failure of restore command at 03/09/2016 10:11:53
-
RMAN-06026: some targets not found - aborting 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
检查了一下备份文件发现都是存在的。最后发现是incarnation的问题，由于之前做了一次不完全恢复，进行了alter database open resetlogs;
-
RMAN> list incarnation;
-
-
List of Database Incarnations
-
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
-
------- ------- -------- ---------------- --- ---------- ----------
-
1 1 NEAL 4033362200 PARENT 1 24-AUG-13
-
2 2 NEAL 4033362200 PARENT 925702 06-NOV-15
-
3 3 NEAL 4033362200 PARENT 1623729 19-NOV-15
-
4 4 NEAL 4033362200 PARENT 1716084 17-NOV-15
- 5 5 NEAL 4033362200 CURRENT 7160370 09-MAR-16
将数据库重置到上一次的incarnation，这里即是4，然后还原数据库，问题解决。
-
RMAN> reset database to incarnation 4;
- database reset to incarnation 4
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29812844/viewspace-2063693/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
