db01:192.168.1.50
db02:192.168.1.51

二、11g ADG部署：

1、pri端和sty端配置静态监听

[oracle@sty admin]$ cat listener.ora
?
# listener.ora Network Configuration File: /DBSoft/oracle/product/11.2.4/dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

? (SID_LIST =

? ? (SID_DESC =

? ? ? (SID_NAME = PLSExtProc)

? ? ? (ORACLE_HOME = /DBSoft/oracle/product/11.2.4/dbhome_1)

? ? (PROGRAM = extproc)

? ? )

? ? ? (SID_DESC =

? ? (SID_NAME = Woo )

? ? (ORACLE_HOME = /DBSoft/oracle/product/11.2.4/dbhome_1)

? ? )

? )

?

[oracle@sty admin]$cat tnsname.ora

# tnsnames.ora Network Configuration File: /DBSoft/oracle/product/11.2.4/dbhome_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

STY =

? (DESCRIPTION =

? ? (ADDRESS_LIST =

? ? ? (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.51)(PORT = 1521))

? ? )

? ? (CONNECT_DATA =

? ? ? (SERVICE_NAME = woo)

? ? )

? )

PRI =

? (DESCRIPTION =

? ? (ADDRESS_LIST =

? ? ? (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.50)(PORT = 1521))

? ? )

? ? (CONNECT_DATA =

? ? ? (SERVICE_NAME = woo)

? ? )

? )

2、修改primary端初始化参数文件

startup mount;
?
alter database archivelog;

alter database force logging;

alter database open;

alter system set log_archive_config = 'DG_CONFIG=(pri,sty)' scope=spfile;

alter system set log_archive_dest_1 = 'LOCATION=/DBBackup/Archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=pri' scope=spfile;

alter system set log_archive_dest_2 = 'SERVICE=sty LGWR SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=sty' scope=spfile;

alter system set log_archive_dest_state_1 = ENABLE;

alter system set log_archive_dest_state_2 = ENABLE;

alter system set fal_server=sty scope=spfile;

alter system set fal_client=pri scope=spfile;

alter system set standby_file_management=AUTO scope=spfile;

3、在primary端pfile参数文件和密码文件，并且拷贝到standby段相应位置

SQL> create pfile from spfile;
?

File created.

[oracle@db01 dbs]$ scp initwoo.ora orapwwoo db02:/DBSoft/oracle/product/11.2.4/dbhome_1/dbs

oracle@192.168.1.51's password:
?initwoo.ora? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 100% 1260? ? 1.2KB/s? 00:00? ?
?orapwwoo? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 100% 1536? ? 1.5KB/s? 00:00

?[oracle@db01 oracle]$ scp -r admin/ diag/ fast_recovery_area/ oradata/ 192.168.1.51:$ORACLE_BASE
?oracle@192.168.1.51's password:
?init.ora.512201522543? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 100% 1778? ? 1.7KB/s? 00:01? ?
?dp.log? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 100%? 116? ? 0.1KB/s? 00:00? ?
?........

? ?

4、修改standby端的监听文件及初始化参数文件

--修改监听文件
?
[oracle@db02 ~]$ cd $ORACLE_HOME/network/admin

[oracle@db02 admin]$ vi listener.ora

# listener.ora Network Configuration File: /DBSoft/oracle/product/11.2.4/dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER =

? (DESCRIPTION_LIST =

? ? (DESCRIPTION =

? ? ? (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

? ? ? (ADDRESS = (PROTOCOL = TCP)(HOST = db02)(PORT = 1521))

? ? )

? )

SID_LIST_LISTENER =

? (SID_LIST =

? ? (SID_DESC =

? ? ? (SID_NAME = PLSExtProc)

? ? ? (ORACLE_HOME = /DBSoft/oracle/product/11.2.4/dbhome_1)

? ? ? (PROGRAM = extproc)

? ? )

? ? (SID_DESC =

? ? ? (GLOBAL_DBNAME = woo)

? ? ? (ORACLE_HOME = /DBSoft/oracle/product/11.2.4/dbhome_1)

? ? ? (SID_NAME = woo)

? ? )

? )

ADR_BASE_LISTENER = /DBSoft/oracle

--启动监听

[oracle@db02 dbs]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 17-JUN-2015 21:29:57

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Starting /DBSoft/oracle/product/11.2.4/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.4.0 - Production

System parameter file is /DBSoft/oracle/product/11.2.4/dbhome_1/network/admin/listener.ora