Oracle 19c – RMAN recover from service feature at work

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.

Leave Comment

Your email address will not be published. Required fields are marked *