oracle同步数据adg_Oracle 11g ADG 部署(duplicate)快速参考

本文旨在指导客户完成Oracle 11g的ADG部署工作，主库环境已具备，备库环境已安装完成数据库软件。

环境：RHEL 6.8 + Oracle 11.2.0.4

1.确认主库运行在归档模式

这里设置归档存放路径为/u01/arch：

mkdir /u01/arch

chown oracle:oinstall /u01/arch

SQL>

archive log list

alter system set log_archive_dest_1 = 'LOCATION=/u01/arch';

shutdown immediate

startup mount

alter database archivelog;

alter database open;

archive log list

2.确认主库开启Force Logging

SQL>

select FORCE_LOGGING FROM V$DATABASE;

alter database force logging;

select FORCE_LOGGING FROM V$DATABASE;

3.主库参数文件修改

set linesize 500

col value for a70

col name for a50

select name, value

from v$parameter

where name in ('db_name','db_unique_name','log_archive_config', 'log_archive_dest_1','log_archive_dest_2',

'log_archive_dest_state_1','log_archive_dest_state_2', 'remote_login_passwordfile',

'log_archive_format','log_archive_max_processes','fal_server','db_file_name_convert',

'log_file_name_convert', 'standby_file_management');

alter system set log_archive_config='DG_CONFIG=(jingyu,jingyus)';

alter system set log_archive_dest_1='LOCATION=/u01/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=jingyu';

alter system set log_archive_dest_2='SERVICE=jingyus VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=jingyus';

alter system set log_archive_dest_state_1=enable;

alter system set log_archive_dest_state_2=enable;

alter system set FAL_SERVER='jingyus';

--数据文件路径主备库设计规范(主要依赖于db_unique_name，这里源端和目标端用于数据存储的磁盘组名字一致，用于归档的磁盘组名字不一致，需要转换)：

alter system set db_file_name_convert='jingyus','jingyu' scope=sp