3
RAC TO RAC搭DG.docx
5墨值下载
RAC TO RAC
搭
DG
背景：
数据库数据量较大，且禁止
sys
远程登录，不能使用
duplicate
方式搭
dg
。只能通过
rman
备份恢复，库比较大备份时间长，主库归档保留时间短。备库预留归档空间充足，采用
先配置
dg
相关参数，在备份的同时传递归档到备库，可节省从磁带恢复归档的时间。
具体操作如下：
1. 备库新建静态监听
oracle 用户：
cd $ORACLE_HOME/network/admin
listener.ora
SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = cendb1)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = cendb1)
)
)
LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.111)(PORT = 15
21
))
)
)
5
10
15
20
25
2.配置 tnsnames
cd $ORACLE_HOME/network/admin
tnsnames.ora：
cendb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.200.1
92
.1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.200.1
92
.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = cendb)
)
)
cendb_adg =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.111)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cendbdg)
)
)
catalog_new=
(description=(address_list=(load_balance=off)(failover=on)
(address=(protocol=tcp)(host=10.200.1
93
.3)(port=1521))
(address=(protocol=tcp)(host=10.200.1
93
.4)(port=1521))
)(connect_data=(service_name=dtmanmdb)
5
10
15
20
25
of 19
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论