今日重建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
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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10271187/viewspace-2076523/