RMAN错误 RMAN-06026、RMAN-06100

一、错误信息

Starting restore at 31-DEC-22
using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/31/2022 13:37:58
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of datafile 14
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 1

二、错误原因

restore数据文件没有找到相关合适的备份集，引起原因有两种；
1、没有catalog完全包含数据文件的备份集
2、备份集的数据文件处于不同的化身（incarnation）

三、问题处理

1、排查备份集信息

list backup of database;

注册备份信息

catalog start with 'xxxx';

2、排查化身（incarnation）

list incarnation;

切换化身

reset database to incarnation xx;