ORACLE 11g rac+单实例数据库构建dataguard(二)
,member from v$logfile;
GROUP# MEMBER
---------- --------------------------------------------------
1+BYSASMDATA/bysrac/onlinelog/group_1.257.818615137
1+BYSASMDG/bysrac/onlinelog/group_1.257.818615145
2+BYSASMDATA/bysrac/onlinelog/group_2.258.818615153
2+BYSASMDG/bysrac/onlinelog/group_2.258.818615163
3+BYSASMDATA/bysrac/onlinelog/group_3.265.818619941
3+BYSASMDG/bysrac/onlinelog/group_3.259.818619949
4+BYSASMDATA/bysrac/onlinelog/group_4.266.818619961
4+BYSASMDG/bysrac/onlinelog/group_4.260.818619967
二、修改RAC中初始化参数
3.在RAC主库中修改初始化参数
SQL> alter system set standby_file_management=auto scope=spfile;
SQL> alter system set log_archive_config="DG_CONFIG=(bysrac,racdg)"scope=spfile;
SQL> alter system set log_archive_dest_2="SERVICE=racdg LGWRSYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)DB_UNIQUE_NAME=racdg" scope=spfile;
SQL> alter system set fal_server=racdg scope=spfile;
SQL> alter system set fal_client=bysrac;
SQL> alter system setdb_file_name_convert="+BYSASMDATA/bysrac/datafile/","/u01/oradata/racdg",'+BYSASMDATA/bysrac/tempfile/','/u01/oradata/racdg/' scope=spfile;
SQL> alter system set log_file_name_convert="+BYSASMDATA/bysrac/onlinelog/","/u01/oradata/racdg"，'+BYSASMDG/bysrac/onlinelog/','/u01/oradata/racdg/' scope=spfile;
SQL>create pfile='/home/oracle/initaa.ora' from spfile; ------这里创建的PFILE第五步时候发送到备库racdg。
三、配置双方监听互相通过服务名访问
4.双方监听配置文件示例如下：
RAC的listener.ora 就使用RAC安装好后的不用修改。
[oracle@bysrac1 admin]$ cat tnsnames.ora
BYSRAC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = bysrac-cluster-scan)(PORT =1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = bysrac)
)
)
racdg =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = racdg)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdg)
)
)
racdg的tnsnames.ora同上：
[oracle@racdg admin]$ cat listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =racdg.bys.com)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = racdg)
(ORACLE_HOME =/u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = racdg)
)
)
ADR_BASE_LISTENER = /u01
5.发密码及初化参数文件到racdg，并修改初始化参数文件
[oracle@bysrac1 dbs]$ ls
hc_bysrac1.dat initbysrac1.ora orapwbysrac1 peshm_DBUA0_0
hc_DBUA0.dat init.ora peshm_bysrac_1 snapcf_bysrac1.f
[oracle@bysrac1 dbs]$ scp orapwbysrac1racdg:$ORACLE_HOME/dbs/
oracle@racdg's password:
orapwbysrac1 100% 1536 1.5KB/s 00:00
[oracle@bysrac1 dbs]$ cd
[oracle@bysrac1 ~]$ ls
alert_bysrac1.log initaa.ora inittest.ora oradiag_oracle
Desktop initaa.orabak inittest.orabak
[oracle@bysrac1 ~]$ scp inittest.oraracdg:$ORACLE_HOME/dbs
oracle@racdg's password:
inittest.ora 100% 1024 1.0KB/s 00:00
6.在racdg上修改密码及参数文件名，并修改初始化参数
[oracle@racdg dbs]$ ls
inittest.ora orapwbysrac1
[oracle@racdg dbs]$ mv orapwbysrac1 orapwracdg
[oracle@racdg dbs]$ mv initt