Oracle Dataguard搭建.pdf
50墨值下载
主库不停机搭建 dataguard
前置条件
1、/etc/hosts 下配置好 IP 和主机名
PR
10.73.12.12 btcl-boss-oss-db01
ossdb01_per
10.73.12.13 btcl-boss-oss-db02
ossdb02_per
10.73.12.14 ossdb_serv
10.73.7.11 gr-oss-db01
10.73.7.41 drosscc
DR
10.73.12.12 btcl-boss-oss-db01
10.73.12.13 btcl-boss-oss-db02
10.73.12.14 ossdb_serv
10.73.7.11 gr-oss-db01
10.73.7.41 drosscc
2、/oracle/product/12c/network/admin/目录下 tnsnames.ora 和 listener.ora 配置（此处
tns 主库为 cc，备库为 dr_cc）
PR
root@btcl-boss-oss-db01[/]#cat /oracle/product/12c/network/admin/tnsnames.ora
cc =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.73.12.14)(PORT = 11521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cc)
)
)
DR_CC=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.73.7.41)(PORT = 11521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cc)
)
)
root@btcl-boss-oss-db01[/]#
root@btcl-boss-oss-db01[/]#cat /oracle/product/12c/network/admin/listener.ora
LISTENER_cc =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.73.12.14)(PORT = 11521))
)
)
)
SID_LIST_LISTENER_cc =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = cc)
(ORACLE_HOME = /oracle/product/12c)
(SID_NAME = cc)
)
)
root@btcl-boss-oss-db01[/]#
root@btcl-boss-oss-db01[/]#cat /oracle/product/12c/network/admin/sqlnet.ora
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT = 8
root@btcl-boss-oss-db01[/]#
DR
root@gr-oss-db01:[/]#cat /oracle/product/12c/network/admin/tnsnames.ora
DR_CC=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.73.7.41)(PORT = 11521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cc)
)
)
CC=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.73.12.14)(PORT = 11521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cc)
)
)
root@gr-oss-db01:[/]#
root@gr-oss-db01:[/]#cat /oracle/product/12c/network/admin/listener.ora
LISTENER_cc =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.73.7.41)(PORT = 11521))
)
)
)
SID_LIST_LISTENER_cc =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = cc)
(ORACLE_HOME = /oracle/product/12c)
(SID_NAME = cc)
)
)
root@gr-oss-db01:[/]#
root@gr-oss-db01:[/]#cat /oracle/product/12c/network/admin/sqlnet.ora
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT = 8
root@gr-oss-db01:[/]#
3、listener 监听查看
PR
oracle@btcl-boss-oss-db01[/oracle]$lsnrctl status listener_cc
LSNRCTL for IBM/AIX RISC System/6000: Version 12.2.0.1.0 - Production on 19-OCT-2023
16:53:43
Copyright (c) 1991, 2017, Oracle. All rights reserved.
of 14
50墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
相关文档
评论