0
DG搭建一主两备
907
5页
6次
墨值5
主机名更改:
[root@bogon ~]# vi /etc/hostname
[root@bogon ~]# reboot
主库:
Hosts文件:
Vim /etc/hosts
#pri
10.88.15.134 adg1
10.88.15.52 adg2
10.88.15.135 adg3
备库1
Vim /etc/hosts
#pri
10.88.15.134 adg1
10.88.15.52 adg2
10.88.15.135 adg3
备库2
Vim /etc/hosts
#pri
10.88.15.134 adg1
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搭建一主两备
201956
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
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文档的来源(墨天轮),文档链接,文档作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论

关注
最新上传
暂无内容,敬请期待...
下载排行榜
Top250 周榜 月榜
近期活动
全部
暂无活动,敬请期待...
相关课程
全部