物理DG从库损坏后的重建

由于是重建,原来DG环境中被重建的物理从库中的数据文件，日志文件，dump文件等都可以删除，切记原来的参数文件和相应目录一定要保存。主库做standby控制文件和数据库的全备份[Oracle@localhost rman_recover]$ rman target /备份控制文件RMAN> backup current controlfile for standby format "/u01/rman_recover/ctlfile.bak";备份整库RMAN> backup database format "/u01/rman_recover/%full_backup_%T_%t.bak";备库上查找控制文件路径：SQL> select name from v$controlfile;NAME---------------------------------------------/u01/app/oracle/oradata/orcl_s/control01.ctl/u01/app/oracle/oradata/orcl_s/control02.ctl/u01/app/oracle/oradata/orcl_s/control03.ctl SQL> shutdown abortORACLE instance shut down.copy主库的备份到备库[oracle@localhost ~]$ scp 10.37.11.11:/u01/rman_recover/*.bak /u01/rman_recover/

oracle@10.37.11.11"s password: 0ull_backup_20140522_848228743.b 100% 7072KB 6.9MB/s 00:00 7ull_backup_20140522_848228595.b 100% 1002MB 11.9MB/s 01:24 ctlfile.bak 100% 7040KB 6.9MB/s 00:01 验证DG最大性能模式下使用ARCH/LGWR及STANDBY LOG的不同情况 http://www.linuxidc.com/Linux/2014-04/100796.htm将控制文件copy到原配置中：[oracle@localhost rman_recover]$ cp ctlfile.bak /u01/app/oracle/oradata/orcl_s/control01.ctl

[oracle@localhost rman_recover]$ cp ctlfile.bak /u01/app/oracle/oradata/orcl_s/control02.ctl[oracle@localhost rman_recover]$ cp ctlfile.bak /u01/app/oracle/oradata/orcl_s/control03.ctl 启动备库实例：SQL> startup nomountORACLE instance started. Total System Global Area 167772160 bytesFixed Size 1218316 bytesVariable Size 75499764 bytesDatabase Buffers 88080384 bytesRedo Buffers 2973696 bytes更多详情见请继续阅读下一页的精彩内容： http://www.linuxidc.com/Linux/2014-06/103511p2.htm

Oracle实验环境搭建（Windows + Oracle 11g）impdp异常中断导致出现问题的解决相关资讯物理DG从库从库本文评论查看全部评论（0）