Oracle dataguard gap处理，增量备份恢复

# 备数据库查询SCN(最小的一个即可):

col CURRENT_SCN format 99999999999999999;
col min(checkpoint_change#) format 9999999999999999999999;
SELECT CURRENT_SCN FROM V$DATABASE;
select min(checkpoint_change#) from v$datafile_header
where file# not in (select file# from v$datafile where enabled = 'READ ONLY');
10137553275908 《========选择结果比较小的scn.
10137553275909

# 主数据库执行增量备份：

AIX NFS RMAN:（aix 挂在NFS参数配置）
mount -o hard,bg,proto=tcp,rsize=32768,wsize=32768,noac 10.250.250.1:/orabk /oraback
执行增量备份：BACKUP INCREMENTAL FROM SCN 10137553275908 DATABASE FORMAT '/oraback/arch/ForStandby_%U' tag 'FORSTANDBY';backup current controlfile for standby format '/oraback/arch/con.bak';

# 备执行恢复

SQL> shutdown;
SQL> startup nomount;
RMAN> restore standby controlfile from '/oraback/arch/con.bak';
RMAN> shutdown;
RMAN> exit

RMAN> catalog start with '/oraback/arch'; #注册增量备份文件
RMAN> recover database noredo; #注意 noredo 选项

SQL> alter database recover managed standby database using current logfile disconnect from session;
#alter database recover managed standby database cancel;

# 执行恢复发现新增加数据库文件？
RMAN> recover database noredo;   《============新增数据文件，recover报错！
Starting recover at 07-DEC-22
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=3698 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 12/07/2022 18:45:21
RMAN-06094: datafile 41 must be restored

RMAN>
RMAN>
RMAN>
RMAN>

RMAN> restore datafile 41;   《===========先恢复数据库文件，在执行recover!

Starting restore at 07-DEC-22
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00041 to /oradata/system.1859.1114107493
channel ORA_DISK_1: reading from backup piece /databackup/fc/fc_ForStandby_ph1eps2q_1_1