Oracle 11g Data guard 物理备库故障恢复重建实例

谁借莪１个温暖的怀抱￠ 2024-04-17 23:58 138阅读 0赞

\--环境  
主库：双节点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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26506993/viewspace-2107601/