189 8069 5689
这篇文章主要介绍“Oracle中怎么配置RAC + SingleADG”，在日常操作中，相信很多人在Oracle中怎么配置RAC + SingleADG问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”Oracle中怎么配置RAC + SingleADG”的疑惑有所帮助！接下来，请跟着小编一起来学习吧！
创新互联从2013年开始，是专业互联网技术服务公司，拥有项目成都做网站、成都网站设计、成都外贸网站建设网站策划，项目实施与项目整合能力。我们以让每一个梦想脱颖而出为使命，1280元贵州做网站,已为上家服务,为贵州各地企业和个人服务,联系电话:18980820575
主库 | 备库 | |
架构 |
| 单机 |
操作系统 | RedHat Linux 7.7 x64 | RedHat Linux 7.7 x64 |
数据库版本 | Oracle 19.3 | Oracle 19.3 |
IP地址 | 192.168.84.91 | 192.168.84.92 |
SID | woo1 | woo2 | woo |
DB_NAME | woo | woo |
DB_UNIQU_NAME | woo_pri | woosty |
RAC各个节点按如下配置：
[oracle@ora19crac1 ~]$ vi $ORACLE_HOME/network/admin/listener.ora LISTENER = (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.ora LISTENER = (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.ora LISTENER = (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) ) )
所有节点配置如下:
[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) ) )
[root@ora19cadg ~]# tail -2 /etc/hosts 192.168.84.95 scan-ora19cracdb 192.168.84.99 ora19cadg
需要关闭一个实例，在一个实例上做以下操作即可：
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 immediate SQL> startup mount; ORACLE instance started. Total System Global Area 805304088 bytes Fixed Size 9139992 bytes Variable Size 394264576 bytes Database Buffers 394264576 bytes Redo Buffers 7634944 bytes Database 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 a10 SQL> 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
SQL> show parameter db_name NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_name string woo SQL> show parameter uniq NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_unique_name string woo
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';
SQL> alter system set dg_broker_start=true; System altered.
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.[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
[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=10 OPW-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
[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 2020
Version 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 DATABASE
2> FOR STANDBY
3> FROM ACTIVE DATABASE
4> DORECOVER
5> NOFILENAMECHECK;
Starting Duplicate Db at 20-MAR-20
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=434 device type=DISK
current 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-20
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=407 instance=woo1 device type=DISK
Finished backup at 20-MAR-20
contents of Memory Script:
{
restore clone from service 'woo' standby controlfile;
}
executing Memory Script
Starting restore at 20-MAR-20
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service woo
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/DBSoft/oracle/oradata/woo/control01.ctl
Finished 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 file
renamed 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-20
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service woo
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /DBSoft/oracle/oradata/woo/datafile/system.257.1034100693
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:15
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service woo
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00003 to /DBSoft/oracle/oradata/woo/datafile/sysaux.258.1034100727
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:15
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service woo
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00004 to /DBSoft/oracle/oradata/woo/datafile/undotbs1.259.1034100753
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:08
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service woo
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00005 to /DBSoft/oracle/oradata/woo/86b637b62fe07a65e053f706e80a27ca/datafile/system.265.1034101665
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service woo
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00006 to /DBSoft/oracle/oradata/woo/86b637b62fe07a65e053f706e80a27ca/datafile/sysaux.266.1034101665
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service woo
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00007 to /DBSoft/oracle/oradata/woo/datafile/users.260.1034100753
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service woo
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00008 to /DBSoft/oracle/oradata/woo/86b637b62fe07a65e053f706e80a27ca/datafile/undotbs1.267.1034101665
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service woo
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00009 to /DBSoft/oracle/oradata/woo/datafile/undotbs2.269.1034101939
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 20-MAR-20
sql statement: alter system archive log current
current 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-20
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service woo
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=16
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service woo
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=17
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 20-MAR-20
datafile 1 switched to datafile copy
input datafile copy RECID=4 STAMP=1035508216 file name=/DBSoft/oracle/oradata/woo/datafile/system.257.1034100693
datafile 3 switched to datafile copy
input datafile copy RECID=5 STAMP=1035508216 file name=/DBSoft/oracle/oradata/woo/datafile/sysaux.258.1034100727
datafile 4 switched to datafile copy
input datafile copy RECID=6 STAMP=1035508216 file name=/DBSoft/oracle/oradata/woo/datafile/undotbs1.259.1034100753
datafile 5 switched to datafile copy
input datafile copy RECID=7 STAMP=1035508216 file name=/DBSoft/oracle/oradata/woo/86b637b62fe07a65e053f706e80a27ca/datafile/system.265.1034101665
datafile 6 switched to datafile copy
input datafile copy RECID=8 STAMP=1035508216 file name=/DBSoft/oracle/oradata/woo/86b637b62fe07a65e053f706e80a27ca/datafile/sysaux.266.1034101665
datafile 7 switched to datafile copy
input datafile copy RECID=9 STAMP=1035508216 file name=/DBSoft/oracle/oradata/woo/datafile/users.260.1034100753
datafile 8 switched to datafile copy
input datafile copy RECID=10 STAMP=1035508216 file name=/DBSoft/oracle/oradata/woo/86b637b62fe07a65e053f706e80a27ca/datafile/undotbs1.267.1034101665
datafile 9 switched to datafile copy
input 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-20
using 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_.arc
archived 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_.arc
archived log file name=/DBSoft/oracle/fast_recovery_area/woo/WOOSTY/archivelog/2020_03_20/o1_mf_1_16_h779vphh_.arc thread=1 sequence=16
archived log file name=/DBSoft/oracle/fast_recovery_area/woo/WOOSTY/archivelog/2020_03_20/o1_mf_1_17_h779vqp4_.arc thread=1 sequence=17
media recovery complete, elapsed time: 00:00:00
Finished recover at 20-MAR-20
contents of Memory Script:
{
delete clone force archivelog all;
}
executing Memory Script
released channel: ORA_DISK_1
released channel: ORA_AUX_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=407 instance=woo1 device type=DISK
deleted archived log
archived log file name=/DBSoft/oracle/fast_recovery_area/woo/WOOSTY/archivelog/2020_03_20/o1_mf_1_16_h779vphh_.arc RECID=1 STAMP=1035508214
deleted archived log
archived log file name=/DBSoft/oracle/fast_recovery_area/woo/WOOSTY/archivelog/2020_03_20/o1_mf_1_17_h779vqp4_.arc RECID=2 STAMP=1035508215
Deleted 2 objects
Finished Duplicate Db at 20-MAR-20
RMAN>SQL> create spfile from pfile; File created. SQL> startup mount force; ORACLE instance started. Total System Global Area 306183456 bytes Fixed Size 8895776 bytes Variable Size 239075328 bytes Database Buffers 50331648 bytes Redo Buffers 7880704 bytes Database mounted.
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 IDLE redo transport monitor 0 0 IDLE gap manager 0 0 IDLE redo transport timer 0 0 IDLE archive local 0 0 IDLE archive redo 0 0 IDLE archive redo 0 0 IDLE archive redo 0 0 IDLE RFS async 2 8 IDLE RFS async 1 29 IDLE RFS ping 1 29 IDLE ROLE THREAD# SEQUENCE# ACTION ------------------------ ---------- ---------- ------------ RFS ping 2 8 IDLE RFS archive 0 0 IDLE RFS archive 0 0 IDLE RFS archive 0 0 IDLE RFS archive 0 0 IDLE 16 rows selected.
到此，关于“Oracle中怎么配置RAC + SingleADG”的学习就结束了，希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习，快去试试吧！若想继续学习更多相关知识，请继续关注创新互联网站，小编会继续努力为大家带来更多实用的文章！