Oracle DataGuard归档日志丢失处理方法(2)

List of Files Unknown to the Database
 =====================================
 File Name: /home/oracle/bak/08r1ekse_1_1
 File Name: /home/oracle/bak/0or22q7t_1_1
 File Name: /home/oracle/bak/0kr22phj_1_1
 File Name: /home/oracle/bak/0nr22pic_1_1
 File Name: /home/oracle/bak/09r1eku6_1_1
 File Name: /home/oracle/bak/0rr22q7u_1_1

Do you really want to catalog the above files (enter YES or NO)? yes
 cataloging files...
 cataloging done

文件编目后，我们就可以开始正式恢复数据库了.

RMAN> recover database;

Starting recover at 03-APR-16
 using channel ORA_DISK_1

starting media recovery

.....................................

media recovery complete, elapsed time: 00:03:01
 Finished recover at 03-APR-16

备库完成恢复完成后，我们就可以启动redo apply 了.

STANDBY> alter database recover managed standby database disconnect from session using current logfile;

Database altered.

STANDBY> select process,client_process,sequence#,status from v$managed_standby;

PROCESS  CLIENT_P  SEQUENCE# STATUS
 --------- -------- ---------- ------------
 ARCH  ARCH    0 CONNECTED
 ARCH  ARCH    0 CONNECTED
 ARCH  ARCH    0 CONNECTED
 ARCH  ARCH    0 CONNECTED
 ARCH  ARCH    0 CONNECTED
 RFS  ARCH    0 IDLE
 RFS  LGWR  33 IDLE
 MRP0  N/A  33 WAIT_FOR_LOG

现在我们查看备库状态，MRP进程已经开始最新的日志应用了.到此我们通过增量SCN备份和恢复来修复备库归档日志丢失的过程已经全部完成了。

Oracle 11gR2 在VMWare虚拟机中安装步骤

Debian 下 安装 Oracle 11g XE R2

Oracle Data Guard 重要配置参数

基于同一主机配置 Oracle 11g Data Guard

探索Oracle之11g DataGuard

Oracle Data Guard （RAC+DG) 归档删除策略及脚本

Oracle Data Guard 的角色转换

Oracle Data Guard的日志FAL gap问题

Oracle 11g Data Guard Error 16143 Heartbeat failed to connect to standby 处理方法