--环境
主库：双节点RAC
备库：单实例数据库

故障描述：
物理备库的数据盘、在线日志盘、归档日志盘出现大量坏块，里面的数据和主库不一致；格式化备库的数据盘后，需要重建物理备库。

恢复重建流程：
1、拷贝主库的0级备份和0级备份之后全部的归档日志备份到备库，在备库里面注册
catalog start with '/ORADATA/bk';

检查备份文件和归档日志的状态，删除不存在的备份和归档日志
CROSSCHECK BACKUP;
CROSSCHECK ARCHIVELOG ALL;
DELETE EXPIRED BACKUP;
delete expired archivelog all;

2、将备库启动到MOUNT状态，执行RESTORE命令重建数据文件
RESTORE DATABASE;

3、由于在线日志文件盘损坏，需要重建在线日志

SQL> select * from v$logfile;

    GROUP# STATUS  TYPE    MEMBER    IS_
---------- ------- ------- -------------------------------------------------------------------------------- ---
1   ONLINE  /ORADATA/redolog/GTFDBDG/onlinelog/o1_mf_1_cnfrvovo_.log    NO
1   ONLINE  /ORADATA/redolog/GTFDBDG/onlinelog/o1_mf_1_cnfrvpbb_.log    NO
2   ONLINE  /ORADATA/redolog/GTFDBDG/onlinelog/o1_mf_2_cnfrs851_.log    NO
2   ONLINE  /ORADATA/redolog/GTFDBDG/onlinelog/o1_mf_2_cnfrs8kp_.log    NO
3   ONLINE  /ORADATA/redolog/GTFDBDG/onlinelog/o1_mf_3_cnfrlx8d_.log    NO
3   ONLINE  /ORADATA/redolog/GTFDBDG/onlinelog/o1_mf_3_cnfrlxp1_.log    NO
4   ONLINE  /ORADATA/redolog/GTFDBDG/onlinelog/o1_mf_4_cnfrxstd_.log    NO
4   ONLINE  /ORADATA/redolog/GTFDBDG/onlinelog/o1_mf_4_cnfrxt8y_.log    NO
5   ONLINE  /ORADATA/redolog/GTFDBDG/onlinelog/o1_mf_5_cnfrzbq4_.log    NO
5   ONLINE  /ORADATA/redolog/GTFDBDG/onlinelog/o1_mf_5_cnfrzc55_.log    NO
6   ONLINE  /ORADATA/redolog/GTFDBDG/onlinelog/o1_mf_6_cnfs196l_.log    NO

    GROUP# STATUS  TYPE    MEMBER    IS_
---------- ------- ------- -------------------------------------------------------------------------------- ---
6   ONLINE  /ORADATA/redolog/GTFDBDG/onlinelog/o1_mf_6_cnfs19mz_.log    NO
7   ONLINE  /ORADATA/redolog/GTFDBDG/onlinelog/o1_mf_7_cnfs2h63_.log    NO
7   ONLINE  /ORADATA/redolog/GTFDBDG/onlinelog/o1_mf_7_cnfs2hms_.log    NO
8   ONLINE  /ORADATA/redolog/GTFDBDG/onlinelog/o1_mf_8_cnfs4hnv_.log    NO
8   ONLINE  /ORADATA/redolog/GTFDBDG/onlinelog/o1_mf_8_cnfs4j36_.log    NO
10   STANDBY /ORADATA/redolog/GTFDBDG/onlinelog/o1_mf_10_cnfsc27n_.log    NO
10   STANDBY /ORADATA/redolog/GTFDBDG/onlinelog/o1_mf_10_cnfsc2o0_.log    NO
14   STANDBY /ORADATA/redolog/GTFDBDG/onlinelog/o1_mf_14_cnfsc6m6_.log    NO
14   STANDBY /ORADATA/redolog/GTFDBDG/onlinelog/o1_mf_14_cnfsc70p_.log    NO
手动创建出视图里面的日志文件，例如
touch /ORADATA/redolog/GTFDBDG/onlinelog/o1_mf_1_cnfrvovo_.log
touch /ORADATA/redolog/GTFDBDG/onlinelog/o1_mf_1_cnfrvpbb_.log
清空日志组
alter database drop logfile group 1;

4、恢复归档日志

RUN 
{ 
  SET ARCHIVELOG DESTINATION TO '/ORADATA/arc/';
 RESTORE ARCHIVELOG FROM SEQUENCE 27345 UNTIL SEQUENCE 27392 thread 1;
  RESTORE ARCHIVELOG FROM SEQUENCE 9587 UNTIL SEQUENCE 9658 thread 2;
}

5、应用日志
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

6、应用日志完成后，打开数据库

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
 
ALTER DATABASE OPEN;

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;