oracle 19c rac+adg
1.主库(rac)和备库(单机)环境
Primary Standby
DB Version 19.3.0 19.3.0
HOST IP 192.168.56.101 rac1 192.168.56.102 rac2 192.168.56.110 std
SCAN IP 192.168.56.105 rac-scan
DB_NAME orcl orcl
DB_UNIQUE_NAME orcl std
Instance_Name orcl std
ArchiveFile +arch /oracle/arch/
DB Storage ASM FileSystem
ASM for DB files +DATA/ORCL/DATAFILE/ /oracle/app/oracle/oradata/std/datafile/
ASM for LOG files +DATA/orcl/onlinelog /oracle/app/oracle/oradata/orcl/onlinelog
ASM for TEMP files +DATA/orcl/tempfile/ /oracle/app/oracle/oradata/std/tempfile/
ORACLE_HOME /oracle/app/oracle/dbhome/19c/ /oracle/app/oracle/dbhome/19c/
OS Red Hat Enterprise Linux Server 7.9 Red Hat Enterprise Linux Server 7.9
2.rac主库开启强制日志,归档
[oracle@rac1:/home/oracle]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon May 31 18:50:03 2021
Version 19.3.0.0.0
Copyright © 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> alter system set log_archive_dest_1=‘location=+arch’ sid=’*’ scope=spfile;
System altered.
[root@rac1 ~]# crsctl stat res -t
Name Target State Server State details
Local Resources
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.chad
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ons
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.proxy_advm
OFFLINE OFFLINE rac1 STABLE
OFFLINE OFFLINE rac2 STABLE
Cluster Resources
ora.ARCH.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 ONLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.OCR.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE rac1 Started,STABLE
2 ONLINE ONLINE rac2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE rac2 STABLE
ora.orcl.db
1 ONLINE ONLINE rac1 Open,HOME=/oracle/ap
p/oracle/dbhome/19c,
STABLE
2 ONLINE ONLINE rac2 Open,HOME=/oracle/ap
p/oracle/dbhome/19c,
STABLE
ora.qosmserver
1 ONLINE ONLINE rac2 STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan1.vip
1 ONLINE ONLINE rac2 STABLE
[root@rac1 ~]# srvctl stop database -d orcl
[root@rac1 ~]# crsctl stat res -t
Name Target State Server State details
Local Resources
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.chad
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ons
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.proxy_advm
OFFLINE OFFLINE rac1 STABLE
OFFLINE OFFLINE rac2 STABLE
Cluster Resources
ora.ARCH.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 ONLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.OCR.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE rac1 Started,STABLE
2 ONLINE ONLINE rac2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE rac2 STABLE
ora.orcl.db
1 OFFLINE OFFLINE Instance Shutdown,ST
ABLE
2 OFFLINE OFFLINE Instance Shutdown,ST
ABLE
ora.qosmserver
1 ONLINE ONLINE rac2 STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan1.vip
1 ONLINE ONLINE rac2 STABLE
[root@rac1 ~]# srvctl start database -d orcl -o mount
[root@rac1 ~]# crsctl stat res -t
Name Target State Server State details
Local Resources
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.chad
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ons
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.proxy_advm
OFFLINE OFFLINE rac1 STABLE
OFFLINE OFFLINE rac2 STABLE
Cluster Resources
ora.ARCH.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 ONLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.OCR.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE rac1 Started,STABLE
2 ONLINE ONLINE rac2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE rac2 STABLE
ora.orcl.db
1 ONLINE ONLINE rac1 MOUNTED
2 ONLINE ONLINE rac2 MOUNTED
ora.qosmserver
1 ONLINE ONLINE rac2 STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan1.vip
1 ONLINE ONLINE rac2 STABLE
SQL> alter database archivelog;
Database altered.
两节点打开数据库
SQL> alter database open;
SQL> alter database force logging;
Database altered.
2、修改主库DATAGUARD环境参数
alter system set LOG_ARCHIVE_CONFIG=‘DG_CONFIG=(orcl,std)’ scope=both sid=’’;
alter system set log_archive_dest_1=‘LOCATION=+arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl’ scope=spfile;
alter system set LOG_ARCHIVE_DEST_2=‘SERVICE=std LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=std’ scope=both sid=’’;
alter system set fal_client=‘orcl’ scope=both sid=’’;
alter system set FAL_SERVER=‘std’ scope=both sid=’’;
alter system set standby_file_management=AUTO scope=both sid=’’;
alter system set DB_FILE_NAME_CONVERT=’/oracle/app/oracle/oradata/std/datafile’,’+DATA/orcl/datafile’,’/oracle/app/oracle/oradata/std/tempfile’,’+DATA/orcl/tempfile’ scope=spfile sid=’’;
alter system set LOG_FILE_NAME_CONVERT=’/oracle/app/oracle/oradata/std/onlinelog’,’+DATA/orcl/onlinelog’ scope=spfile sid=’’;
alter system set log_archive_format=’%t_%s_%r.arc’ scope=spfile sid=’’;
alter system set remote_login_passwordfile=‘EXCLUSIVE’ scope=spfile;
alter system set PARALLEL_EXECUTION_MESSAGE_SIZE=8192 scope=spfile;
修改参数后重启生效,然后生成备库参数文件
SQL> create pfile=’/tmp/initstd.ora’ from spfile;
3.主库增加standby日志组,如果主库2组logfile,slr需要至少多一组,每个thread多一组
alter database add standby logfile thread 1 group 5 ‘+data’ size 200m;
alter database add standby logfile thread 1 group 6 ‘+data’ size 200m;
alter database add standby logfile thread 1 group 7 ‘+data’ size 200m;
alter database add standby logfile thread 2 group 8 ‘+data’ size 200m;
alter database add standby logfile thread 2 group 9 ‘+data’ size 200m;
alter database add standby logfile thread 2 group 10 ‘+data’ size 200m;
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_ CON_ID
2 ONLINE +DATA/ORCL/ONLINELOG/group_2.263.1073660143 NO 0
1 ONLINE +DATA/ORCL/ONLINELOG/group_1.262.1073660143 NO 0
3 ONLINE +DATA/ORCL/ONLINELOG/group_3.266.1073660489 NO 0
4 ONLINE +DATA/ORCL/ONLINELOG/group_4.267.1073660489 NO 0
5 STANDBY +DATA/ORCL/ONLINELOG/group_5.269.1073990915 NO 0
6 STANDBY +DATA/ORCL/ONLINELOG/group_6.270.1073990915 NO 0
7 STANDBY +DATA/ORCL/ONLINELOG/group_7.271.1073990915 NO 0
8 STANDBY +DATA/ORCL/ONLINELOG/group_8.272.1073990917 NO 0
9 STANDBY +DATA/ORCL/ONLINELOG/group_9.273.1073990917 NO 0
10 STANDBY +DATA/ORCL/ONLINELOG/group_10.274.1073990917 NO 0
10 rows selected.
4.主备库配置tns别名
主库tnsnames:
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.101)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
std =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.110)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = std)
)
)
备库tnsnames:
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.101)(PORT = 1521))
(LOAD_BALANCE = yes)
(FAILOVER = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
std =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.110)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = std)
)
)
这里要注意主库(rac)配置的是oracle listener,配置完成后tnsping测试一下服务名是否配置正确
5.拷贝参数文件和密码文件到备库
ASMCMD> pwd
+data/orcl/password
ASMCMD> cp pwdorcl.256.998919277 /tmp/orapwstd
copying +data/orcl/password/pwdorcl.256.998919277 -> /tmp/orapwstd
将/tmp目录的参数文件和密码文件拷贝到备库dbs目录(对参数文件,密码文件重命名符合备库实例命名规范)
6.备库创建实例的目录
mkdir -p /oracle/arch
mkdir -p /oracle/app/oracle/oradata/std
mkdir -p /oracle/app/oracle/oradata/std/datafile/
mkdir -p /oracle/app/oracle/oradata/std/tempfile/
mkdir -p /oracle/app/oracle/admin/std/adump/
mkdir -p /oracle/app/oracle/oradata/std/onlinelog/
7.修改备库实例的pfile文件,如下:
[oracle@DG:/oracle/app/oracle/dbhome/19c/dbs]$ cat initstd.ora
orcl1.__data_transfer_cache_size=0
orcl2.__data_transfer_cache_size=0
orcl1.__db_cache_size=721420288
orcl2.__db_cache_size=704643072
orcl1.__inmemory_ext_roarea=0
orcl2.__inmemory_ext_roarea=0
orcl1.__inmemory_ext_rwarea=0
orcl2.__inmemory_ext_rwarea=0
orcl1.__java_pool_size=0
orcl2.__java_pool_size=0
orcl1.__large_pool_size=16777216
orcl2.__large_pool_size=16777216
orcl1.__oracle_base=’/oracle/app/oracle’#ORACLE_BASE set from environment
orcl2.__oracle_base=’/oracle/app/oracle’#ORACLE_BASE set from environment
orcl1.__pga_aggregate_target=419430400
orcl2.__pga_aggregate_target=419430400
orcl1.__sga_target=1241513984
orcl2.__sga_target=1241513984
orcl1.__shared_io_pool_size=67108864
orcl2.__shared_io_pool_size=67108864
orcl1.__shared_pool_size=419430400
orcl2.__shared_pool_size=436207616
orcl1.__streams_pool_size=0
orcl2.__streams_pool_size=0
orcl1.__unified_pga_pool_size=0
orcl2.unified_pga_pool_size=0
*.audit_file_dest=’/oracle/app/oracle/admin/std/adump’
*.audit_trail=‘db’
*.cluster_database=false
*.compatible=‘19.0.0’
*.control_files=’/oracle/app/oracle/oradata/std/control01.ctl’,’/oracle/app/oracle/oradata/std/control02.ctl’
*.db_block_size=8192
*.db_create_file_dest=’/oracle/app/oracle/oradata/std/’
*.db_file_name_convert=’+DATA/orcl/datafile’,’/oracle/app/oracle/oradata/std/datafile’,’+DATA/orcl/tempfile’,’/oracle/app/oracle/oradata/std/tempfile’
*.log_file_name_convert=’+DATA/orcl/onlinelog’,’/oracle/app/oracle/oradata/std/onlinelog’
*.db_name=‘orcl’
*.diagnostic_dest=’/oracle/app/oracle’
*.dispatchers=’(PROTOCOL=TCP) (SERVICE=orclXDB)’
*.fal_client=‘std’
*.fal_server=‘orcl’
family:dw_helper.instance_mode=‘read-only’
orcl1.instance_number=1
orcl2.instance_number=2
*.local_listener=’-oraagent-dummy-’
*.log_archive_format=’%t%s%r.arc’
*.LOG_ARCHIVE_CONFIG=‘DG_CONFIG=(std,orcl)’
*.LOG_ARCHIVE_DEST_1=‘LOCATION=/oracle/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=std’
*.LOG_ARCHIVE_DEST_2=‘SERVICE=orcl LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl’
*.nls_language=‘AMERICAN’
*.nls_territory=‘AMERICA’
*.open_cursors=300
*.parallel_execution_message_size=8192
*.pga_aggregate_target=395m
*.processes=300
*.remote_login_passwordfile=‘EXCLUSIVE’
*.sga_target=1184m
*.standby_file_management=‘AUTO’
orcl2.thread=2
orcl1.thread=1
orcl1.undo_tablespace=‘UNDOTBS1’
orcl2.undo_tablespace=‘UNDOTBS2’
8.增加备库静态监听,启动备库
[oracle@DG:/oracle/app/oracle/dbhome/19c/network/admin]$ cat listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /oracle/app/oracle/dbhome/19c)
(SID_NAME = std)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DG)(PORT = 1521))
)
)
SQL> startup nomount;
[oracle@DG:/oracle/app/oracle/dbhome/19c/network/admin]$ lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 31-MAY-2021 19:56:00
Copyright © 1991, 2019, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DG)(PORT=1521)))
STATUS of the LISTENER
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 31-MAY-2021 15:15:35
Uptime 0 days 4 hr. 40 min. 25 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/app/oracle/dbhome/19c/network/admin/listener.ora
Listener Log File /oracle/app/oracle/diag/tnslsnr/DG/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DG)(PORT=1521)))
Services Summary…
Service “std” has 1 instance(s).
Instance “std”, status UNKNOWN, has 1 handler(s) for this service…
The command completed successfully
9.主库连接备库辅助实例,RMAN恢复备库控制文件及数据文件等
[oracle@rac1:/home/oracle]$ rman target sys/oracle@orcl auxiliary sys/oracle@std
Recovery Manager: Release 19.0.0.0.0 - Production on Mon May 31 19:59:53 2021
Version 19.3.0.0.0
Copyright © 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1601440876)
connected to auxiliary database: ORCL (DBID=1601440876)
RMAN> duplicate target database for standby FROM ACTIVE DATABASE;
Starting Duplicate Db at 31-MAY-21
using channel ORA_AUX_DISK_1
contents of Memory Script:
{
backup as copy reuse
passwordfile auxiliary format ‘/oracle/app/oracle/dbhome/19c/dbs/orapwstd’ ;
}
executing Memory Script
Starting backup at 31-MAY-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=32 instance=orcl1 device type=DISK
Finished backup at 31-MAY-21
contents of Memory Script:
{
restore clone from service ‘orcl’ standby controlfile;
}
executing Memory Script
Starting restore at 31-MAY-21
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 orcl
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
output file name=/oracle/app/oracle/oradata/std/control01.ctl
output file name=/oracle/app/oracle/oradata/std/control02.ctl
Finished restore at 31-MAY-21
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
“/oracle/app/oracle/oradata/std/tempfile/temp.264.1073660149”;
switch clone tempfile all;
set newname for datafile 1 to
“/oracle/app/oracle/oradata/std/datafile/system.257.1073660015”;
set newname for datafile 3 to
“/oracle/app/oracle/oradata/std/datafile/sysaux.258.1073660051”;
set newname for datafile 4 to
“/oracle/app/oracle/oradata/std/datafile/undotbs1.259.1073660075”;
set newname for datafile 5 to
“/oracle/app/oracle/oradata/std/datafile/undotbs2.265.1073660401”;
set newname for datafile 7 to
“/oracle/app/oracle/oradata/std/datafile/users.260.1073660077”;
restore
from nonsparse from service
‘orcl’ clone database
;
sql ‘alter system archive log current’;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /oracle/app/oracle/oradata/std/tempfile/temp.264.1073660149 in control file
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 31-MAY-21
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 orcl
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /oracle/app/oracle/oradata/std/datafile/system.257.1073660015
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 orcl
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00003 to /oracle/app/oracle/oradata/std/datafile/sysaux.258.1073660051
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 orcl
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00004 to /oracle/app/oracle/oradata/std/datafile/undotbs1.259.1073660075
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 orcl
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00005 to /oracle/app/oracle/oradata/std/datafile/undotbs2.265.1073660401
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 orcl
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00007 to /oracle/app/oracle/oradata/std/datafile/users.260.1073660077
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 31-MAY-21
sql statement: alter system archive log current
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=1074016667 file name=/oracle/app/oracle/oradata/std/datafile/system.257.1073660015
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=1074016667 file name=/oracle/app/oracle/oradata/std/datafile/sysaux.258.1073660051
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=1074016667 file name=/oracle/app/oracle/oradata/std/datafile/undotbs1.259.1073660075
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=1074016667 file name=/oracle/app/oracle/oradata/std/datafile/undotbs2.265.1073660401
datafile 7 switched to datafile copy
input datafile copy RECID=5 STAMP=1074016667 file name=/oracle/app/oracle/oradata/std/datafile/users.260.1073660077
Finished Duplicate Db at 31-MAY-21
RMAN> exit
10.开启备库,开启备库MRP进程,检查同步状态
SQL> select open_mode from v$database;
OPEN_MODE
MOUNTED
SQL> alter database open;
Database altered.
SQL> select open_mode from v$database;
OPEN_MODE
READ ONLY
SQL> alter database recover managed standby database disconnect;
Database altered.
SQL> select open_mode from v$database;
OPEN_MODE
READ ONLY WITH APPLY
SQL> select * from v$dataguard_stats;
SOURCE_DBID SOURCE_DB_UNIQUE_NAME NAME VALUE UNIT
TIME_COMPUTED DATUM_TIME CON_ID
1601440876 orcl transport lag +00 00:00:00 day(2) to second(0) interval
05/31/2021 18:04:53 05/31/2021 18:04:52 0
1601440876 orcl apply lag +00 00:00:00 day(2) to second(0) interval
05/31/2021 18:04:53 05/31/2021 18:04:52 0
1601440876 orcl apply finish time day(2) to second(3) interval
05/31/2021 18:04:53 0
0 estimated startup time 32 second
05/31/2021 18:04:53 0
SQL> select PROCESS,PID,STATUS,GROUP#,SEQUENCE# from v$managed_standby;
PROCESS PID STATUS GROUP# SEQUENCE#
ARCH 27953 CONNECTED N/A 0
DGRD 27955 ALLOCATED N/A 0
DGRD 27957 ALLOCATED N/A 0
ARCH 27959 CONNECTED N/A 0
ARCH 27961 CONNECTED N/A 0
ARCH 27963 CONNECTED N/A 0
RFS 28283 IDLE N/A 0
RFS 28285 IDLE 1 23
RFS 28297 IDLE N/A 0
RFS 28299 IDLE N/A 0
RFS 28304 IDLE N/A 0
MRP0 28367 WAIT_FOR_LOG N/A 17
12 rows selected.