rman异机还原报错“RMAN-06026: some targets not found - aborting restore”
Tags： OraclermanRMAN-06026备份恢复故障处理
👉 本文共约194个字，系统预计阅读时间或需1分钟。
异机还原rman备份的过程可以参考：https://www.xmmup.com/dbbao15shengchanhuanjingzhongruheliyongdgdebeikulaiyijihaiyuan.html
我的问题是，在同一套测试环境上，还原第2次rman备份的时候报错，第1次还原不报错，报错内容：
1 2 3 4 5 6 7 8 9 10 | RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 09/21/2021 16:26:59 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 |
本人提供Oracle、MySQL、PG等数据库的培训和考证业务，私聊QQ646634621或微信db_bao，谢谢！
当然，备份啥的都是好的，原因是数据库多了incarnation，如下：
1 2 3 4 5 6 7 8 9 10 11 12 13 | RMAN> list incarnation; List of Database Incarnations DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time ------- ------- -------- ---------------- --- ---------- ---------- 1 1 EAS 1865761973 PARENT 1 2013-08-24 11:37:30 2 2 EAS 1865761973 PARENT 925702 2018-01-08 07:34:15 3 3 EAS 1865761973 CURRENT 11723413635 2021-09-15 12:49:29 RMAN> reset database to incarnation 2; database reset to incarnation 2 |
然后继续做还原和恢复操作就可以了。
