RMAN-06100: no channel to restore a backup or copy of datafile

parknkjun發表於2016-04-07
REST
今日重建DG遭遇RMAN-06100: no channel to restore a backup or copy of datafile錯誤，源端是一套RAC資料庫，目標端是單例項，報錯資訊如下：
Starting restore at 06-APR-16
released channel: d1
released channel: d2
released channel: d3
released channel: d4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/06/2016 14:22:23
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of datafile 13
RMAN-06100: no channel to restore a backup or copy of datafile 12
RMAN-06100: no channel to restore a backup or copy of datafile 11
RMAN-06100: no channel to restore a backup or copy of datafile 10
RMAN-06100: no channel to restore a backup or copy of datafile 9
RMAN-06100: no channel to restore a backup or copy of datafile 8
RMAN-06100: no channel to restore a backup or copy of datafile 7
RMAN-06100: no channel to restore a backup or copy of datafile 6
RMAN-06100: no channel to restore a backup or copy of datafile 5
RMAN-06100: no channel to restore a backup or copy of datafile 4
RMAN-06100: no channel to restore a backup or copy of datafile 3
RMAN-06100: no channel to restore a backup or copy of datafile 2
RMAN-06100: no channel to restore a backup or copy of datafile 1
目標端查詢list incarnation發現異常，如下：
RMAN> list incarnation;
using target database control file instead of recovery catalog

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       XXXX     2454714347       PARENT  1          11-SEP-08
2       2       XXXX     2454714347       PARENT  880332     24-SEP-13
4       4       XXXX     2454714347       ORPHAN  270366745  07-MAR-16
3       3       XXXX     2454714347       CURRENT 272652102  14-MAR-16
源端查詢incarnation,如下：
RMAN> list incarnation of database;
List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       xxxx     2454714347       PARENT  1          11-SEP-08
2       2       xxxx     2454714347       CURRENT 880332     24-SEP-13
這時才想起來，前面做過snapshot dg，生成了flashback,在catalog start with時把flashback log也註冊了。
解決方式：
reset database to incarnation 2;
或者刪除flashback log
後面restore就正常了
Starting restore at 06-APR-16
channel d1: starting datafile backup set restore
channel d1: specifying datafile(s) to restore from backup set
channel d1: restoring datafile 00005 to /oradata/xxxx/undotbs2.330.826995219
channel d1: restoring datafile 00006 to /oradata/xxxx/xxxx.336.826995725
channel d1: restoring datafile 00010 to /oradata/xxxx/xxxx.340.826995903
channel d1: reading from backup piece /archivelog/rmanbak/full_xxxx_20160406_2686.bak
channel d2: starting datafile backup set restore
channel d2: specifying datafile(s) to restore from backup set
channel d2: restoring datafile 00003 to /oradata/xxxx/undotbs1.322.826995061
channel d2: restoring datafile 00007 to /oradata/xxxx/xxxx.337.826995769
channel d2: restoring datafile 00011 to /oradata/xxxx/xxxx.341.826995947
channel d2: reading from backup piece /archivelog/rmanbak/full_xxxx_20160406_2687.bak


來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/10271187/viewspace-2076523/，如需轉載，請註明出處，否則將追究法律責任。

相關文章