Oracle中怎么配置RAC + SingleADG

这篇文章主要介绍"Oracle中怎么配置RAC + SingleADG"，在日常操作中，相信很多人在Oracle中怎么配置RAC + SingleADG问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答"Oracle中怎么配置RAC + SingleADG"的疑惑有所帮助！接下来，请跟着小编一起来学习吧！

一、 环境介绍

二、 操作步骤

2.1. 配置静态LISTENER.ORA监听

RAC各个节点按如下配置：

[oracle@ora19crac1 ~]$ vi $ORACLE_HOME/network/admin/listener.oraLISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP)(HOST = scan-ora19cracdb)(PORT = 1521))      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))    )  ) SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (GLOBAL_DBNAME = woo_DGMGRL)      (ORACLE_HOME =/u01/app/oracle/product/19.3.0/dbhome_1)      (SID_NAME = woo)    )  ) [oracle@ora19crac2 ~]$ cat $ORACLE_HOME/network/admin/listener.oraLISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP)(HOST = scan-ora19cracdb)(PORT = 1521))      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))    )  ) SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (GLOBAL_DBNAME = woo_DGMGRL)      (ORACLE_HOME =/u01/app/oracle/product/19.3.0/dbhome_1)      (SID_NAME = woo)    )  )

单实例节点配置：

[oracle@ora19cadg ~]$ cat $ORACLE_HOME/network/admin/listener.oraLISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP)(HOST = ora19cadg)(PORT = 1521))      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))    )  ) SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (GLOBAL_DBNAME = woo_DGMGRL)      (ORACLE_HOME =/u01/app/oracle/product/19.3.0/dbhome_1)      (SID_NAME = woo)    )  )

2.2. 配置TNSNAME.ora网络连接文件

所有节点配置如下:

[oracle@ora19crac1 ~]$ cat $ORACLE_HOME/network/admin/tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/19.3.0/dbhome_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools. WOO =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = scan-ora19cracdb)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = woo)    )  )  WOOSTY =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.84.99)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = woosty)      (UR=A)    )  )

2.3. 所有节点在hosts中添加如下解析

[root@ora19cadg ~]# tail -2 /etc/hosts192.168.84.95                   scan-ora19cracdb192.168.84.99                   ora19cadg

2.4. 开启归档和force logging

需要关闭一个实例，在一个实例上做以下操作即可：

SQL> alter database force logging; Database altered. SQL> alter system set db_recovery_file_dest='+FRA_GP01' scope=spfile sid='*'; System altered. SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE=2g scope=spfile sid='*'; System altered. SQL> shut immediateSQL> startup mount;ORACLE instance started. Total System Global Area  805304088 bytesFixed Size                  9139992 bytesVariable Size             394264576 bytesDatabase Buffers          394264576 bytesRedo Buffers                7634944 bytesDatabase mounted.SQL> alter database archivelog; Database altered. SQL> alter database open; Database altered. SQL> alter database flashback on; Database altered. SQL> col force_logging format a10SQL> select name,open_mode,database_role,flashback_on,force_logging from v$database; NAME      OPEN_MODE            DATABASE_ROLE    FLASHBACK_ON       FORCE_LOGG--------- -------------------- ---------------- ------------------ ----------WOO       READ WRITE           PRIMARY          YES                YES

2.5. 检查初始化参数文件

SQL> show parameter db_name NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------db_name                              string      woo SQL> show parameter uniq NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------db_unique_name                       string      woo

2.6. 配置RAC端主库参数

ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(woo,woosty)' sid='*';ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=woo' sid='*';ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=woosty ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=woosty' sid='*';ALTER SYSTEM SET db_file_name_convert='/DBSoft/oracle/oradata/woo/','+DATA_GP01/WOO/'scope=spfile sid='*';ALTER SYSTEM SET log_file_name_convert='/DBSoft/oracle/oradata/woo/','+DATA_GP01/WOO/ONLINELOG/' scope=spfile sid='*';ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO sid='*';ALTER SYSTEM SET FAL_SERVER='woosty';

2.7. 开启Broker

SQL> alter system set dg_broker_start=true; System altered.

2.8. 添加standby日志组

SQL> alter database add standby logfile   2  group 5 ('+DATA_GP01/WOO/ONLINELOG/group_5.log') size 200m; Database altered. SQL> alter database add standby logfile   2  group 6 ('+DATA_GP01/WOO/ONLINELOG/group_6.log') size 200m; Database altered. SQL> alter database add standby logfile   2  group 7 ('+DATA_GP01/WOO/ONLINELOG/group_7.log') size 200m; Database altered. SQL> alter database add standby logfile   2  group 8 ('+DATA_GP01/WOO/ONLINELOG/group_8.log') size 200m; Database altered. SQL> alter database add standby logfile   2  group 9 ('+DATA_GP01/WOO/ONLINELOG/group_9.log') size 200m; Database altered. SQL> select group#,status,type from v$logfile;     GROUP# STATUS  TYPE---------- ------- -------         2         ONLINE         1         ONLINE         3         ONLINE         4         ONLINE         5         STANDBY         6         STANDBY         7         STANDBY         8         STANDBY         9         STANDBY 9 rows selected.

2.9. 备库创建相应目录

[oracle@ora19cadg ~]$ mkdir -p /DBSoft/oracle/oradata/woo/pdbseed[oracle@ora19cadg ~]$ mkdir -p /DBSoft/oracle/fast_recovery_area/woo[oracle@ora19cadg ~]$ mkdir -p /DBSoft/oracle/admin/woo/adump

2.10. 手工创建备库参数文件和密码文件

[oracle@ora19cadg dbs]$ cat initwoo.ora *.audit_file_dest='/DBSoft/oracle/admin/woo/adump'*.audit_trail='db'*.cluster_database=false*.compatible='19.0.0'*.control_files='/DBSoft/oracle/oradata/woo/control01.ctl'*.db_block_size=8192*.db_create_file_dest='/DBSoft/oracle/oradata/woo'*.db_name='woo'*.db_recovery_file_dest='/DBSoft/oracle/fast_recovery_area/woo'*.DB_RECOVERY_FILE_DEST_SIZE = 2g*.diagnostic_dest='/DBSoft/oracle'*.enable_pluggable_database=true*.DB_UNIQUE_NAME=woosty*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(woo,woosty)'*.LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=woosty'*.LOG_ARCHIVE_DEST_2='SERVICE=woo ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=woo'*.db_file_name_convert='+DATA_GP01/WOO/','/DBSoft/oracle/oradata/woo/'*.log_file_name_convert='+DATA_GP01/WOO/ONLINELOG/','/DBSoft/oracle/oradata/woo/'*.STANDBY_FILE_MANAGEMENT=AUTO*.FAL_SERVER='woo' [oracle@ora19cadg dbs]$ orapwd file=orapwwoo password=oracle entries=10OPW-00029: Password complexity failed for SYS user : Password must contain at least 8 characters.[oracle@ora19cadg dbs]$ orapwd file=orapwwoo password=oracle entries=10 format=12

2.11. duplicate standby 数据库

[oracle@ora19cadg admin]$ rman TARGET sys/oracle@woo AUXILIARY sys/oracle@woosty Recovery Manager: Release 19.0.0.0.0 - Production on Fri Mar 20 01:08:52 2020Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved. connected to target database: WOO (DBID=78639635)connected to auxiliary database: WOO (not mounted) RMAN> DUPLICATE TARGET DATABASE2>   FOR STANDBY3>   FROM ACTIVE DATABASE4>   DORECOVER5>   NOFILENAMECHECK; Starting Duplicate Db at 20-MAR-20using target database control file instead of recovery catalogallocated channel: ORA_AUX_DISK_1channel ORA_AUX_DISK_1: SID=434 device type=DISKcurrent log archived contents of Memory Script:{   backup as copy reuse   passwordfile auxiliary format  '/DBSoft/oracle/product/19.3/dbhome_1/dbs/orapwwoo'   ;}executing Memory Script Starting backup at 20-MAR-20allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=407 instance=woo1 device type=DISKFinished backup at 20-MAR-20 contents of Memory Script:{   restore clone from service  'woo' standby controlfile;}executing Memory Script Starting restore at 20-MAR-20using channel ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: starting datafile backup set restorechannel ORA_AUX_DISK_1: using network backup set from service woochannel ORA_AUX_DISK_1: restoring control filechannel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01output file name=/DBSoft/oracle/oradata/woo/control01.ctlFinished restore at 20-MAR-20 contents of Memory Script:{   sql clone 'alter database mount standby database';}executing Memory Script sql statement: alter database mount standby database contents of Memory Script:{   set newname for tempfile  1 to  "/DBSoft/oracle/oradata/woo/tempfile/temp.264.1034100827";   set newname for tempfile  2 to  "/DBSoft/oracle/oradata/woo/9ff1c0f54b74ff37e0535b54a8c0e689/tempfile/temp.268.1034101685";   switch clone tempfile all;   set newname for datafile  1 to  "/DBSoft/oracle/oradata/woo/datafile/system.257.1034100693";   set newname for datafile  3 to  "/DBSoft/oracle/oradata/woo/datafile/sysaux.258.1034100727";   set newname for datafile  4 to  "/DBSoft/oracle/oradata/woo/datafile/undotbs1.259.1034100753";   set newname for datafile  5 to  "/DBSoft/oracle/oradata/woo/86b637b62fe07a65e053f706e80a27ca/datafile/system.265.1034101665";   set newname for datafile  6 to  "/DBSoft/oracle/oradata/woo/86b637b62fe07a65e053f706e80a27ca/datafile/sysaux.266.1034101665";   set newname for datafile  7 to  "/DBSoft/oracle/oradata/woo/datafile/users.260.1034100753";   set newname for datafile  8 to  "/DBSoft/oracle/oradata/woo/86b637b62fe07a65e053f706e80a27ca/datafile/undotbs1.267.1034101665";   set newname for datafile  9 to  "/DBSoft/oracle/oradata/woo/datafile/undotbs2.269.1034101939";   restore   from  nonsparse   from service  'woo'   clone database   ;   sql 'alter system archive log current';}executing Memory Script executing command: SET NEWNAME executing command: SET NEWNAME renamed tempfile 1 to /DBSoft/oracle/oradata/woo/tempfile/temp.264.1034100827 in control filerenamed tempfile 2 to /DBSoft/oracle/oradata/woo/9ff1c0f54b74ff37e0535b54a8c0e689/tempfile/temp.268.1034101685 in control file executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME Starting restore at 20-MAR-20using channel ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: starting datafile backup set restorechannel ORA_AUX_DISK_1: using network backup set from service woochannel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup setchannel ORA_AUX_DISK_1: restoring datafile 00001 to /DBSoft/oracle/oradata/woo/datafile/system.257.1034100693channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:15channel ORA_AUX_DISK_1: starting datafile backup set restorechannel ORA_AUX_DISK_1: using network backup set from service woochannel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup setchannel ORA_AUX_DISK_1: restoring datafile 00003 to /DBSoft/oracle/oradata/woo/datafile/sysaux.258.1034100727channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:15channel ORA_AUX_DISK_1: starting datafile backup set restorechannel ORA_AUX_DISK_1: using network backup set from service woochannel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup setchannel ORA_AUX_DISK_1: restoring datafile 00004 to /DBSoft/oracle/oradata/woo/datafile/undotbs1.259.1034100753channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:08channel ORA_AUX_DISK_1: starting datafile backup set restorechannel ORA_AUX_DISK_1: using network backup set from service woochannel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup setchannel ORA_AUX_DISK_1: restoring datafile 00005 to /DBSoft/oracle/oradata/woo/86b637b62fe07a65e053f706e80a27ca/datafile/system.265.1034101665channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07channel ORA_AUX_DISK_1: starting datafile backup set restorechannel ORA_AUX_DISK_1: using network backup set from service woochannel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup setchannel ORA_AUX_DISK_1: restoring datafile 00006 to /DBSoft/oracle/oradata/woo/86b637b62fe07a65e053f706e80a27ca/datafile/sysaux.266.1034101665channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07channel ORA_AUX_DISK_1: starting datafile backup set restorechannel ORA_AUX_DISK_1: using network backup set from service woochannel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup setchannel ORA_AUX_DISK_1: restoring datafile 00007 to /DBSoft/oracle/oradata/woo/datafile/users.260.1034100753channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02channel ORA_AUX_DISK_1: starting datafile backup set restorechannel ORA_AUX_DISK_1: using network backup set from service woochannel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup setchannel ORA_AUX_DISK_1: restoring datafile 00008 to /DBSoft/oracle/oradata/woo/86b637b62fe07a65e053f706e80a27ca/datafile/undotbs1.267.1034101665channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03channel ORA_AUX_DISK_1: starting datafile backup set restorechannel ORA_AUX_DISK_1: using network backup set from service woochannel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup setchannel ORA_AUX_DISK_1: restoring datafile 00009 to /DBSoft/oracle/oradata/woo/datafile/undotbs2.269.1034101939channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01Finished restore at 20-MAR-20 sql statement: alter system archive log currentcurrent log archived contents of Memory Script:{   restore clone force from service  'woo'            archivelog from scn  3205006;   switch clone datafile all;}executing Memory Script Starting restore at 20-MAR-20using channel ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: starting archived log restore to default destinationchannel ORA_AUX_DISK_1: using network backup set from service woochannel ORA_AUX_DISK_1: restoring archived logarchived log thread=1 sequence=16channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01channel ORA_AUX_DISK_1: starting archived log restore to default destinationchannel ORA_AUX_DISK_1: using network backup set from service woochannel ORA_AUX_DISK_1: restoring archived logarchived log thread=1 sequence=17channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01Finished restore at 20-MAR-20 datafile 1 switched to datafile copyinput datafile copy RECID=4 STAMP=1035508216 file name=/DBSoft/oracle/oradata/woo/datafile/system.257.1034100693datafile 3 switched to datafile copyinput datafile copy RECID=5 STAMP=1035508216 file name=/DBSoft/oracle/oradata/woo/datafile/sysaux.258.1034100727datafile 4 switched to datafile copyinput datafile copy RECID=6 STAMP=1035508216 file name=/DBSoft/oracle/oradata/woo/datafile/undotbs1.259.1034100753datafile 5 switched to datafile copyinput datafile copy RECID=7 STAMP=1035508216 file name=/DBSoft/oracle/oradata/woo/86b637b62fe07a65e053f706e80a27ca/datafile/system.265.1034101665datafile 6 switched to datafile copyinput datafile copy RECID=8 STAMP=1035508216 file name=/DBSoft/oracle/oradata/woo/86b637b62fe07a65e053f706e80a27ca/datafile/sysaux.266.1034101665datafile 7 switched to datafile copyinput datafile copy RECID=9 STAMP=1035508216 file name=/DBSoft/oracle/oradata/woo/datafile/users.260.1034100753datafile 8 switched to datafile copyinput datafile copy RECID=10 STAMP=1035508216 file name=/DBSoft/oracle/oradata/woo/86b637b62fe07a65e053f706e80a27ca/datafile/undotbs1.267.1034101665datafile 9 switched to datafile copyinput datafile copy RECID=11 STAMP=1035508216 file name=/DBSoft/oracle/oradata/woo/datafile/undotbs2.269.1034101939 contents of Memory Script:{   set until scn  3205256;   recover   standby   clone database    delete archivelog   ;}executing Memory Script executing command: SET until clause Starting recover at 20-MAR-20using channel ORA_AUX_DISK_1 starting media recovery archived log for thread 1 with sequence 16 is already on disk as file /DBSoft/oracle/fast_recovery_area/woo/WOOSTY/archivelog/2020_03_20/o1_mf_1_16_h779vphh_.arcarchived log for thread 1 with sequence 17 is already on disk as file /DBSoft/oracle/fast_recovery_area/woo/WOOSTY/archivelog/2020_03_20/o1_mf_1_17_h779vqp4_.arcarchived log file name=/DBSoft/oracle/fast_recovery_area/woo/WOOSTY/archivelog/2020_03_20/o1_mf_1_16_h779vphh_.arc thread=1 sequence=16archived log file name=/DBSoft/oracle/fast_recovery_area/woo/WOOSTY/archivelog/2020_03_20/o1_mf_1_17_h779vqp4_.arc thread=1 sequence=17media recovery complete, elapsed time: 00:00:00Finished recover at 20-MAR-20 contents of Memory Script:{   delete clone force archivelog all;}executing Memory Script released channel: ORA_DISK_1released channel: ORA_AUX_DISK_1allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=407 instance=woo1 device type=DISKdeleted archived logarchived log file name=/DBSoft/oracle/fast_recovery_area/woo/WOOSTY/archivelog/2020_03_20/o1_mf_1_16_h779vphh_.arc RECID=1 STAMP=1035508214deleted archived logarchived log file name=/DBSoft/oracle/fast_recovery_area/woo/WOOSTY/archivelog/2020_03_20/o1_mf_1_17_h779vqp4_.arc RECID=2 STAMP=1035508215Deleted 2 objects Finished Duplicate Db at 20-MAR-20 RMAN>

2.12. 启动数据库到nomount状态并创建spfile

SQL> create spfile from pfile; File created. SQL> startup mount force;ORACLE instance started. Total System Global Area  306183456 bytesFixed Size                  8895776 bytesVariable Size             239075328 bytesDatabase Buffers           50331648 bytesRedo Buffers                7880704 bytesDatabase mounted.

2.13. 启动日志恢复

SQL> recover managed standby database using current logfile disconnect;Media recovery complete.

三、 检查

3.1 查看角色

RAC主库端:

SQL> select name,protection_mode,database_role role, switchover_status from v$database; NAME      PROTECTION_MODE      ROLE             SWITCHOVER_STATUS--------- -------------------- ---------------- --------------------WOO       MAXIMUM PERFORMANCE  PRIMARY          TO STANDBY

单机备库端:

SQL> select name,protection_mode,database_role role,switchover_status from v$database; NAME      PROTECTION_MODE      ROLE             SWITCHOVER_STATUS--------- -------------------- ---------------- --------------------WOO       MAXIMUM PERFORMANCE  PHYSICAL STANDBY NOT ALLOWED SQL> select THREAD#,SEQUENCE#,ARCHIVED,APPLIED,DELETED,STATUS from v$archived_log;    THREAD#  SEQUENCE# ARC APPLIED   DEL S---------- ---------- --- --------- --- -         1         16 YES YES       YES D         1         17 YES YES       YES D         2          7 YES NO        NO  A         1         20 YES NO        NO  A         1         19 YES NO        NO  A         1         21 YES NO        NO  A         1         22 YES NO        NO  A         1         23 YES NO        NO  A         1         24 YES NO        NO  A         1         25 YES NO        NO  A         1         26 YES NO        NO  A    THREAD#  SEQUENCE# ARC APPLIED   DEL S---------- ---------- --- --------- --- -         1         18 YES NO        NO  A         1         27 YES NO        NO  A         1         28 YES NO        NO  A 14 rows selected. SQL> SELECT ROLE, THREAD#, SEQUENCE#, ACTION FROM V$DATAGUARD_PROCESS; ROLE                        THREAD#  SEQUENCE# ACTION------------------------ ---------- ---------- ------------log writer                        0          0 IDLEredo transport monitor            0          0 IDLEgap manager                       0          0 IDLEredo transport timer              0          0 IDLEarchive local                     0          0 IDLEarchive redo                      0          0 IDLEarchive redo                      0          0 IDLEarchive redo                      0          0 IDLERFS async                         2          8 IDLERFS async                         1         29 IDLERFS ping                          1         29 IDLE ROLE                        THREAD#  SEQUENCE# ACTION------------------------ ---------- ---------- ------------RFS ping                          2          8 IDLERFS archive                       0          0 IDLERFS archive                       0          0 IDLERFS archive                       0          0 IDLERFS archive                       0          0 IDLE 16 rows selected.

到此，关于"Oracle中怎么配置RAC + SingleADG"的学习就结束了，希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习，快去试试吧！若想继续学习更多相关知识，请继续关注网站，小编会继续努力为大家带来更多实用的文章！