oracle dataguard 手册,Oracle dataguard 11G 配置与维护手册

1．判断DataGuard是否安装

select * from v$option where parameter = 'Oracle Data Guard';

2.网络配置

192.168.1.10(orcl)------------------------------------192.168.1.20(dg)

3.监听配置

主库

[oracle@node1 ~]$cd/u01/app/product/11.2.0/db_1/network/admin [oracle@node1 admin]$cat listener.ora

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521)) )

)

[oracle@node1 admin]$cattnsnames.ora

ORCL=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521)) )

(CONNECT_DATA =

(SERVICE_NAME = orcl)

)

)

DG =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = node2)(PORT = 1521)) )

(CONNECT_DATA =

(SERVICE_NAME = dg)