RAC 主库配置单实例ADG

写在前面：
最终实现环境：11.2.0.4版本 2节点RAC + 1节点DG
本文旨在弄清楚整个搭建过程中涉及到的基础概念；
本文安装maximum performance mode（最大性能模式）也是DG默认的数据保护模式；

前提环境：
1).主库已安装11.2.0.4版本 RAC数据库

#public ip 192.168.56.150 jyrac1 192.168.56.152 jyrac2 #private ip 10.10.10.11 jyrac1-priv 10.10.10.12 jyrac2-priv #virtual ip 192.168.56.151 jyrac1-vip 192.168.56.153 jyrac2-vip #scan ip 192.168.56.160 jyrac-scan

2).备库已安装同版本软件、监听程序

192.168.56.158 jydg 1.主库准备工作

数据库设置为force logging模式

SQL> alter database force logging;

数据库设置为归档模式（RAC数据库更改归档模式参见文档：How To Enable/Disable Archive Logging In RAC Environment for 10.2 and higher version (文档 ID 1186764.1)）

SQL> alter database archivelog;

检查

SQL> select inst_id, name, open_mode, log_mode, force_logging from gv$database; 2.物理备库准备工作

确保已成功安装同版本数据库软件、监听程序；
配置静态监听，这里的Oracle_HOME是 /u01/app/oracle/product/11.2.0/dbhome_1

SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = jyzhao_s) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME = jyzhao_s) ) ) 3.创建物理备库

3.1 配置tnsnames.ora
主库上配置：

JYZHAO_S = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.158)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = jyzhao_s) ) ) JYZHAO1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.151)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = jyzhao) ) ) JYZHAO2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.153)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = jyzhao) ) )

备库上配置：

JYZHAO_S = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.158)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = jyzhao_s) ) ) JYZHAO = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.160)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = jyzhao) ) ) JYZHAO1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.151)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = jyzhao) ) ) JYZHAO2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.153)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = jyzhao) ) )

3.2 修改主库参数
FAL_CLIENT(确定11g dg官方安装文档中这个参数没有再提，因此只需要设定fal_server)

FAL_CLIENT specifies the FAL (fetch archive log) client name that is used by the FAL service, configured through the FAL_SERVER initialization parameter, to refer to the FAL client. The value is an Oracle Net service name, which is assumed to be configured properly on the FAL server system to point to the FAL client (standby database).
FAL_SERVER specifies the FAL (fetch archive log) server for a standby database. The value is an Oracle Net service name, which is assumed to be configured properly on the standby database system to point to the desired FAL server.

log_archive_config