Oracle-DG-Multiple-Nodes

2020-04-04

DATA GUARD多节点搭建

由于前面已经写了单节点如何搭建了，多节点的搭建主要是pfile参数文件有所改动，这边主要列出参数文件的格式。

测试环境说明：

系统：CentOS7
数据库版本：12.2.0
主库： 192.168.20.21 db DB_UNIQUE_NAME = orcl
备库1：192.168.20.22 db2 DB_UNIQUE_NAME = dg1
备库2：192.168.20.23 db3 DB_UNIQUE_NAME = dg2

Archive Log配置

orcl:
archive1 –> orcl(local)
archive2 –> dg1
archive3 –> dg2
dg1:
archive1 –> dg1(local)
archive2 –> orcl
dg2:
archive1 –> dg2(local)
archive3 –> orcl

主库pfile文件

*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/oradata/orcl/control02.ctl'
*.db_file_name_convert='/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/orcl'
*.db_name='orcl'
*.DB_UNIQUE_NAME='orcl'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.FAL_CLIENT='orcl'
*.FAL_SERVER='dg1','dg2'
*.local_listener='LOCAL_L1'
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl,dg1,dg2)'
*.LOG_ARCHIVE_DEST_1='location=/u01/app/oracle/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl'
*.LOG_ARCHIVE_DEST_2='SERVICE=dg1 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=dg1'
*.LOG_ARCHIVE_DEST_3='SERVICE=dg2 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=dg2'
*.LOG_ARCHIVE_DEST_STATE_1='enable'
*.LOG_ARCHIVE_DEST_STATE_2='enable'
*.LOG_ARCHIVE_DEST_STATE_3='enable'
*.log_file_name_convert='/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/orcl'
*.STANDBY_FILE_MANAGEMENT='AUTO'

注：log_archive_config_2 对应 dg1 节点的对应的 log_archive_config_2，log_archive_config_3 对应 dg2 中的 log_archive_config_3 ，这非常重用

备库1 pfile文件

*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/oradata/orcl/control02.ctl'#Restore Controlfile
*.db_file_name_convert='/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/orcl'
*.db_name='orcl'
*.DB_UNIQUE_NAME='dg1'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.FAL_CLIENT='dg1'
*.FAL_SERVER='orcl'
*.local_listener='LOCAL_L1'
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl,dg1,dg2)'
*.LOG_ARCHIVE_DEST_1='location=/u01/app/oracle/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=dg1'
*.log_archive_dest_2='service=orcl lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=orcl'
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
*.log_file_name_convert='/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/orcl'
*.STANDBY_FILE_MANAGEMENT='AUTO'

备库2 pfile文件

*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/oradata/orcl/control02.ctl'#Restore Controlfile
*.db_file_name_convert='/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/orcl'
*.db_name='orcl'
*.DB_UNIQUE_NAME='dg2'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.FAL_CLIENT='dg2'
*.FAL_SERVER='orcl'
*.local_listener='LOCAL_L1'
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl,dg1,dg2)'
*.LOG_ARCHIVE_DEST_1='location=/u01/app/oracle/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=dg2'
*.log_archive_dest_3='service=orcl lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=orcl'
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.LOG_ARCHIVE_DEST_STATE_3='ENABLE'
*.log_file_name_convert='/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/orcl'
*.STANDBY_FILE_MANAGEMENT='AUTO'