Oracle 11g RAC to 11g RAC ADG部署搭建

一、目标端软件环境准备

操作系统：CentOS Linux release 6.8
数据库：oracle 11.2.0.4 R2 RAC
只需要安装grid软件和oracle软件即可

二、手工创建磁盘组

GI、ORACLE软件安装后，需要创建磁盘组安装DB，磁盘组名称和源端保持一致

三、rac adg部署

1.DG基础环境
主库rac环境节点一: 192.168.20.15 crm-scan | db_name=orcldb db_unique_name=orcldb service_names=orcldb |主机名：db1
备库rac环境节点一：192.168.20.56 bossdb-scan | db_name=orcldb db_unique_name=orcldbst service_names=orcldb |主机名：db51

2.主库开启强制归档以及开启归档模，以及修改主库初始化参数
开启强制归档
alter database force logging;
select force_logging from v$database;

3.主库配置归档删除策略
$ rman target /
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;
RMAN> show all;

RMAN configuration parameters for database with db_unique_name NXDB are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_NXDB1.f'; # default

RMAN> 

4.主库添加standby redo logfile

添加日志规则：
如果节点RAC主库每个thread redo log有N组，standby redo log则需要standbby redo log组数为(n+1)*thread组。
主库查询redo 日志组数，有2个thread，每个thread有4组日志，standby则需要10组

===================================================================
#查看 Online redo log 大小及位置：
SQL> select group#,thread#,members,bytes from v$log;

    GROUP#    THREAD#    MEMBERS      BYTES
---------- ---------- ---------- ----------
         1          1          1   52428800
         2          1          1   52428800
         3          2          1   52428800
         4          2          1   52428800

SQL> select group#,member from v$logfile;
----GROUP#----------MEMBER--------------------------------------
     2            +DATA01/NXDB/redo02.log
     1            +DATA01/NXDB/redo01.log
     3            +DATA01/NXDB/redo03.log
     4            +DATA01/NXDB/redo04.log

#添加Standby redo log
alter database add standby logfile thread 1 group 5 '+DATA01/NXDB/redo05_1.log' size 50M;
alter database add standby logfile thread 1 group 6 '+DATA01/NXDB/redo06_1.log' size 50M;
alter database add standby logfile thread 1 group 7 '+DATA01/NXDB/redo07_1.log' size 50M;
alter database add standby logfile thread 2 group 8 '+DATA01/NXDB/redo08_1.log' size 50M;
alter database add standby logfile thread 2 group 9 '+DATA01/NXDB/redo09_1.log' size 50M;
alter database add standby logfile thread 2 group 10 '+DATA01/NXDB/redo10_1.log' size 50M;
#检查确认
SQL> select group#,thread#,bytes/1024/1024 Size_MB from v$log;

    GROUP#    THREAD#    SIZE_MB
---------- ---------- ----------
         1          1         50
         2          1         50
         3          2         50
         4          2         50

SQL> select group#,thread#,bytes/1024/1024 size_Mb from v$standby_log;

    GROUP#    THREAD#    SIZE_MB
---------- ---------- ----------
         5          1         50
         6          1         50
         7          1         50
         8          2         50
         9          2         50
        10          2         50

6 rows selected.

5.主库和备库监听配置以及TNS配置
以oracle用户在主库所有节点上配置 tnsname.ora
vi /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

NXDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = NXDB1-vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = NXDB)
    )
  )

NXYLDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = NXYLDB1-vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = NXDB)
    )
  )

将主库的tnsnames.ora文件拷贝到备库的所有节点，将修改如下，将名称替换下
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin

scp tnsnames.ora NXYLDB1:/u01/app/oracle/product/11.2.0/dbhome_1/network/admin
scp tnsnames.ora NXYLDB2:/u01/app/oracle/product/11.2.0/dbhome_1/network/admin

登陆备库查看效果如下：
[oracle@NXDB2 admin]$ vi tnsnames.ora 
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

NXYLDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = NXDB1-vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = NXYLDB)
    )
  )

NXDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = NXYLDB1-vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = NXDB)
    )
  )

6.配置主库 ADG 参数
1、备份spfile文件
create pfile=’/u01/initbak20211013.ora’ from spfile;

2、配置主库参数
alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(NXDB,NXYLDB)' scope=both;
alter system set LOG_ARCHIVE_DEST_1='LOCATION=+data01/NXDB/archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=NXDB' scope=both;
alter system set log_archive_dest_2='SERVICE=NXYLDB SYNC NOAFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=NXYLDB' scope=both;
alter system set LOG_ARCHIVE_DEST_STATE_1='ENABLE' scope=both;
alter system set LOG_ARCHIVE_DEST_STATE_2='ENABLE' scope=both;
alter system set LOG_FILE_NAME_CONVERT='+DATA01/NXDB','+DATA01/NXDB' scope=spfile;
alter system set DB_FILE_NAME_CONVERT='+DATA01/NXDB','+DATA01/NXDB' scope=spfile;
alter system set STANDBY_FILE_MANAGEMENT='AUTO' scope=both;
alter system set FAL_SERVER='NXYLDB' scope=both;

                                                 
                                                 
3、重启数据库
srvctl stop database -d NXDB
srvctl start database -d NXDB