本文档详细介绍了如何在Centos6.7环境下，使用duplicate搭建Oracle 11.2.0.4.0数据库的Active Data Guard (ADG)。步骤包括关闭防火墙、配置监听、修改参数、创建日志目录和从库日志组、传输密码文件和pfile文件到备库，以及启动备库并进行duplicate操作，最终完成ADG的配置和数据同步测试。
1：配置情况（主库需要建立实例，从库只需要安装软件）
主库
Centos6.7
Oracle 11.2.0.4.0
IP:192.168.1.155 sid:orcl
备库
Centos6.7
Oracle 11.2.0.4.0软件
IP：192.168.1.156
2：关闭防火墙(两边都需要操作)
lsnrctl iptables stop
chkconfig iptables off
3:配置监听
主库
修改listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = dg1)
(ORACLE_HOME = /u01/oracle/11g)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dg1)(PORT = 1521))
)
)
)
修改tnsnames.ora
dg1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.155)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dg1)
)
)
dg2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.156)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dg2)
)
)
for_db =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.155)(PORT = 1521))
)
备库
修改listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = dg2)
(ORACLE_HOME = /u01/oracle/11g)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dg2)(PORT = 1521))
)
)
)
修改tnsnames.ora
dg1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.155)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dg1)
)
)
dg2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.156)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dg2)
)
)
for_db =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.156)(PORT = 1521))
Note:配置完，tnsping dg1，tnsping dg2出现下面信息，表示互通。
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.155)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = dg1)))
OK (20 msec)
4：配置传输目录和添加日志组（主库）
4.1 创建日志目录和从库日志目录
mkdir -p /u01/archivelog
mkdir -p /u01/standbylog
4.2 修改参数
SQL> alter database force logging;
Database altered.
SQ
最低0.47元/天 解锁文章
扫一扫
1177
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
