[oracle]Oracle 11g DG搭建(备库使用ASM)

配置信息:

主库

主机名:  r5  

ip:  192.168.0.5 

ORACLE_SID: r5

备库 (注: 备库使用了ASM)

主机名:  r5standby

ip: 192.168.0.9

ORACLE_SID: r5standby

1. 确保两台机器ping主机名能互通(即配置好网络和/etc/hosts解析)

主库/etc/hosts (备库应保持一致)

127.0.0.1               localhost.localdomain localhost
::1             localhost6.localdomain6 localhost6
192.168.0.5     R5.localdomain R5
192.168.0.9     r5standby.localdomain r5standby

2. 创建好主库、备库数据库,配置好监听,确保两台数据库之间可通过tnsname互相连接

主库tnsname.ora (备库应保持一致)

r5 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = R5.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = r5)
    )
  )
r5standby=
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = r5standby.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = r5standby)
      (UR=A)
    )
  )

3. 主备库开启强制日志模式和归档

两库开启强制日志:

alter database force logging;

主库开启归档:

shutdown immediate;
alter database mount;
alter system set log_archive_dest_1='LOCATION=/bak2/archivelog';
alter database archive log;
alter database open;

备库开启归档: 

shutdown immediate;
alter database mount;
alter diskgroup DATA add directory '+DATA/R5STANDBY/ARC1';
alter system set log_archive_dest_1='LOCATION=+DATA/R5STANDBY/ARC1';
alter database archive log;
alter database open;

4. 设置主库参数

alter system set log_archive_config='dg_config=(r5,r5standby)';

alter system set log_archive_dest_1='LOCATION=/bak2/archivelog VALID_FOR=(ALL_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=r5';
alter system set log_archive_dest_2='SERVICE=r5standby LGWR SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=r5standby';
alter sy