rgb_rgb的博客

原文：http://www.oracle-base.com/articles/11g/data-guard-setup-11gr2.phpData Guard Physical Standby Setup in Oracle Database 11g Release 2Data Guard is the name for Oracle's standby database solution

今天成功安装了一个测试环境，安装方法记录如下。Oracle 11gR2 Active Data Guard 安装配置 一、测试环境 主库(primary):os: oracle linux 5.8IP:129.100.253.62主机名：pc01primary database:11.2.0.3 single node+asm数据库名：sgerp5 从库

--logical standby:--1.查看logical standby上当前正在apply的redo logcolumn dict_begin format a15;column file_name format a30;set numf 9999999;col fchange# format 9999999999999;col nchange# for 99999

主备库切换后，归档日志不能自动传送分析在备库上运行：show parameter log_archive_config--alter system set log_archive_config='DG_CONFIG=(sg02,sg01)' scope=spfile;SQL>  SELECT MESSAGE FROM V$DATAGUARD_STATUS;MESSAGE

on Jul 17 09:01:24 2017Media Recovery Log /oraarch/2_399352_718202774.dbfMon Jul 17 09:02:38 2017Media Recovery Log /oraarch/1_507473_718202774.dbfMon Jul 17 09:03:53 2017Media Recovery Log