--测试环境: os:redhat linux(64) primary: ip:192.168.94.198 sid:dgdb1 hostname:dg1 db_unique_name
--测试环境:
os:redhat linux(64)
primary:
ip:192.168.94.198
sid:dgdb1
hostname:dg1
db_unique_name:dgdb1
database:10.2.0.1(64)
standby:
ip:192.168.94.199
sid:dgdb1
hostname:dg2
db_unique_name:dgdb1_s
database:10.2.0.1(64)
--实施dg前的准备工作
--开启数据库logging及数据库archivelog
--开启数据库logging
sql> alter database force logging;
--检查数据库是否开启archivelog
sql> archive log list;
--如果数据库未开启archivelog,,则要开启archivelog
sql> shutdown immediate;
sql> startup mount;
sql> alter database archivelog;
--检查数据库是否开启archivelog
sql> archive log list;
--创建相应目录(根据具体情况,primary和standby端要一致)
--standby:
mkdir –p /export/home/oracle/product/10.2.0/oradata/dgdb1
mkdir –p /export/home/oracle/product/10.2.0/admin/dgdb1/adump
mkdir –p /export/home/oracle/product/10.2.0/admin/dgdb1/bdump
mkdir –p /export/home/oracle/product/10.2.0/admin/dgdb1/cdump
mkdir –p /export/home/oracle/product/10.2.0/admin/dgdb1/udump
mkdir –p /export/home/oracle/product/10.2.0/admin/dgdb1/dpdump
mkdir –p /export/home/oracle/product/10.2.0/admin/dgdb1/pfile
mkdir –p /export/home/oracle/archive
mkdir -p /export/home/oracle/bak
--primary:
mkdir –p /export/home/oracle/archive
mkdir -p /export/home/oracle/bak
--修改或新增listener.ora 和tnsnames.ora(或者用gui工具配置)
--注意:listener.ora 中新增的部分在括号内而非括号外
--primary端:
--listener.ora:
sid_list_listener =
(sid_list =
(sid_desc =
(sid_name = plsextproc)
(oracle_home = /export/home/oracle/product/10.2.0)
(program = extproc)
)
(sid_desc =
(global_dbname = dgdb1)
(oracle_home = /export/home/oracle/product/10.2.0)
(sid_name = dgdb1)
)
)
listener =
(description_list =
(description =
(address = (protocol = tcp)(host = dg1)(port = 1521))
(address = (protocol = ipc)(key = extproc0))
)
)
--tnsnames.ora
dgdb1 =
(description =
(address_list =
(address = (protocol = tcp)(host = 192.168.94.198)(port = 1521))
)
(connect_data =
(server = dedicated)
(service_name = dgdb1)
)
)
dgdb1_s =
(description =
(address_list =
(address = (protocol = tcp)(host = 192.168.94.199)(port = 1521))
)
(connect_data =
(server = dedicated)
(service_name = dgdb1)
)
)
--standby端:
--listener.ora:
sid_list_listener =
(sid_list =
(sid_desc =
(sid_name = plsextproc)
(oracle_home = /export/home/oracle/product/10.2.0)
(program = extproc)
)
(sid_desc =
(global_dbname = dgdb1)
(oracle_home = /export/home/oracle/product/10.2.0)
(sid_name = dgdb1)
)
)
listener =
(description_list =
(description =
(address = (protocol = tcp)(host = dg2)(port = 1521))
(address = (protocol = ipc)(key = extproc0))
)
)
--tnsnames.ora
dgdb1 =
(description =
(address_list =
(address = (protocol = tcp)(host = 192.168.94.198)(port = 1521))
)
(connect_data =
(server = dedicated)
(service_name = dgdb1)
)
)
dgdb1_s =
(description =
(address_list =
(address = (protocol = tcp)(host = 192.168.94.199)(port = 1521))
)
(connect_data =
(server = dedicated)
(service_name = dgdb1)
)
)
