--环境
主库:双节点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;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26506993/viewspace-2107601/,如需转载,请注明出处,否则将追究法律责任。