It’s not something new in 19c, however, this feature has been improved and covers all the steps that a DBA must do or was supposed to do in the past in order to recover a lagging standby. I will simulate it and this is my setup:
I have created a dataguard environment using Vagrant.
The primary was created using the following:
dbca -silent -createDatabase \
-templateName General_Purpose.dbc \
-sid ${ORACLE_SID} \
-responseFile NO_VALUE \
-gdbname ${DB_NAME}${DB_DOMAIN_STR} \
-characterSet AL32UTF8 \
-sysPassword ${SYS_PASSWORD} \
-systemPassword ${SYS_PASSWORD} \
-createAsContainerDatabase false \
-numberOfPDBs 1 \
-pdbName ${PDB_NAME} \
-pdbAdminPassword ${PDB_PASSWORD} \
-databaseType MULTIPURPOSE \
-automaticMemoryManagement false \
-totalMemory 2048 \
-storageType FS \
-datafileDestination ${DATA_DIR} \
-redoLogFileSize 50 \
-emConfiguration NONE \
-initparams db_name=${DB_NAME},db_unique_name=${NODE1_DB_UNIQUE_NAME} \
-ignorePreReqs
And the standbys were created using the DUPLICATE command:
DUPLICATE TARGET DATABASE
FOR STANDBY
FROM ACTIVE DATABASE
DORECOVER
SPFILE
SET db_unique_name '${NODE2_DB_UNIQUE_NAME}'
SET audit_file_dest '/u01/app/oracle/admin/${NODE2_DB_UNIQUE_NAME^^}/adump'
SET control_files '/u01/oradata/${NODE2_DB_UNIQUE_NAME^^}/control01.ctl','/u01/oradata/${NODE2_DB_UNIQUE_NAME^^}/control02.ctl'
SET standby_file_management 'AUTO'
SET log_file_name_convert '/u01/oradata/${NODE1_DB_UNIQUE_NAME^^}','/u01/oradata/${NODE2_DB_UNIQUE_NAME^^}'
SET db_file_name_convert '/u01/oradata/${NODE1_DB_UNIQUE_NAME^^}','/u01/oradata/${NODE2_DB_UNIQUE_NAME^^}'
SET db_recovery_file_dest_size '20G'
SET db_recovery_file_dest '/u01/app/oracle'
SET dg_broker_start 'FALSE'
NOFILENAMECHECK;
----------------------------------------------------------------------------------------------
DUPLICATE TARGET DATABASE
FOR STANDBY
FROM ACTIVE DATABASE
DORECOVER
SPFILE
SET db_unique_name '${NODE3_DB_UNIQUE_NAME}'
SET audit_file_dest '/u01/app/oracle/admin/${NODE3_DB_UNIQUE_NAME^^}/adump'
SET control_files '/u01/oradata/${NODE3_DB_UNIQUE_NAME^^}/control01.ctl','/u01/oradata/${NODE3_DB_UNIQUE_NAME^^}/control02.ctl'
SET standby_file_management 'AUTO'
SET log_file_name_convert '/u01/oradata/${NODE1_DB_UNIQUE_NAME^^}','/u01/oradata/${NODE3_DB_UNIQUE_NAME^^}'
SET db_file_name_convert '/u01/oradata/${NODE1_DB_UNIQUE_NAME^^}','/u01/oradata/${NODE3_DB_UNIQUE_NAME^^}'
SET db_recovery_file_dest_size '20G'
SET db_recovery_file_dest '/u01/app/oracle'
SET dg_broker_start 'FALSE'
NOFILENAMECHECK;
And the broker config was created using the following:
CREATE CONFIGURATION my_dg_config AS PRIMARY DATABASE IS ${NODE1_DB_UNIQUE_NAME} CONNECT IDENTIFIER IS ${NODE1_DB_UNIQUE_NAME}${DB_DOMAIN_STR};
ADD DATABASE ${NODE2_DB_UNIQUE_NAME} AS CONNECT IDENTIFIER IS ${NODE2_DB_UNIQUE_NAME}${DB_DOMAIN_STR} MAINTAINED AS PHYSICAL;
ADD DATABASE ${NODE3_DB_UNIQUE_NAME} AS CONNECT IDENTIFIER IS ${NODE3_DB_UNIQUE_NAME}${DB_DOMAIN_STR} MAINTAINED AS PHYSICAL;
ENABLE CONFIGURATION;
SHOW CONFIGURATION;
SHOW DATABASE ${NODE1_DB_UNIQUE_NAME};
SHOW DATABASE ${NODE2_DB_UNIQUE_NAME};
SHOW DATABASE ${NODE3_DB_UNIQUE_NAME};
Now I have the following configuration:
Configuration - my_dg_config
Protection Mode: MaxPerformance
Members:
orcl_dga - Primary database
orcl_dgb - Physical standby database
orcl_dgc - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 49 seconds ago)
Now let’s disable the transport of the archivelogs from PRIMARY (orcl_dga) to the standbys
DGMGRL> edit database orcl_dga set state=transport-off; Succeeded. DGMGRL>
Let’s switch couple of times the archivelogs:
DGMGRL> sql 'alter system switch logfile'; Succeeded. DGMGRL> / Succeeded. DGMGRL> / Succeeded. DGMGRL>
Let’s delete the archivelogs on PRIMARY:
RMAN> delete force noprompt archivelog all;
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=287 device type=DISK
List of Archived Log Copies for database with db_unique_name ORCL_DGA
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
59 1 54 A 29-MAR-21
Name: /u01/app/oracle/ORCL_DGA/archivelog/2021_03_29/o1_mf_1_54_j62y9ssl_.arc
62 1 55 A 29-MAR-21
Name: /u01/app/oracle/ORCL_DGA/archivelog/2021_03_29/o1_mf_1_55_j62ycpf6_.arc
65 1 56 A 29-MAR-21
Name: /u01/app/oracle/ORCL_DGA/archivelog/2021_03_29/o1_mf_1_56_j62ycs4w_.arc
68 1 57 A 29-MAR-21
Name: /u01/app/oracle/ORCL_DGA/archivelog/2021_03_29/o1_mf_1_57_j62yt2yl_.arc
71 1 58 A 29-MAR-21
Name: /u01/app/oracle/ORCL_DGA/archivelog/2021_03_29/o1_mf_1_58_j62ytbcz_.arc
74 1 59 A 29-MAR-21
Name: /u01/app/oracle/ORCL_DGA/archivelog/2021_03_29/o1_mf_1_59_j62ytmpb_.arc
77 1 60 A 29-MAR-21
Name: /u01/app/oracle/ORCL_DGA/archivelog/2021_03_29/o1_mf_1_60_j63ozvdj_.arc
80 1 61 A 29-MAR-21
Name: /u01/app/oracle/ORCL_DGA/archivelog/2021_03_29/o1_mf_1_61_j63p01jv_.arc
83 1 62 A 29-MAR-21
Name: /u01/app/oracle/ORCL_DGA/archivelog/2021_03_29/o1_mf_1_62_j63p09qz_.arc
86 1 63 A 29-MAR-21
Name: /u01/app/oracle/ORCL_DGA/archivelog/2021_03_29/o1_mf_1_63_j63p4lmn_.arc
89 1 64 A 29-MAR-21
Name: /u01/app/oracle/ORCL_DGA/archivelog/2021_03_29/o1_mf_1_64_j63p4mjd_.arc
90 1 65 A 29-MAR-21
Name: /u01/app/oracle/ORCL_DGA/archivelog/2021_03_29/o1_mf_1_65_j63p4n40_.arc
deleted archived log
archived log file name=/u01/app/oracle/ORCL_DGA/archivelog/2021_03_29/o1_mf_1_54_j62y9ssl_.arc RECID=59 STAMP=1068447161
deleted archived log
archived log file name=/u01/app/oracle/ORCL_DGA/archivelog/2021_03_29/o1_mf_1_55_j62ycpf6_.arc RECID=62 STAMP=1068447222
deleted archived log
archived log file name=/u01/app/oracle/ORCL_DGA/archivelog/2021_03_29/o1_mf_1_56_j62ycs4w_.arc RECID=65 STAMP=1068447225
deleted archived log
archived log file name=/u01/app/oracle/ORCL_DGA/archivelog/2021_03_29/o1_mf_1_57_j62yt2yl_.arc RECID=68 STAMP=1068447683
deleted archived log
archived log file name=/u01/app/oracle/ORCL_DGA/archivelog/2021_03_29/o1_mf_1_58_j62ytbcz_.arc RECID=71 STAMP=1068447690
deleted archived log
archived log file name=/u01/app/oracle/ORCL_DGA/archivelog/2021_03_29/o1_mf_1_59_j62ytmpb_.arc RECID=74 STAMP=1068447699
deleted archived log
archived log file name=/u01/app/oracle/ORCL_DGA/archivelog/2021_03_29/o1_mf_1_60_j63ozvdj_.arc RECID=77 STAMP=1068471419
deleted archived log
archived log file name=/u01/app/oracle/ORCL_DGA/archivelog/2021_03_29/o1_mf_1_61_j63p01jv_.arc RECID=80 STAMP=1068471425
deleted archived log
archived log file name=/u01/app/oracle/ORCL_DGA/archivelog/2021_03_29/o1_mf_1_62_j63p09qz_.arc RECID=83 STAMP=1068471433
deleted archived log
archived log file name=/u01/app/oracle/ORCL_DGA/archivelog/2021_03_29/o1_mf_1_63_j63p4lmn_.arc RECID=86 STAMP=1068471570
deleted archived log
archived log file name=/u01/app/oracle/ORCL_DGA/archivelog/2021_03_29/o1_mf_1_64_j63p4mjd_.arc RECID=89 STAMP=1068471571
deleted archived log
archived log file name=/u01/app/oracle/ORCL_DGA/archivelog/2021_03_29/o1_mf_1_65_j63p4n40_.arc RECID=90 STAMP=1068471572
Deleted 12 objects
RMAN>
Set back the transport on on PRIMARY database
DGMGRL> edit database orcl_dga set state=transport-on; Succeeded. DGMGRL>
Let’s see what’s the situation on the standbys:
ORCL_DGB
PR00 (PID:17996): FAL: Failed to request gap sequence PR00 (PID:17996): GAP - thread 1 sequence 64-65 PR00 (PID:17996): DBID 1596176186 branch 1068395452 PR00 (PID:17996): FAL: All defined FAL servers have been attempted PR00 (PID:17996): ------------------------------------------------------------------------- PR00 (PID:17996): Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization PR00 (PID:17996): parameter is defined to a value that's sufficiently large PR00 (PID:17996): enough to maintain adequate log switch information to resolve PR00 (PID:17996): archived redo log gaps. PR00 (PID:17996): -------------------------------------------------------------------------
ORCL_DGC
PR00 (PID:17439): FAL: Failed to request gap sequence PR00 (PID:17439): GAP - thread 1 sequence 64-65 PR00 (PID:17439): DBID 1596176186 branch 1068395452 PR00 (PID:17439): FAL: All defined FAL servers have been attempted PR00 (PID:17439): ------------------------------------------------------------------------- PR00 (PID:17439): Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization PR00 (PID:17439): parameter is defined to a value that's sufficiently large PR00 (PID:17439): enough to maintain adequate log switch information to resolve PR00 (PID:17439): archived redo log gaps. PR00 (PID:17439): -------------------------------------------------------------------------
Both databases are complaining about missing archivelogs.
Let’s recover the ORCL_DGB database. For this we are going to use RMAN
[oracle@ol8-19-dg2 ~]$ rman target / Recovery Manager: Release 19.0.0.0.0 - Production on Mon Mar 29 13:59:14 2021 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL (DBID=1596176186, not open) RMAN> recover standby database from service orcl_dga; Starting recover at 29-MAR-21 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 03/29/2021 13:59:29 RMAN-05150: Managed Recovery Process must be disabled before running RECOVER STANDBY DATABASE. RMAN>
To fix this, we need to disable the recovery on the standby databases:
DGMGRL> edit database orcl_dgb set state=apply-off; Succeeded. DGMGRL> edit database orcl_dgc set state=apply-off; Succeeded. DGMGRL>
Let’s try again to recover it:
RMAN> recover standby database from service orcl_dga;
Starting recover at 29-MAR-21
using target database control file instead of recovery catalog
Oracle instance started
Total System Global Area 1610609200 bytes
Fixed Size 8897072 bytes
Variable Size 385875968 bytes
Database Buffers 1207959552 bytes
Redo Buffers 7876608 bytes
contents of Memory Script:
{
restore standby controlfile from service 'orcl_dga';
alter database mount standby database;
}
executing Memory Script
Starting restore at 29-MAR-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=256 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: using network backup set from service orcl_dga
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/oradata/ORCL_DGB/control01.ctl
output file name=/u01/oradata/ORCL_DGB/control02.ctl
Finished restore at 29-MAR-21
released channel: ORA_DISK_1
Statement processed
Executing: alter system set standby_file_management=manual
contents of Memory Script:
{
recover database from service 'orcl_dga';
}
executing Memory Script
Starting recover at 29-MAR-21
Starting implicit crosscheck backup at 29-MAR-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=256 device type=DISK
Crosschecked 2 objects
Finished implicit crosscheck backup at 29-MAR-21
Starting implicit crosscheck copy at 29-MAR-21
using channel ORA_DISK_1
Finished implicit crosscheck copy at 29-MAR-21
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_28/o1_mf_1_38_j61nyy9t_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_28/o1_mf_1_40_j61nyybh_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_28/o1_mf_1_39_j61nyyc4_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_28/o1_mf_1_41_j61nz2n3_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_29/o1_mf_1_42_j62xpvo9_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_29/o1_mf_1_43_j62xq8fv_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_29/o1_mf_1_44_j62xqd29_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_29/o1_mf_1_45_j62xxywd_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_29/o1_mf_1_46_j62xy4nk_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_29/o1_mf_1_47_j62xy4rw_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_29/o1_mf_1_48_j62y5t3z_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_29/o1_mf_1_49_j62y5y1c_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_29/o1_mf_1_50_j62y7568_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_29/o1_mf_1_54_j62y9tks_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_29/o1_mf_1_55_j62ycq3o_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_29/o1_mf_1_56_j62ycs8w_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_29/o1_mf_1_57_j62yt33l_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_29/o1_mf_1_58_j62ytbn1_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_29/o1_mf_1_59_j62ytmyv_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_29/o1_mf_1_60_j63ozvon_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_29/o1_mf_1_61_j63p01sv_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_29/o1_mf_1_62_j63p0b1s_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_29/o1_mf_1_63_j63p4lty_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_29/o1_mf_1_70_j63pnfcm_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_29/o1_mf_1_67_j63pnfs1_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_29/o1_mf_1_68_j63pnfv8_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_29/o1_mf_1_69_j63pnfyh_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_29/o1_mf_1_66_j63png3h_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_29/o1_mf_1_71_j63ppqvk_.arc
File Name: /u01/app/oracle/ORCL_DGB/archivelog/2021_03_29/o1_mf_1_72_j63pq2k9_.arc
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service orcl_dga
destination for restore of datafile 00001: /u01/oradata/ORCL_DGB/system01.dbf
channel ORA_DISK_1: restore complete, elapsed time: 00:00:08
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service orcl_dga
destination for restore of datafile 00003: /u01/oradata/ORCL_DGB/sysaux01.dbf
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service orcl_dga
destination for restore of datafile 00004: /u01/oradata/ORCL_DGB/undotbs01.dbf
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service orcl_dga
destination for restore of datafile 00007: /u01/oradata/ORCL_DGB/users01.dbf
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
starting media recovery
media recovery complete, elapsed time: 00:00:00
Finished recover at 29-MAR-21
Executing: alter system set standby_file_management=auto
Finished recover at 29-MAR-21
RMAN>
Let’s enable the apply on this standby database:
DGMGRL> edit database orcl_dgb set state=apply-on; Succeeded.
And this is what the alert log is looking like:
[oracle@ol8-19-dg2 ~]$ tail -f /u01/app/oracle/diag/rdbms/orcl_dgb/orcl/trace/alert_orcl.log TT02 (PID:18205): Waiting for all non-current ORLs to be archived 2021-03-29T14:05:03.963029+00:00 TT02 (PID:18205): All non-current ORLs have been archived 2021-03-29T14:05:04.150332+00:00 PR00 (PID:18199): Media Recovery Waiting for T-1.S-73 (in transit) 2021-03-29T14:05:04.151914+00:00 Recovery of Online Redo Log: Thread 1 Group 10 Seq 73 Reading mem 0 Mem# 0: /u01/oradata/ORCL_DGB/standby_redo01.log 2021-03-29T14:05:04.638676+00:00 Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT NODELAY 2021-03-29T14:05:55.864473+00:00 ARC2 (PID:18167): Archived Log entry 31 added for T-1.S-73 ID 0x5f2520f5 LAD:1 2021-03-29T14:05:55.906873+00:00 PR00 (PID:18199): Media Recovery Waiting for T-1.S-74 2021-03-29T14:05:56.210901+00:00 rfs (PID:18211): Primary database is in MAXIMUM PERFORMANCE mode 2021-03-29T14:05:56.291489+00:00 rfs (PID:18211): Selected LNO:10 for T-1.S-74 dbid 1596176186 branch 1068395452 2021-03-29T14:06:13.214573+00:00 Recovery of Online Redo Log: Thread 1 Group 10 Seq 74 Reading mem 0 Mem# 0: /u01/oradata/ORCL_DGB/standby_redo01.log
Let’s recover the second one too:
RMAN> recover standby database from service orcl_dga;
Starting recover at 29-MAR-21
using target database control file instead of recovery catalog
Oracle instance started
Total System Global Area 1610609200 bytes
Fixed Size 8897072 bytes
Variable Size 385875968 bytes
Database Buffers 1207959552 bytes
Redo Buffers 7876608 bytes
contents of Memory Script:
{
restore standby controlfile from service 'orcl_dga';
alter database mount standby database;
}
executing Memory Script
Starting restore at 29-MAR-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=21 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: using network backup set from service orcl_dga
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/oradata/ORCL_DGC/control01.ctl
output file name=/u01/oradata/ORCL_DGC/control02.ctl
Finished restore at 29-MAR-21
released channel: ORA_DISK_1
Statement processed
Executing: alter system set standby_file_management=manual
contents of Memory Script:
{
recover database from service 'orcl_dga';
}
executing Memory Script
Starting recover at 29-MAR-21
Starting implicit crosscheck backup at 29-MAR-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=261 device type=DISK
Crosschecked 2 objects
Finished implicit crosscheck backup at 29-MAR-21
Starting implicit crosscheck copy at 29-MAR-21
using channel ORA_DISK_1
Finished implicit crosscheck copy at 29-MAR-21
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_28/o1_mf_1_41_j61nz2hl_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_42_j62xpvo6_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_43_j62xq9jr_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_44_j62xqd8s_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_45_j62xwvwr_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_46_j62xxcql_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_47_j62xxgj0_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_48_j62y5t21_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_49_j62y5xyn_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_50_j62y755o_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_54_j62y9toc_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_55_j62ycpj4_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_56_j62ycs8s_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_57_j62yt332_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_58_j62ytbkx_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_59_j62ytmyy_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_60_j63ozvqn_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_61_j63p01wj_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_62_j63p0b4d_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_63_j63p4lyy_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_70_j63pn8hf_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_69_j63pnb0b_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_68_j63pnb13_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_67_j63pnb1t_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_66_j63pnb4z_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_71_j63ppm02_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_72_j63ppxnk_.arc
File Name: /u01/app/oracle/ORCL_DGC/archivelog/2021_03_29/o1_mf_1_73_j63qp3s5_.arc
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service orcl_dga
destination for restore of datafile 00001: /u01/oradata/ORCL_DGC/system01.dbf
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service orcl_dga
destination for restore of datafile 00003: /u01/oradata/ORCL_DGC/sysaux01.dbf
channel ORA_DISK_1: restore complete, elapsed time: 00:00:04
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service orcl_dga
destination for restore of datafile 00004: /u01/oradata/ORCL_DGC/undotbs01.dbf
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service orcl_dga
destination for restore of datafile 00007: /u01/oradata/ORCL_DGC/users01.dbf
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
starting media recovery
media recovery complete, elapsed time: 00:00:00
Finished recover at 29-MAR-21
Executing: alter system set standby_file_management=auto
Finished recover at 29-MAR-21
RMAN>
Let’s check the configuration:
Configuration - my_dg_config
Protection Mode: MaxPerformance
Members:
orcl_dga - Primary database
orcl_dgb - Physical standby database
orcl_dgc - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 43 seconds ago)
Now we are back on track.
