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.