DRO01DMS0 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = JABDW1242)(PORT = 1521))
)
SID_LIST_DRO01DMS0 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = O01DMS0)
(ORACLE_HOME = G:\Oracle\ora102)
(SID_NAME = O01DMS0)
)
)
通过lsnrctl启动listener
2） primary tnsnames 的配置
O01DMS0DR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = jabdw1242)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = O01DMS0)
)
)
测试primary是否能连standby：
C:\Documents and Settings\a105024>tnsping O01DMS0DR
TNS Ping Utility for 32-bit Windows: Version 10.2.0.4.0 - Production on 18-OCT-2
011 02:49:47
Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
G:\Oracle\Ora102\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = jabdw1242)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = O01DMS0)))
OK (40 msec)
3） standby tnsnames 配置
O01DMS0 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = jabdw1241)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = O01DMS0)
)
测试standby是否能连primary：
C:\Documents and Settings\a105024>tnsping O01DMS0
TNS Ping Utility for 32-bit Windows: Version 10.2.0.4.0 - Production on 18-OCT-2
011 02:54:32
Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
G:\oracle\ora102\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = jabdw1241)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = O01DMS0)))
OK (50 msec)
4. 检验同步
1） 接收归档日志
在primary端查询当前最大的归档日志：
PRIMARY>select max(sequence#) from v$archived_log;
MAX(SEQUENCE#)
--------------
475
在standby端查询已传过来的归档日志：
STANDBY>select sequence#, applied from v$archived_log;
SEQUENCE# APP
---------- ---
470 NO
471 NO
472 NO
473 NO
474 NO
475 NO
2） 启动redo apply
STANDBY>alter database recover managed standby database disconnect from session;
Database altered.
STANDBY>select sequence#, applied from v$archived_log;
SEQUENCE# APP
---------- ---
470 YES
471 YES
472 YES
473 YES
474 YES
475 YES