Oracle 12C Rac到Rac搭建ADG

1、环境介绍
搭建一套ADG灾备环境。主库环境为12.1.2.0 RAC，备库同主库，软件补丁均已安装。
2、配置步骤
2.1 归档

 select log_mode from v$database;  #####是否为归档模式 alter database force logging;           #####强制归档

2.2 主库standby log

alter database add standby logfile thread 1 group 5  ('+DATADG') size 2048M;alter database add standby logfile thread 1 group 6  ('+DATADG') size 2048M;alter database add standby logfile thread 1 group 7  ('+DATADG') size 2048M;alter database add standby logfile thread 1 group 8  ('+DATADG') size 2048M;alter database add standby logfile thread 1 group 9  ('+DATADG') size 2048M;alter database add standby logfile thread 1 group 10 ('+DATADG') size 2048M;alter database add standby logfile thread 2 group 11    ('+DATADG') size 2048M;alter database add standby logfile thread 2 group 12    ('+DATADG') size 2048M;alter database add standby logfile thread 2 group 13    ('+DATADG') size 2048M;alter database add standby logfile thread 2 group 14    ('+DATADG') size 2048M;alter database add standby logfile thread 2 group 15    ('+DATADG') size 2048M;alter database add standby logfile thread 2 group 16    ('+DATADG') size 2048M;

3、文件
3.1 密码文件

拷贝主库密码文件到备库，最开始放在$ORACLE_HOME/dbs目录下，后续配置完成后，需要将密码文件存放在ASM磁盘组中并进行改名。 scp orapwbmacdb IP: $ORACLE_HOME/dbs1 ASMCMD> pwcopy /u01/app/oracle/product/12.1.0/dbhome_1/dbs/orapwbmacdb1 +datadg/bmacdbdg/password/orapwbmacdbcopying /u01/app/oracle/product/12.1.0/dbhome_1/dbs/orapwbmacdb1 -> +datadg/bmacdbdg/password/orapwbmacdb

3.2 参数文件

拷贝主库参数文件到备库，放在$ORACLE_HOME/dbs目录下，恢复完成后，需要将参数文件存放在ASM磁盘组中，并通过pfile指定其位置。参数文件内容如下：*.audit_file_dest='/u01/app/oracle/admin/bmacdb/adump'*.control_files='+DATADG/BMACDB/control01.ctl','+DATADG/BMACDB/control02.ctl'*.db_file_name_convert='+DATADG/BMACDB/DATAFILE/','+DATADG/BMACDB/DATAFILE/','+SSDDG/BMACDB/DATAFILE/','+DATADG/BMACDB/DATAFILE/','+DATADG/bmacdb/','+DATADG/BMACDB/DATAFILE/'*.db_unique_name='bmacdbdg'*.log_archive_config='DG_CONFIG=(bmacdb,bmacdbdg)'*.log_archive_dest_1='LOCATION=+ARCHDG VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=bmacdbdg'*.log_archive_dest_2='SERVICE=BMACDB1 ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=BMACDB'*.log_file_name_convert='+SSDDG/bmacdb/','+LOGDG/BMACDB/ONLINELOG/'*.fal_server='BMACDB'以上参数时我们需要修改的地方。

3.3 目录结构

mkdir -p /u01/app/oracle/admin/bmacdb/adumpASM：+DATADG/BMACDB/DATAFILE+LOGDG/BMACDB/ONLINELOG创建完目录结构后，启动数据库到nomount状态。startup nomount

3.4 配置监听

在配置ADG开始阶段，需要在备库静态注册监听，搭建完成后，可以将静态注册信息删掉。静态注册信息如下：/u01/app/12.1.0/grid/network/admin/listener.oraSID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (GLOBAL_DBNAME = bmacdbdg)      (ORACLE_HOME = /u01/app/oracle/product/12.1.0/dbhome_1)      (SID_NAME = bmacdb1)    )  )LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER))    )    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 1521))    )  )配置完监听后启动监听，静态监听信息如下：Service "bmacdbdg" has 1 instance(s).  Instance "bmacdb1", status UNKNOWN, has 1 handler(s) for this service...主库连接串配置主库tnsnames.ora新增到备库的连接串，并且在RAC两个节点同时新增：BMACDBDG =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = bmacdbdg)    )  )配置完成后，进行连通性测试：sqlplus sys/password@BMACDBDG as sysdbaSQL*Plus: Release 12.1.0.2.0 Production on Tue Jun 18 14:28:16 2019Copyright (c) 1982, 2014, Oracle.  All rights reserved.备库连接串配置备库tnsnames.ora新增到主库的连接串，并且在RAC两个节点同时新增：BMACDB =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = bmacdb)    )  )配置完成后，进行连通性测试：sqlplus sys/password@BMACDB as sysdbaSQL*Plus: Release 12.1.0.2.0 Production on Tue Jun 18 14:29:29 2019Copyright (c) 1982, 2014, Oracle.  All rights reserved.

4、恢复备库

source /home/oracle/.profile rman target sys/password@BMACDB auxiliary sys/password@BMACDBDG <

5、修改主库参数

alter system set log_archive_config='dg_config=(bmacdb,bmacadg,bmacdg,bmacdbdg)';alter system set log_archive_dest_4='service=BMACDBDG async valid_for=(online_logfiles,primary_role) db_unique_name=bmacdbdg';

6、备库spfile

SQL> create spfile ='+datadg/bmacdbdg/spfilebmacdb.ora' from pfile;File created.oracle@bmacdrdb1:/home/oracle>cd $ORACLE_HOME/dbsoracle@bmacdrdb1:/u01/app/oracle/product/12.1.0/dbhome_1/dbs>cat initbmacdb1.oraspfile ='+datadg/bmacdbdg/spfilebmacdb.ora'

7、备库RAC添加资源

srvctl add database -db bmacdbdg -dbname bmacdb -oraclehome /u01/app/oracle/product/12.1.0/dbhome_1 -dbtype RAC -role PHYSICAL_STANDBYsrvctl add instance -db bmacdbdg -instance bmacdb1 -node bmacdrdb1 srvctl add instance -db bmacdbdg -instance bmacdb2 -node bmacdrdb2 srvctl modify database -db bmacdbdg -spfile '+datadg/bmacdbdg/spfilebmacdb.ora' -pwfile '+datadg/bmacdbdg/password/orapwbmacdb'srvctl modify database -db bmacdbdg -diskgroup DATADG,LOGDG备库配置信息：oracle@bmacdrdb1:/home/oracle>srvctl config database -d bmacdbdgDatabase unique name: bmacdbdgDatabase name: bmacdbOracle home: /u01/app/oracle/product/12.1.0/dbhome_1Oracle user: oracleSpfile: +datadg/bmacdbdg/spfilebmacdb.oraPassword file: +datadg/bmacdbdg/password/orapwbmacdbDomain: Start options: openStop options: immediateDatabase role: PHYSICAL_STANDBYManagement policy: AUTOMATICServer pools: Disk Groups: DATADG,LOGDGMount point paths: Services: Type: RACStart concurrency: Stop concurrency: OSDBA group: dbaOSOPER group: operDatabase instances: bmacdb1,bmacdb2Configured nodes: bmacdrdb1,bmacdrdb2Database is administrator managed

8、应用日志

alter database recover managed standby database disconnect from session;alter database recover managed standby database cancel;alter database open;alter database recover managed standby database using current logfile disconnect;select open_Mode,DATABASE_ROLE from v$database;OPEN_MODE            DATABASE_ROLE-------------------- ----------------READ ONLY WITH APPLY PHYSICAL STANDBY