笔记：物理Standby搭建时恢复报错RMAN-03002 RMAN-06026 RMAN-06100

说明:
在进行physical standby搭建过程中，使用rman恢复灾备库，出现报错RMAN-03002 RMAN-06026 RMAN-06100，无法正常恢复数据库。

错误信息：

RMAN> 
RMAN-03090: Starting restore at 2020-07-31 09:40:32
RMAN-06009: using target database control file instead of recovery catalog
RMAN-08030: allocated channel: ORA_DISK_1
RMAN-08500: channel ORA_DISK_1: SID=2521 device type=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/31/2020 09:40:32
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of datafile 1

记录debug：

C:\>rman target / log=rmanLog.txt trace=rmanTrace.txt
RMAN> debug on;
RMAN> restore datafile 1;
RMAN> debug off;
RMAN> exit;

分析：

During the restore operation, rman will catalog files in the configured Flash Recovery Area (FRA).

In this case, it finds 2 controlfile autobackups:

List of Cataloged Files
=======================
File Name: /Oracle_Flash_Recovery/app/oracle/admin/PATH/autobackup/2009_01_20/BP_NAME.bkp
File Name: /Oracle_Flash_Recovery/app/oracle/admin/PATH/autobackup/2009_01_23/BP_NAME.bkp

 and this causes the incarnation to be reset as can be seen in the alert.log:

New incarnation branch detected in Backup, filename /Oracle_Flash_Recovery/app/oracle/admin/PATH/autobackup/2009_01_20/deleted_BP_NAME.bkp
Inspection of file changed rdi from 2 to 3
Setting recovery target incarnation to 3
Mon Jan 26 15:58:44 2009
Setting recovery target incarnation to 3

With this new incarnation set, rman is unable to find the backups from the previous incarnation.

可能是闪回区自动备份的控制文件导致

解决方案:
1，在新库设置新的FRA目录
2，保证FRA为空

The solution is to make sure rman is not finding the controlfile autobackups during restore.

This can be done in 2 ways:

- Specify a different location for the FRA on the new system

or

- Make sure the configured FRA is empty.

参考文档：
RMAN-06026 RMAN-20003 - During Restore From A Disk Backup to an Identically Cloned Host (Doc ID 763703.1)