DG搭建一主两备
5墨值下载
主机名更改：
[root@bogon ~]# vi /etc/hostname
[root@bogon ~]# reboot
主库：
Hosts文件：
Vim /etc/hosts
#pri
10.88.15.134 adg1
#active dataguard standby
10.88.15.52 adg2
10.88.15.135 adg3
备库1：
Vim /etc/hosts
#pri
10.88.15.134 adg1
#active dataguard standby
10.88.15.52 adg2
10.88.15.135 adg3
备库2：
Vim /etc/hosts
#pri
10.88.15.134 adg1
#active dataguard standby
10.88.15.52 adg2
10.88.15.135 adg3
主库:
参数文件：
*.db_unique_name='adg'
*.log_archive_config='dg_config=(adg,standby,standby2)'
*.log_archive_dest_1='location=/oracle/arch valid_for=(all_logfiles,all_roles) db_unique_name=adg'
*.log_archive_dest_2='SERVICE=standby LGWR SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby'
*.log_archive_dest_3='SERVICE=standby2 LGWR SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby2'
*.log_archive_dest_state_1=enable
*.log_archive_dest_state_2=enable
*.log_archive_dest_state_3=enable
*.log_archive_max_processes=5
*.fal_server='standby','standby2'
*.fal_client='adg'
*.standby_file_management='auto'
备库1：
参数文件：
*.db_unique_name='standby'
*.log_archive_config='dg_config=(adg,standby)'
*.log_archive_dest_1='location=/oracle/arch valid_for=(all_logfiles,all_roles) db_unique_name=standby'
*.log_archive_dest_2='SERVICE=adg LGWR SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=adg'
*.log_archive_dest_3='SERVICE=standby2 LGWR SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby2'
*.log_archive_dest_state_1=enable
*.log_archive_dest_state_2=enable
*.log_archive_dest_state_3=enable
*.log_archive_max_processes=5
*.fal_server='adg',’standby2’
*.fal_client='standby'
*.standby_file_management='auto'
*.log_file_name_convert='/oracle/oradata/adg/','/oracle/oradata/adg/'
DG搭建一主两备
2019年5月6日
15:55
分区
DG
搭建一主两备 的第
1
页
*.log_file_name_convert='/oracle/oradata/adg/','/oracle/oradata/adg/'
备库2：
参数文件：
*.db_unique_name='standby2'
*.log_archive_config='dg_config=(adg,standby2)'
*.log_archive_dest_1='location=/oracle/arch valid_for=(all_logfiles,all_roles) db_unique_name=standby2'
*.log_archive_dest_2='SERVICE=adg LGWR SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=adg'
*.log_archive_dest_3='SERVICE=standby LGWR SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby'
*.log_archive_dest_state_1=enable
*.log_archive_dest_state_2=enable
*.log_archive_dest_state_3=enable
*.log_archive_max_processes=5
*.fal_server='adg',’standby’
*.fal_client='standby2'
*.standby_file_management='auto'
*.log_file_name_convert='/oracle/oradata/adg/','/oracle/oradata/adg/'
#不停库的情况下添加参数文件
Alter system set log_archive_config='dg_config=(adg,standby2)' scope=spfile;
主库listener.ora文件：
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = adg)
(ORACLE_HOME = /oracle/product/11.2.0.4)
(SID_NAME = adg)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.88.15.134)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
备库1listener.ora文件：
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = adg)
(ORACLE_HOME = /oracle/product/11.2.0.4)
(SID_NAME = adg)
)
(SID_DESC =
(GLOBAL_DBNAME = standby)
(ORACLE_HOME = /oracle/product/11.2.0.4)
(SID_NAME = adg)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.88.15.52)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = /oracle
分区
DG
搭建一主两备 的第
2
页
of 5
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论