Search
  • Sudipta Bhaskar

Sync RAC Standby 19c Database with ASM from RAC Primary Using Service

Due to unavailability of space in Data Diskgroup, standby was out of sync and after adding space it was not able to sync as the required archive logs were not available.


Let's check the gap first.


SQL> SELECT PROCESS, STATUS,THREAD#,SEQUENCE#,BLOCK# FROM v$managed_standby;

PROCESS   STATUS          THREAD#  SEQUENCE#     BLOCK#
--------- ------------ ---------- ---------- ----------
ARCH      CLOSING               2      42265       4096
DGRD      ALLOCATED             0          0          0
DGRD      ALLOCATED             0          0          0
ARCH      CLOSING               2      42266     219136
ARCH      CLOSING               1      43633      79872
ARCH      CLOSING               2      42264     141312
RFS       IDLE                  1      43634       9309
RFS       IDLE                  2      42267      24677
RFS       IDLE                  2          0          0
RFS       IDLE                  1          0          0
MRP0      WAIT_FOR_GAP          2      40890          0
RFS       IDLE                  0          0          0
RFS       IDLE                  0          0          0

13 rows selected.

Checked in broker, it was a long gap and need a sync with incremental backup.



DGMGRL> show configuration

Configuration - rob46_dr

  Protection Mode: MaxPerformance
  Members:
  rob46_dy - Primary database
    Error: ORA-16724: cannot resolve gap for one or more members

    rob46_tp - Physical standby database
      Error: ORA-16810: multiple errors or warnings detected for the member

Fast-Start Failover:  Disabled

Configuration Status:
ERROR   (status updated 49 seconds ago)



DGMGRL> Show database rob46_tp

Database - rob46_tp

  Role:               PHYSICAL STANDBY
  Intended State:     APPLY-ON
  Transport Lag:      0 seconds (computed 0 seconds ago)
  Apply Lag:          9 days 22 hours 31 minutes 50 seconds (computed 0 seconds ago)
  Average Apply Rate: (unknown)
  Real Time Query:    OFF
  Instance(s):
    rob46t1 (apply instance)
    rob46t2

  Database Warning(s):
    ORA-16853: apply lag has exceeded specified threshold

Database Status:
WARNING

Let's stop the Redo Apply


DGMGRL> edit database rob46_tp set state=APPLY-OFF;
Succeeded.

Standby should be in mount mode. If ADG, stop it and start in mount mode.


SQL> select NAME, DB_UNIQUE_NAME, OPEN_MODE, DATABASE_ROLE from V$DATABASE;

NAME      DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE
--------- ------------------------------ -------------------- ----------------
ROB46     rob46_tp                       MOUNTED              PHYSICAL STANDBY

Check SCN in both standby and primary.


Standby ::


SQL> select HXFIL, HXFNM, FHSCN from X$KCVFH;

     HXFIL HXFNM                                                                                                FHSCN
---------- ---------------------------------------------------------------------------------------------------- --------------------
         1 +DATA_DG01/ROB46_TP/DATAFILE/system.256.1067948749                                                   16075439297097
         3 +DATA_DG01/ROB46_TP/DATAFILE/sysaux.257.1067948749                                                   16075439297097
         4 +DATA_DG01/ROB46_TP/DATAFILE/undotbs1.258.1067948749                                                 16075439297097
         5 +DATA_DG01/ROB46_TP/BE33C1EA90F133C7E053B164060A4C52/DATAFILE/system.259.1067948749                  2636977
         6 +DATA_DG01/ROB46_TP/BE33C1EA90F133C7E053B164060A4C52/DATAFILE/sysaux.260.1067948749                  2636977
         7 +DATA_DG01/ROB46_TP/DATAFILE/users.261.1067948749                                                    16075439297097
         8 +DATA_DG01/ROB46_TP/BE33C1EA90F133C7E053B164060A4C52/DATAFILE/undotbs1.262.1067948751                2636977
         9 +DATA_DG01/ROB46_TP/DATAFILE/undotbs2.263.1067948759                                                 16075439297097
        10 +DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/system.264.1067948759                  16075439297097
        11 +DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/sysaux.265.1067948759                  16075439297097
        12 +DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/undotbs1.266.1067948759                16075439297097
        13 +DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/users.267.1067948763                   16075439297097
        14 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/system.268.1067948765                  16075439297097
        15 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/sysaux.269.1067948765                  16075439297097
        16 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/undotbs1.270.1067948765                16075439297097
        17 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/users.271.1067948767                   16075439297097
        18 +DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/undo_2.272.1067948767                  16075439297097
        19 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/undo_2.273.1067948769                  16075439297097
        20 +DATA_DG01/ROB46_TP/DATAFILE/audit_data.274.1067948769                                               16075439297097
        21 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/audit_data.275.1067948769              16075439297097
        22 +DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/audit_data.276.1067948771              16075439297097
        23 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/ddlauditing.277.1067948771             16075439297097
        24 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.282.1070020823              16075439297097
        25 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.283.1070020843              16075439297097
        26 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_data.284.1070021037             16075439297097
        27 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_data.285.1070021043             16075439297097
        28 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_clob.286.1070021065             16075439297097
        29 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_clob.287.1070021073             16075439297097
        30 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmwh_data.288.1070021097               16075439297097
        31 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmwh_data.289.1070021103               16075439297097
        32 +DATA_DG01/ROB46_TP/DATAFILE/goldengate.290.1070625261                                               16075439297097
        33 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/goldengate.291.1070625263              16075439297097
        34 +DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/goldengate.292.1070625389              16075439297097
        35 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.293.1072350147               16075439297097
        36 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.294.1072350155               16075439297097
        37 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.295.1072352849              16075439297097
        38 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.296.1072352853              16075439297097
        39 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.297.1072352859              16075439297097
        40 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.298.1076499917              16075439297097
        41 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.299.1076499965               16075439297097
        42 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.300.1076499985               16075439297097
        43 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_data.301.1076500015             16075439297097
        44 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.302.1076500075               16075439297097
        46 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_lrg_data_tbs.303.1079771027       16075439297097
        47 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.304.1083730559            16075439297097
        48 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.305.1083730649            16075439297097
        49 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.306.1083739183            16075439297097
        50 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.307.1086329565               16075439297097
        51 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.308.1086329569               16075439297097
        55 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.309.1086329613               16075439297097
        56 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_data.310.1089966685               16075439297097
        57 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_data.311.1089966805               16075439297097
        58 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_index1.312.1089966841             16075439297097
        59 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_index1.313.1089966857             16075439297097
        60 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/dt_lake_tab.314.1091941871             16075439297097
        61 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/dt_lake_tab.315.1091941879             16075439297097
        62 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.316.1091941945               16075439297097
        63 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_lrg_data_tbs.317.1091941959       16075439297097
        64 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.318.1091941977            16075439297097
        65 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.319.1092550215              16075439297097
        66 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_idx1.320.1092976753               16075439297097
        67 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.321.1095146243            16075439297097
        68 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.322.1095193963               16075439297097
        69 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.323.1095947773               16075439297097
        70 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.324.1095947837               16075439297097
        71 +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.325.1096805593               16075439297093

66 rows selected.

Primary ::


SQL> select HXFIL, HXFNM, FHSCN from X$KCVFH;

     HXFIL HXFNM                                                                                                FHSCN
---------- ---------------------------------------------------------------------------------------------------- --------------------
         1 +DATA_DG01/ROB46_DY/DATAFILE/system.257.1067945907                                                   16106764046030
         3 +DATA_DG01/ROB46_DY/DATAFILE/sysaux.258.1067945943                                                   16106764046030
         4 +DATA_DG01/ROB46_DY/DATAFILE/undotbs1.259.1067945959                                                 16106764046030
         5 +DATA_DG01/ROB46_DY/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.262.1067946497                  2636977
         6 +DATA_DG01/ROB46_DY/86B637B62FE07A65E053F706E80A27CA/DATAFILE/sysaux.263.1067946497                  2636977
         7 +DATA_DG01/ROB46_DY/DATAFILE/users.260.1067945961                                                    16106764046030
         8 +DATA_DG01/ROB46_DY/86B637B62FE07A65E053F706E80A27CA/DATAFILE/undotbs1.264.1067946497                2636977
         9 +DATA_DG01/ROB46_DY/DATAFILE/undotbs2.266.1067946705                                                 16106764046030
        10 +DATA_DG01/ROB46_DY/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/system.269.1067947257                  16106764046030
        11 +DATA_DG01/ROB46_DY/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/sysaux.270.1067947257                  16106764046030
        12 +DATA_DG01/ROB46_DY/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/undotbs1.268.1067947257                16106764046030
        13 +DATA_DG01/ROB46_DY/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/users.272.1067947267                   16106764046030
        14 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/system.274.1067947267                  16106764046030
        15 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/sysaux.275.1067947267                  16106764046030
        16 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/undotbs1.273.1067947267                16106764046030
        17 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/users.277.1067947275                   16106764046030
        18 +DATA_DG01/ROB46_DY/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/undo_2.279.1067947609                  16106764046030
        19 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/undo_2.280.1067947625                  16106764046030
        20 +DATA_DG01/ROB46_DY/DATAFILE/audit_data.281.1067947871                                               16106764046030
        21 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/audit_data.282.1067947893              16106764046030
        22 +DATA_DG01/ROB46_DY/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/audit_data.283.1067947913              16106764046030
        23 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/ddlauditing.284.1067948157             16106764046030
        24 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.286.1070020819              16106764046030
        25 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.287.1070020839              16106764046030
        26 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_data.288.1070021033             16106764046030
        27 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_data.289.1070021039             16106764046030
        28 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_clob.290.1070021061             16106764046030
        29 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_clob.291.1070021069             16106764046030
        30 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmwh_data.292.1070021095               16106764046030
        31 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmwh_data.293.1070021099               16106764046030
        32 +DATA_DG01/ROB46_DY/DATAFILE/goldengate.294.1070625257                                               16106764046030
        33 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/goldengate.295.1070625261              16106764046030
        34 +DATA_DG01/ROB46_DY/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/goldengate.296.1070625387              16106764046030
        35 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.297.1072350143               16106764046030
        36 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.298.1072350151               16106764046030
        37 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.299.1072352845              16106764046030
        38 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.300.1072352851              16106764046030
        39 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.301.1072352855              16106764046030
        40 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.302.1076499897              16106764046030
        41 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.303.1076499945               16106764046030
        42 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.304.1076499965               16106764046030
        43 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_data.305.1076499995             16106764046030
        44 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.306.1076500055               16106764046030
        46 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_lrg_data_tbs.307.1079770989       16106764046030
        47 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.308.1083730551            16106764046030
        48 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.309.1083730629            16106764046030
        49 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.310.1083739179            16106764046030
        50 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.311.1086329561               16106764046030
        51 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.312.1086329565               16106764046030
        55 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.313.1086329605               16106764046030
        56 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_data.314.1089966681               16106764046030
        57 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_data.315.1089966801               16106764046030
        58 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_index1.316.1089966835             16106764046030
        59 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_index1.317.1089966853             16106764046030
        60 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/dt_lake_tab.318.1091941867             16106764046030
        61 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/dt_lake_tab.319.1091941875             16106764046030
        62 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.320.1091941941               16106764046030
        63 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_lrg_data_tbs.321.1091941953       16106764046030
        64 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.322.1091941971            16106764046030
        65 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.323.1092550211              16106764046030
        66 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_idx1.324.1092976695               16106764046030
        67 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.325.1095146167            16106764046030
        68 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.326.1095193955               16106764046030
        69 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.327.1095947713               16106764046030
        70 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.328.1095947775               16106764046030
        71 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.329.1095949381               16106764046030
        72 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/eas_data.330.1096124519                16106764046030
        73 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/eas_data.331.1096124609                16106764046030
        74 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/rmdm_data.332.1096772035               16106764046030
        75 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/rmmp_idx.333.1096772043                16106764046030
        76 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/rmdm_idx.334.1096772051                16106764046030
        77 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/rmdm_clob.335.1096772057               16106764046030
        78 +DATA_DG01/ROB46_DY/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/rmdm_data.336.1096772167               16106764046030

73 rows selected.

There are significant differences.


STANDBY

SQL> select CURRENT_SCN from V$DATABASE;

     CURRENT_SCN
----------------
  16075439297096

DGMGRL> show configuration

Configuration - rob46_dr

  Protection Mode: MaxPerformance
  Members:
  rob46_dy - Primary database
    Error: ORA-16724: cannot resolve gap for one or more members

    rob46_tp - Physical standby database

Fast-Start Failover:  Disabled

Configuration Status:
ERROR   (status updated 45 seconds ago)

DGMGRL> show database verbose rob46_dy

Database - rob46_dy

  Role:               PRIMARY
  Intended State:     TRANSPORT-ON
  Instance(s):
    rob46d1
    rob46d2

  Properties:
    DGConnectIdentifier             = 'rob46d_dg'
    ObserverConnectIdentifier       = ''
    FastStartFailoverTarget         = ''
    PreferredObserverHosts          = ''
    LogShipping                     = 'ON'
    RedoRoutes                      = ''
    LogXptMode                      = 'ASYNC'
    DelayMins                       = '0'
    Binding                         = 'optional'
    MaxFailure                      = '0'
    ReopenSecs                      = '300'
    NetTimeout                      = '180'
    RedoCompression                 = 'DISABLE'
    PreferredApplyInstance          = 'rob46d1'
    ApplyInstanceTimeout            = '0'
    ApplyLagThreshold               = '30'
    TransportLagThreshold           = '30'
    TransportDisconnectedThreshold  = '30'
    ApplyParallel                   = 'AUTO'
    ApplyInstances                  = '0'
    StandbyFileManagement           = ''
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '0'
    LogArchiveMinSucceedDest        = '0'
    DataGuardSyncLatency            = '0'
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = ''
    DbFileNameConvert               = ''
    LogFileNameConvert              = ''
    ArchiveLocation                 = ''
    AlternateLocation               = ''
    StandbyArchiveLocation          = ''
    StandbyAlternateLocation        = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    LogXptStatus                    = '(monitor)'
    SendQEntries                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    HostName(*)
    StaticConnectIdentifier(*)
    TopWaitEvents(*)
    SidName(*)
    (*) - Please check specific instance for the property value

  Log file locations(*):
    (*) - Check specific instance for log file locations.

Database Status:
SUCCESS

Now do the recover process.

rob46t1 > rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Wed Feb 16 14:40:52 2022
Version 19.10.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ROB46 (DBID=348097181, not open)

RMAN> RECOVER STANDBY DATABASE FROM SERVICE rob46d_dg;

Starting recover at 16-FEB-22
Oracle instance started

Total System Global Area   17179866472 bytes

Fixed Size                     9155944 bytes
Variable Size              12046041088 bytes
Database Buffers            5033164800 bytes
Redo Buffers                  91504640 bytes

contents of Memory Script:
{
   restore standby controlfile from service  'rob46d_dg';
   alter database mount standby database;
}
executing Memory Script

Starting restore at 16-FEB-22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=17 instance=rob46t1 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
output file name=+REDO_DG01/ROB46_TP/CONTROLFILE/current.258.1067948737
output file name=+REDO_DG02/ROB46_TP/CONTROLFILE/current.258.1067948737
output file name=+RECO_DG01/ROB46_TP/CONTROLFILE/current.258.1067948737
Finished restore at 16-FEB-22

released channel: ORA_DISK_1
Statement processed
For record type BACKUP PIECE RECIDS from 49322 to 50702 are re-used before resync
For record type BACKUP SET RECIDS from 49322 to 50698 are re-used before resync
Executing: alter system set standby_file_management=manual

contents of Memory Script:
{
set newname for tempfile  1 to
 "+DATA_DG01";
set newname for tempfile  2 to
 "+DATA_DG01";
set newname for tempfile  3 to
 "+DATA_DG01";
set newname for tempfile  4 to
 "+DATA_DG01";
   switch tempfile all;
set newname for datafile  1 to
 "+DATA_DG01/ROB46_TP/DATAFILE/system.256.1067948749";
set newname for datafile  3 to
 "+DATA_DG01/ROB46_TP/DATAFILE/sysaux.257.1067948749";
set newname for datafile  4 to
 "+DATA_DG01/ROB46_TP/DATAFILE/undotbs1.258.1067948749";
set newname for datafile  5 to
 "+DATA_DG01/ROB46_TP/BE33C1EA90F133C7E053B164060A4C52/DATAFILE/system.259.1067948749";
set newname for datafile  6 to
 "+DATA_DG01/ROB46_TP/BE33C1EA90F133C7E053B164060A4C52/DATAFILE/sysaux.260.1067948749";
set newname for datafile  7 to
 "+DATA_DG01/ROB46_TP/DATAFILE/users.261.1067948749";
set newname for datafile  8 to
 "+DATA_DG01/ROB46_TP/BE33C1EA90F133C7E053B164060A4C52/DATAFILE/undotbs1.262.1067948751";
set newname for datafile  9 to
 "+DATA_DG01/ROB46_TP/DATAFILE/undotbs2.263.1067948759";
set newname for datafile  10 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/system.264.1067948759";
set newname for datafile  11 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/sysaux.265.1067948759";
set newname for datafile  12 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/undotbs1.266.1067948759";
set newname for datafile  13 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/users.267.1067948763";
set newname for datafile  14 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/system.268.1067948765";
set newname for datafile  15 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/sysaux.269.1067948765";
set newname for datafile  16 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/undotbs1.270.1067948765";
set newname for datafile  17 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/users.271.1067948767";
set newname for datafile  18 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/undo_2.272.1067948767";
set newname for datafile  19 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/undo_2.273.1067948769";
set newname for datafile  20 to
 "+DATA_DG01/ROB46_TP/DATAFILE/audit_data.274.1067948769";
set newname for datafile  21 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/audit_data.275.1067948769";
set newname for datafile  22 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/audit_data.276.1067948771";
set newname for datafile  23 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/ddlauditing.277.1067948771";
set newname for datafile  24 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.282.1070020823";
set newname for datafile  25 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.283.1070020843";
set newname for datafile  26 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_data.284.1070021037";
set newname for datafile  27 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_data.285.1070021043";
set newname for datafile  28 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_clob.286.1070021065";
set newname for datafile  29 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_clob.287.1070021073";
set newname for datafile  30 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmwh_data.288.1070021097";
set newname for datafile  31 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmwh_data.289.1070021103";
set newname for datafile  32 to
 "+DATA_DG01/ROB46_TP/DATAFILE/goldengate.290.1070625261";
set newname for datafile  33 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/goldengate.291.1070625263";
set newname for datafile  34 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/goldengate.292.1070625389";
set newname for datafile  35 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.293.1072350147";
set newname for datafile  36 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.294.1072350155";
set newname for datafile  37 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.295.1072352849";
set newname for datafile  38 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.296.1072352853";
set newname for datafile  39 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.297.1072352859";
set newname for datafile  40 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.298.1076499917";
set newname for datafile  41 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.299.1076499965";
set newname for datafile  42 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.300.1076499985";
set newname for datafile  43 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_data.301.1076500015";
set newname for datafile  44 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.302.1076500075";
set newname for datafile  46 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_lrg_data_tbs.303.1079771027";
set newname for datafile  47 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.304.1083730559";
set newname for datafile  48 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.305.1083730649";
set newname for datafile  49 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.306.1083739183";
set newname for datafile  50 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.307.1086329565";
set newname for datafile  51 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.308.1086329569";
set newname for datafile  55 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.309.1086329613";
set newname for datafile  56 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_data.310.1089966685";
set newname for datafile  57 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_data.311.1089966805";
set newname for datafile  58 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_index1.312.1089966841";
set newname for datafile  59 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_index1.313.1089966857";
set newname for datafile  60 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/dt_lake_tab.314.1091941871";
set newname for datafile  61 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/dt_lake_tab.315.1091941879";
set newname for datafile  62 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.316.1091941945";
set newname for datafile  63 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_lrg_data_tbs.317.1091941959";
set newname for datafile  64 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.318.1091941977";
set newname for datafile  65 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.319.1092550215";
set newname for datafile  66 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_idx1.320.1092976753";
set newname for datafile  67 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.321.1095146243";
set newname for datafile  68 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.322.1095193963";
set newname for datafile  69 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.323.1095947773";
set newname for datafile  70 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.324.1095947837";
set newname for datafile  71 to
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.325.1096805593";
set newname for datafile  72 to new;
set newname for datafile  73 to new;
set newname for datafile  74 to new;
set newname for datafile  75 to new;
set newname for datafile  76 to new;
set newname for datafile  77 to new;
set newname for datafile  78 to new;
   restore from service  'rob46d_dg' datafile
    72, 73, 74, 75, 76, 77, 78;
   catalog datafilecopy  "+DATA_DG01/ROB46_TP/DATAFILE/system.256.1067948749",
 "+DATA_DG01/ROB46_TP/DATAFILE/sysaux.257.1067948749",
 "+DATA_DG01/ROB46_TP/DATAFILE/undotbs1.258.1067948749",
 "+DATA_DG01/ROB46_TP/BE33C1EA90F133C7E053B164060A4C52/DATAFILE/system.259.1067948749",
 "+DATA_DG01/ROB46_TP/BE33C1EA90F133C7E053B164060A4C52/DATAFILE/sysaux.260.1067948749",
 "+DATA_DG01/ROB46_TP/DATAFILE/users.261.1067948749",
 "+DATA_DG01/ROB46_TP/BE33C1EA90F133C7E053B164060A4C52/DATAFILE/undotbs1.262.1067948751",
 "+DATA_DG01/ROB46_TP/DATAFILE/undotbs2.263.1067948759",
 "+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/system.264.1067948759",
 "+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/sysaux.265.1067948759",
 "+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/undotbs1.266.1067948759",
 "+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/users.267.1067948763",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/system.268.1067948765",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/sysaux.269.1067948765",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/undotbs1.270.1067948765",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/users.271.1067948767",
 "+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/undo_2.272.1067948767",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/undo_2.273.1067948769",
 "+DATA_DG01/ROB46_TP/DATAFILE/audit_data.274.1067948769",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/audit_data.275.1067948769",
 "+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/audit_data.276.1067948771",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/ddlauditing.277.1067948771",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.282.1070020823",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.283.1070020843",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_data.284.1070021037",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_data.285.1070021043",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_clob.286.1070021065",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_clob.287.1070021073",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmwh_data.288.1070021097",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmwh_data.289.1070021103",
 "+DATA_DG01/ROB46_TP/DATAFILE/goldengate.290.1070625261",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/goldengate.291.1070625263",
 "+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/goldengate.292.1070625389",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.293.1072350147",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.294.1072350155",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.295.1072352849",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.296.1072352853",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.297.1072352859",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.298.1076499917",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.299.1076499965",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.300.1076499985",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_data.301.1076500015",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.302.1076500075",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_lrg_data_tbs.303.1079771027",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.304.1083730559",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.305.1083730649",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.306.1083739183",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.307.1086329565",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.308.1086329569",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.309.1086329613",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_data.310.1089966685",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_data.311.1089966805",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_index1.312.1089966841",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_index1.313.1089966857",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/dt_lake_tab.314.1091941871",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/dt_lake_tab.315.1091941879",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.316.1091941945",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_lrg_data_tbs.317.1091941959",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.318.1091941977",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.319.1092550215",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_idx1.320.1092976753",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.321.1095146243",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.322.1095193963",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.323.1095947773",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.324.1095947837",
 "+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.325.1096805593";
   switch datafile all;
}
executing Memory Script

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting implicit crosscheck backup at 16-FEB-22
allocated channel: ORA_DISK_1
Crosschecked 1 objects
Finished implicit crosscheck backup at 16-FEB-22

Starting implicit crosscheck copy at 16-FEB-22
using channel ORA_DISK_1
Crosschecked 2 objects
Finished implicit crosscheck copy at 16-FEB-22

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: +RECO_DG01/ROB46_TP/SNAPSHOT_CONTROLFILE/snapcf_rob46.f

renamed tempfile 1 to +DATA_DG01 in control file
renamed tempfile 2 to +DATA_DG01 in control file
renamed tempfile 3 to +DATA_DG01 in control file
renamed tempfile 4 to +DATA_DG01 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

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

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

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

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

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

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

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

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

executing command: SET NEWNAME

Starting restore at 16-FEB-22
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00072 to +DATA_DG01
channel ORA_DISK_1: restore complete, elapsed time: 00:00:26
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00073 to +DATA_DG01
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00074 to +DATA_DG01
channel ORA_DISK_1: restore complete, elapsed time: 00:00:08
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00075 to +DATA_DG01
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00076 to +DATA_DG01
channel ORA_DISK_1: restore complete, elapsed time: 00:00:08
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00077 to +DATA_DG01
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00078 to +DATA_DG01
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
Finished restore at 16-FEB-22

cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/DATAFILE/system.256.1067948749 RECID=13 STAMP=1096814656
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/DATAFILE/sysaux.257.1067948749 RECID=14 STAMP=1096814656
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/DATAFILE/undotbs1.258.1067948749 RECID=15 STAMP=1096814656
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33C1EA90F133C7E053B164060A4C52/DATAFILE/system.259.1067948749 RECID=16 STAMP=1096814656
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33C1EA90F133C7E053B164060A4C52/DATAFILE/sysaux.260.1067948749 RECID=17 STAMP=1096814656
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/DATAFILE/users.261.1067948749 RECID=18 STAMP=1096814656
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33C1EA90F133C7E053B164060A4C52/DATAFILE/undotbs1.262.1067948751 RECID=19 STAMP=1096814656
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/DATAFILE/undotbs2.263.1067948759 RECID=20 STAMP=1096814656
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/system.264.1067948759 RECID=21 STAMP=1096814656
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/sysaux.265.1067948759 RECID=22 STAMP=1096814656
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/undotbs1.266.1067948759 RECID=23 STAMP=1096814656
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/users.267.1067948763 RECID=24 STAMP=1096814656
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/system.268.1067948765 RECID=25 STAMP=1096814656
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/sysaux.269.1067948765 RECID=26 STAMP=1096814656
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/undotbs1.270.1067948765 RECID=27 STAMP=1096814657
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/users.271.1067948767 RECID=28 STAMP=1096814657
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/undo_2.272.1067948767 RECID=29 STAMP=1096814657
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/undo_2.273.1067948769 RECID=30 STAMP=1096814657
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/DATAFILE/audit_data.274.1067948769 RECID=31 STAMP=1096814657
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/audit_data.275.1067948769 RECID=32 STAMP=1096814657
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/audit_data.276.1067948771 RECID=33 STAMP=1096814657
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/ddlauditing.277.1067948771 RECID=34 STAMP=1096814657
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.282.1070020823 RECID=35 STAMP=1096814657
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.283.1070020843 RECID=36 STAMP=1096814657
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_data.284.1070021037 RECID=37 STAMP=1096814657
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_data.285.1070021043 RECID=38 STAMP=1096814657
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_clob.286.1070021065 RECID=39 STAMP=1096814657
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_clob.287.1070021073 RECID=40 STAMP=1096814657
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmwh_data.288.1070021097 RECID=41 STAMP=1096814657
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmwh_data.289.1070021103 RECID=42 STAMP=1096814658
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/DATAFILE/goldengate.290.1070625261 RECID=43 STAMP=1096814658
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/goldengate.291.1070625263 RECID=44 STAMP=1096814658
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/goldengate.292.1070625389 RECID=45 STAMP=1096814658
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.293.1072350147 RECID=46 STAMP=1096814658
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.294.1072350155 RECID=47 STAMP=1096814658
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.295.1072352849 RECID=48 STAMP=1096814658
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.296.1072352853 RECID=49 STAMP=1096814658
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.297.1072352859 RECID=50 STAMP=1096814658
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.298.1076499917 RECID=51 STAMP=1096814658
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.299.1076499965 RECID=52 STAMP=1096814659
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.300.1076499985 RECID=53 STAMP=1096814659
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_data.301.1076500015 RECID=54 STAMP=1096814659
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.302.1076500075 RECID=55 STAMP=1096814659
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_lrg_data_tbs.303.1079771027 RECID=56 STAMP=1096814659
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.304.1083730559 RECID=57 STAMP=1096814659
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.305.1083730649 RECID=58 STAMP=1096814659
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.306.1083739183 RECID=59 STAMP=1096814659
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.307.1086329565 RECID=60 STAMP=1096814659
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.308.1086329569 RECID=61 STAMP=1096814659
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.309.1086329613 RECID=62 STAMP=1096814659
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_data.310.1089966685 RECID=63 STAMP=1096814659
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_data.311.1089966805 RECID=64 STAMP=1096814659
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_index1.312.1089966841 RECID=65 STAMP=1096814659
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_index1.313.1089966857 RECID=66 STAMP=1096814660
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/dt_lake_tab.314.1091941871 RECID=67 STAMP=1096814660
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/dt_lake_tab.315.1091941879 RECID=68 STAMP=1096814660
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.316.1091941945 RECID=69 STAMP=1096814660
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_lrg_data_tbs.317.1091941959 RECID=70 STAMP=1096814660
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.318.1091941977 RECID=71 STAMP=1096814660
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.319.1092550215 RECID=72 STAMP=1096814660
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_idx1.320.1092976753 RECID=73 STAMP=1096814660
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.321.1095146243 RECID=74 STAMP=1096814660
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.322.1095193963 RECID=75 STAMP=1096814660
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.323.1095947773 RECID=76 STAMP=1096814660
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.324.1095947837 RECID=77 STAMP=1096814660
cataloged datafile copy
datafile copy file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.325.1096805593 RECID=78 STAMP=1096814660

datafile 72 switched to datafile copy
input datafile copy RECID=6 STAMP=1096814596 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/eas_data.279.1096814577
datafile 73 switched to datafile copy
input datafile copy RECID=7 STAMP=1096814613 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/eas_data.326.1096814603
datafile 74 switched to datafile copy
input datafile copy RECID=8 STAMP=1096814623 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/rmdm_data.327.1096814619
datafile 75 switched to datafile copy
input datafile copy RECID=9 STAMP=1096814630 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/rmmp_idx.328.1096814627
datafile 76 switched to datafile copy
input datafile copy RECID=10 STAMP=1096814638 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/rmdm_idx.329.1096814633
datafile 77 switched to datafile copy
input datafile copy RECID=11 STAMP=1096814645 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/rmdm_clob.330.1096814641
datafile 78 switched to datafile copy
input datafile copy RECID=12 STAMP=1096814653 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/rmdm_data.331.1096814649
datafile 1 switched to datafile copy
input datafile copy RECID=13 STAMP=1096814656 file name=+DATA_DG01/ROB46_TP/DATAFILE/system.256.1067948749
datafile 3 switched to datafile copy
input datafile copy RECID=14 STAMP=1096814656 file name=+DATA_DG01/ROB46_TP/DATAFILE/sysaux.257.1067948749
datafile 4 switched to datafile copy
input datafile copy RECID=15 STAMP=1096814656 file name=+DATA_DG01/ROB46_TP/DATAFILE/undotbs1.258.1067948749
datafile 5 switched to datafile copy
input datafile copy RECID=16 STAMP=1096814656 file name=+DATA_DG01/ROB46_TP/BE33C1EA90F133C7E053B164060A4C52/DATAFILE/system.259.1067948749
datafile 6 switched to datafile copy
input datafile copy RECID=17 STAMP=1096814656 file name=+DATA_DG01/ROB46_TP/BE33C1EA90F133C7E053B164060A4C52/DATAFILE/sysaux.260.1067948749
datafile 7 switched to datafile copy
input datafile copy RECID=18 STAMP=1096814656 file name=+DATA_DG01/ROB46_TP/DATAFILE/users.261.1067948749
datafile 8 switched to datafile copy
input datafile copy RECID=19 STAMP=1096814656 file name=+DATA_DG01/ROB46_TP/BE33C1EA90F133C7E053B164060A4C52/DATAFILE/undotbs1.262.1067948751
datafile 9 switched to datafile copy
input datafile copy RECID=20 STAMP=1096814656 file name=+DATA_DG01/ROB46_TP/DATAFILE/undotbs2.263.1067948759
datafile 10 switched to datafile copy
input datafile copy RECID=21 STAMP=1096814656 file name=+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/system.264.1067948759
datafile 11 switched to datafile copy
input datafile copy RECID=22 STAMP=1096814656 file name=+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/sysaux.265.1067948759
datafile 12 switched to datafile copy
input datafile copy RECID=23 STAMP=1096814656 file name=+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/undotbs1.266.1067948759
datafile 13 switched to datafile copy
input datafile copy RECID=24 STAMP=1096814656 file name=+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/users.267.1067948763
datafile 14 switched to datafile copy
input datafile copy RECID=25 STAMP=1096814656 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/system.268.1067948765
datafile 15 switched to datafile copy
input datafile copy RECID=26 STAMP=1096814656 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/sysaux.269.1067948765
datafile 16 switched to datafile copy
input datafile copy RECID=27 STAMP=1096814657 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/undotbs1.270.1067948765
datafile 17 switched to datafile copy
input datafile copy RECID=28 STAMP=1096814657 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/users.271.1067948767
datafile 18 switched to datafile copy
input datafile copy RECID=29 STAMP=1096814657 file name=+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/undo_2.272.1067948767
datafile 19 switched to datafile copy
input datafile copy RECID=30 STAMP=1096814657 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/undo_2.273.1067948769
datafile 20 switched to datafile copy
input datafile copy RECID=31 STAMP=1096814657 file name=+DATA_DG01/ROB46_TP/DATAFILE/audit_data.274.1067948769
datafile 21 switched to datafile copy
input datafile copy RECID=32 STAMP=1096814657 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/audit_data.275.1067948769
datafile 22 switched to datafile copy
input datafile copy RECID=33 STAMP=1096814657 file name=+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/audit_data.276.1067948771
datafile 23 switched to datafile copy
input datafile copy RECID=34 STAMP=1096814657 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/ddlauditing.277.1067948771
datafile 24 switched to datafile copy
input datafile copy RECID=35 STAMP=1096814657 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.282.1070020823
datafile 25 switched to datafile copy
input datafile copy RECID=36 STAMP=1096814657 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.283.1070020843
datafile 26 switched to datafile copy
input datafile copy RECID=37 STAMP=1096814657 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_data.284.1070021037
datafile 27 switched to datafile copy
input datafile copy RECID=38 STAMP=1096814657 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_data.285.1070021043
datafile 28 switched to datafile copy
input datafile copy RECID=39 STAMP=1096814657 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_clob.286.1070021065
datafile 29 switched to datafile copy
input datafile copy RECID=40 STAMP=1096814657 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_clob.287.1070021073
datafile 30 switched to datafile copy
input datafile copy RECID=41 STAMP=1096814657 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmwh_data.288.1070021097
datafile 31 switched to datafile copy
input datafile copy RECID=42 STAMP=1096814658 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmwh_data.289.1070021103
datafile 32 switched to datafile copy
input datafile copy RECID=43 STAMP=1096814658 file name=+DATA_DG01/ROB46_TP/DATAFILE/goldengate.290.1070625261
datafile 33 switched to datafile copy
input datafile copy RECID=44 STAMP=1096814658 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/goldengate.291.1070625263
datafile 34 switched to datafile copy
input datafile copy RECID=45 STAMP=1096814658 file name=+DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/goldengate.292.1070625389
datafile 35 switched to datafile copy
input datafile copy RECID=46 STAMP=1096814658 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.293.1072350147
datafile 36 switched to datafile copy
input datafile copy RECID=47 STAMP=1096814658 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.294.1072350155
datafile 37 switched to datafile copy
input datafile copy RECID=48 STAMP=1096814658 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.295.1072352849
datafile 38 switched to datafile copy
input datafile copy RECID=49 STAMP=1096814658 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.296.1072352853
datafile 39 switched to datafile copy
input datafile copy RECID=50 STAMP=1096814658 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.297.1072352859
datafile 40 switched to datafile copy
input datafile copy RECID=51 STAMP=1096814658 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.298.1076499917
datafile 41 switched to datafile copy
input datafile copy RECID=52 STAMP=1096814659 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.299.1076499965
datafile 42 switched to datafile copy
input datafile copy RECID=53 STAMP=1096814659 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.300.1076499985
datafile 43 switched to datafile copy
input datafile copy RECID=54 STAMP=1096814659 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_data.301.1076500015
datafile 44 switched to datafile copy
input datafile copy RECID=55 STAMP=1096814659 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.302.1076500075
datafile 46 switched to datafile copy
input datafile copy RECID=56 STAMP=1096814659 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_lrg_data_tbs.303.1079771027
datafile 47 switched to datafile copy
input datafile copy RECID=57 STAMP=1096814659 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.304.1083730559
datafile 48 switched to datafile copy
input datafile copy RECID=58 STAMP=1096814659 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.305.1083730649
datafile 49 switched to datafile copy
input datafile copy RECID=59 STAMP=1096814659 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.306.1083739183
datafile 50 switched to datafile copy
input datafile copy RECID=60 STAMP=1096814659 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.307.1086329565
datafile 51 switched to datafile copy
input datafile copy RECID=61 STAMP=1096814659 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.308.1086329569
datafile 55 switched to datafile copy
input datafile copy RECID=62 STAMP=1096814659 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.309.1086329613
datafile 56 switched to datafile copy
input datafile copy RECID=63 STAMP=1096814659 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_data.310.1089966685
datafile 57 switched to datafile copy
input datafile copy RECID=64 STAMP=1096814659 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_data.311.1089966805
datafile 58 switched to datafile copy
input datafile copy RECID=65 STAMP=1096814659 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_index1.312.1089966841
datafile 59 switched to datafile copy
input datafile copy RECID=66 STAMP=1096814660 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_index1.313.1089966857
datafile 60 switched to datafile copy
input datafile copy RECID=67 STAMP=1096814660 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/dt_lake_tab.314.1091941871
datafile 61 switched to datafile copy
input datafile copy RECID=68 STAMP=1096814660 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/dt_lake_tab.315.1091941879
datafile 62 switched to datafile copy
input datafile copy RECID=69 STAMP=1096814660 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.316.1091941945
datafile 63 switched to datafile copy
input datafile copy RECID=70 STAMP=1096814660 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_lrg_data_tbs.317.1091941959
datafile 64 switched to datafile copy
input datafile copy RECID=71 STAMP=1096814660 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.318.1091941977
datafile 65 switched to datafile copy
input datafile copy RECID=72 STAMP=1096814660 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.319.1092550215
datafile 66 switched to datafile copy
input datafile copy RECID=73 STAMP=1096814660 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_idx1.320.1092976753
datafile 67 switched to datafile copy
input datafile copy RECID=74 STAMP=1096814660 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.321.1095146243
datafile 68 switched to datafile copy
input datafile copy RECID=75 STAMP=1096814660 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.322.1095193963
datafile 69 switched to datafile copy
input datafile copy RECID=76 STAMP=1096814660 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.323.1095947773
datafile 70 switched to datafile copy
input datafile copy RECID=77 STAMP=1096814660 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.324.1095947837
datafile 71 switched to datafile copy
input datafile copy RECID=78 STAMP=1096814660 file name=+DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.325.1096805593
Executing: alter database rename file '+REDO_DG01/ROB46_DY/ONLINELOG/group_1.257.1067946021' to '+REDO_DG01/ROB46_TP/ONLINELOG/group_1.259.1067948789'
Executing: alter database rename file '+REDO_DG02/ROB46_DY/ONLINELOG/group_1.257.1067946017' to '+REDO_DG02/ROB46_TP/ONLINELOG/group_1.259.1067948789'
Executing: alter database rename file '+REDO_DG01/ROB46_DY/ONLINELOG/group_2.258.1067946021' to '+REDO_DG01/ROB46_TP/ONLINELOG/group_2.260.1067948791'
Executing: alter database rename file '+REDO_DG02/ROB46_DY/ONLINELOG/group_2.258.1067946017' to '+REDO_DG02/ROB46_TP/ONLINELOG/group_2.260.1067948789'
Executing: alter database rename file '+REDO_DG01/ROB46_DY/ONLINELOG/group_3.260.1067947473' to '+REDO_DG01/ROB46_TP/ONLINELOG/group_3.261.1067948791'
Executing: alter database rename file '+REDO_DG02/ROB46_DY/ONLINELOG/group_3.260.1067947471' to '+REDO_DG02/ROB46_TP/ONLINELOG/group_3.261.1067948791'
Executing: alter database rename file '+REDO_DG01/ROB46_DY/ONLINELOG/group_4.259.1067947477' to '+REDO_DG01/ROB46_TP/ONLINELOG/group_4.262.1067948791'
Executing: alter database rename file '+REDO_DG02/ROB46_DY/ONLINELOG/group_4.259.1067947475' to '+REDO_DG02/ROB46_TP/ONLINELOG/group_4.262.1067948791'
Executing: alter database rename file '+REDO_DG01/ROB46_DY/ONLINELOG/group_5.261.1067947481' to '+REDO_DG01/ROB46_TP/ONLINELOG/group_5.263.1067948793'
Executing: alter database rename file '+REDO_DG02/ROB46_DY/ONLINELOG/group_5.261.1067947479' to '+REDO_DG02/ROB46_TP/ONLINELOG/group_5.263.1067948793'
Executing: alter database rename file '+REDO_DG01/ROB46_DY/ONLINELOG/group_6.262.1067947483' to '+REDO_DG01/ROB46_TP/ONLINELOG/group_6.264.1067948793'
Executing: alter database rename file '+REDO_DG02/ROB46_DY/ONLINELOG/group_6.262.1067947481' to '+REDO_DG02/ROB46_TP/ONLINELOG/group_6.264.1067948793'
Executing: alter database rename file '+REDO_DG01/ROB46_DY/ONLINELOG/group_7.263.1067947487' to '+REDO_DG01/ROB46_TP/ONLINELOG/group_7.265.1067948793'
Executing: alter database rename file '+REDO_DG02/ROB46_DY/ONLINELOG/group_7.263.1067947485' to '+REDO_DG02/ROB46_TP/ONLINELOG/group_7.265.1067948793'
Executing: alter database rename file '+REDO_DG01/ROB46_DY/ONLINELOG/group_8.264.1067947491' to '+REDO_DG01/ROB46_TP/ONLINELOG/group_8.266.1067948795'
Executing: alter database rename file '+REDO_DG02/ROB46_DY/ONLINELOG/group_8.264.1067947489' to '+REDO_DG02/ROB46_TP/ONLINELOG/group_8.266.1067948795'

contents of Memory Script:
{
  recover database from service  'rob46d_dg';
}
executing Memory Script

Starting recover at 16-FEB-22
using channel ORA_DISK_1
skipping datafile 5; already restored to SCN 2636977
skipping datafile 6; already restored to SCN 2636977
skipping datafile 8; already restored to SCN 2636977
skipping datafile 72; already restored to SCN 16106764388595
skipping datafile 73; already restored to SCN 16106764389464
skipping datafile 74; already restored to SCN 16106764389890
skipping datafile 75; already restored to SCN 16106764390135
skipping datafile 76; already restored to SCN 16106764390463
skipping datafile 77; already restored to SCN 16106764390668
skipping datafile 78; already restored to SCN 16106764391005
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00001: +DATA_DG01/ROB46_TP/DATAFILE/system.256.1067948749
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 rob46d_dg
destination for restore of datafile 00003: +DATA_DG01/ROB46_TP/DATAFILE/sysaux.257.1067948749
channel ORA_DISK_1: restore complete, elapsed time: 00:00:16
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00004: +DATA_DG01/ROB46_TP/DATAFILE/undotbs1.258.1067948749
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00007: +DATA_DG01/ROB46_TP/DATAFILE/users.261.1067948749
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 rob46d_dg
destination for restore of datafile 00009: +DATA_DG01/ROB46_TP/DATAFILE/undotbs2.263.1067948759
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00010: +DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/system.264.1067948759
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 rob46d_dg
destination for restore of datafile 00011: +DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/sysaux.265.1067948759
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 rob46d_dg
destination for restore of datafile 00012: +DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/undotbs1.266.1067948759
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 rob46d_dg
destination for restore of datafile 00013: +DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/users.267.1067948763
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 rob46d_dg
destination for restore of datafile 00014: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/system.268.1067948765
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 rob46d_dg
destination for restore of datafile 00015: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/sysaux.269.1067948765
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 rob46d_dg
destination for restore of datafile 00016: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/undotbs1.270.1067948765
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00017: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/users.271.1067948767
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 rob46d_dg
destination for restore of datafile 00018: +DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/undo_2.272.1067948767
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00019: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/undo_2.273.1067948769
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 rob46d_dg
destination for restore of datafile 00020: +DATA_DG01/ROB46_TP/DATAFILE/audit_data.274.1067948769
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 rob46d_dg
destination for restore of datafile 00021: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/audit_data.275.1067948769
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 rob46d_dg
destination for restore of datafile 00022: +DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/audit_data.276.1067948771
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 rob46d_dg
destination for restore of datafile 00023: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/ddlauditing.277.1067948771
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 rob46d_dg
destination for restore of datafile 00024: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.282.1070020823
channel ORA_DISK_1: restore complete, elapsed time: 00:00:16
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00025: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.283.1070020843
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00026: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_data.284.1070021037
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 rob46d_dg
destination for restore of datafile 00027: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_data.285.1070021043
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 rob46d_dg
destination for restore of datafile 00028: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_clob.286.1070021065
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 rob46d_dg
destination for restore of datafile 00029: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_clob.287.1070021073
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 rob46d_dg
destination for restore of datafile 00030: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmwh_data.288.1070021097
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 rob46d_dg
destination for restore of datafile 00031: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmwh_data.289.1070021103
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 rob46d_dg
destination for restore of datafile 00032: +DATA_DG01/ROB46_TP/DATAFILE/goldengate.290.1070625261
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 rob46d_dg
destination for restore of datafile 00033: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/goldengate.291.1070625263
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 rob46d_dg
destination for restore of datafile 00034: +DATA_DG01/ROB46_TP/BE33EF5DE3FC7A7DE053B164060AE19B/DATAFILE/goldengate.292.1070625389
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 rob46d_dg
destination for restore of datafile 00035: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.293.1072350147
channel ORA_DISK_1: restore complete, elapsed time: 00:00:46
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00036: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.294.1072350155
channel ORA_DISK_1: restore complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00037: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.295.1072352849
channel ORA_DISK_1: restore complete, elapsed time: 00:00:16
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00038: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.296.1072352853
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00039: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.297.1072352859
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00040: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.298.1076499917
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00041: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.299.1076499965
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00042: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.300.1076499985
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00043: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmcore_data.301.1076500015
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 rob46d_dg
destination for restore of datafile 00044: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.302.1076500075
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00046: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_lrg_data_tbs.303.1079771027
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00047: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.304.1083730559
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 rob46d_dg
destination for restore of datafile 00048: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.305.1083730649
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00049: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.306.1083739183
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 rob46d_dg
destination for restore of datafile 00050: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.307.1086329565
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00051: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.308.1086329569
channel ORA_DISK_1: restore complete, elapsed time: 00:00:36
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00055: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.309.1086329613
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00056: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_data.310.1089966685
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 rob46d_dg
destination for restore of datafile 00057: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_data.311.1089966805
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 rob46d_dg
destination for restore of datafile 00058: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_index1.312.1089966841
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 rob46d_dg
destination for restore of datafile 00059: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/swdt_index1.313.1089966857
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 rob46d_dg
destination for restore of datafile 00060: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/dt_lake_tab.314.1091941871
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00061: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/dt_lake_tab.315.1091941879
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 rob46d_dg
destination for restore of datafile 00062: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.316.1091941945
channel ORA_DISK_1: restore complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00063: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_lrg_data_tbs.317.1091941959
channel ORA_DISK_1: restore complete, elapsed time: 00:00:16
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00064: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.318.1091941977
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00065: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/pmmis_data.319.1092550215
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 rob46d_dg
destination for restore of datafile 00066: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_idx1.320.1092976753
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00067: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/tpow_default.321.1095146243
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00068: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.322.1095193963
channel ORA_DISK_1: restore complete, elapsed time: 00:01:06
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00069: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.323.1095947773
channel ORA_DISK_1: restore complete, elapsed time: 00:01:05
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00070: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.324.1095947837
channel ORA_DISK_1: restore complete, elapsed time: 00:01:05
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service rob46d_dg
destination for restore of datafile 00071: +DATA_DG01/ROB46_TP/BE33EF5DE4077A7DE053B164060AE19B/DATAFILE/orfs_tab1.325.1096805593
channel ORA_DISK_1: restore complete, elapsed time: 00:01:06

starting media recovery

archived log for thread 1 with sequence 43643 is already on disk as file +ARCH_DG01/ROB46_TP/ARCHIVELOG/2022_02_16/thread_1_seq_43643.393.1096814503
archived log for thread 1 with sequence 43644 is already on disk as file +ARCH_DG01/ROB46_TP/ARCHIVELOG/2022_02_16/thread_1_seq_43644.602.1096815069
archived log for thread 1 with sequence 43645 is already on disk as file +ARCH_DG01/ROB46_TP/ARCHIVELOG/2022_02_16/thread_1_seq_43645.757.1096815077
archived log for thread 2 with sequence 42278 is already on disk as file +ARCH_DG01/ROB46_TP/ARCHIVELOG/2022_02_16/thread_2_seq_42278.941.1096814503
archived log for thread 2 with sequence 42279 is already on disk as file +ARCH_DG01/ROB46_TP/ARCHIVELOG/2022_02_16/thread_2_seq_42279.590.1096815073
archived log for thread 2 with sequence 42280 is already on disk as file +ARCH_DG01/ROB46_TP/ARCHIVELOG/2022_02_16/thread_2_seq_42280.533.1096815079
archived log for thread 2 with sequence 42281 is already on disk as file +ARCH_DG01/ROB46_TP/ARCHIVELOG/2022_02_16/thread_2_seq_42281.450.1096815331
archived log file name=+ARCH_DG01/ROB46_TP/ARCHIVELOG/2022_02_16/thread_1_seq_43643.393.1096814503 thread=1 sequence=43643
archived log file name=+ARCH_DG01/ROB46_TP/ARCHIVELOG/2022_02_16/thread_2_seq_42278.941.1096814503 thread=2 sequence=42278
archived log file name=+ARCH_DG01/ROB46_TP/ARCHIVELOG/2022_02_16/thread_1_seq_43644.602.1096815069 thread=1 sequence=43644
archived log file name=+ARCH_DG01/ROB46_TP/ARCHIVELOG/2022_02_16/thread_2_seq_42279.590.1096815073 thread=2 sequence=42279
archived log file name=+ARCH_DG01/ROB46_TP/ARCHIVELOG/2022_02_16/thread_1_seq_43645.757.1096815077 thread=1 sequence=43645
archived log file name=+ARCH_DG01/ROB46_TP/ARCHIVELOG/2022_02_16/thread_2_seq_42280.533.1096815079 thread=2 sequence=42280
media recovery complete, elapsed time: 00:00:03
Finished recover at 16-FEB-22
Executing: alter system set standby_file_management=auto
Finished recover at 16-FEB-22

RMAN>

Now SCNs are matching.


No need to restore standby controlfile as everything apart from logfile have been taken care.


For logfiles, was getting too many errors like this.


2022-02-16T15:16:35.719736+00:00
Errors in file /dborafiles/admin/diag/rdbms/rob46_tp/rob46t1/trace/rob46t1_ora_14767.trc:
ORA-00313: open failed for members of log group 11 of thread 1
ORA-00312: online log 11 thread 1: '+REDO_DG01/ROB46_DY/ONLINELOG/group_11.267.1067948301'
ORA-17503: ksfdopn:2 Failed to open file +REDO_DG01/ROB46_DY/ONLINELOG/group_11.267.1067948301
ORA-15173: entry 'ROB46_DY' does not exist in directory '/'
ORA-00312: online log 11 thread 1: '+REDO_DG02/ROB46_DY/ONLINELOG/group_11.267.1067948299'
ORA-17503: ksfdopn:2 Failed to open file +REDO_DG02/ROB46_DY/ONLINELOG/group_11.267.1067948299
ORA-15173: entry 'ROB46_DY' does not exist in directory '/'

Need to clear all the logfiles and standby logfiles.



  INST_ID     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME  NEXT_CHANGE# NEXT_TIME       CON_ID
---------- ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ----------- ------------ ----------- ----------
         1          1          1      43641  524288000        512          2 YES INACTIVE            1.6107E+13 16-FEB-2022   1.6107E+13 16-FEB-2022          0
         1          2          1      43642  524288000        512          2 YES INACTIVE            1.6107E+13 16-FEB-2022   1.6107E+13 16-FEB-2022          0
         1          3          1      43643  524288000        512          2 NO  CURRENT             1.6107E+13 16-FEB-2022   9.2954E+18                      0
         1          4          1      43640  524288000        512          2 YES INACTIVE            1.6107E+13 16-FEB-2022   1.6107E+13 16-FEB-2022          0
         1          5          2      42278  524288000        512          2 NO  CURRENT             1.6107E+13 16-FEB-2022   9.2954E+18                      0
         1          6          2      42275  524288000        512          2 YES INACTIVE            1.6107E+13 16-FEB-2022   1.6107E+13 16-FEB-2022          0
         1          7          2      42276  524288000        512          2 YES INACTIVE            1.6107E+13 16-FEB-2022   1.6107E+13 16-FEB-2022          0
         1          8          2      42277  524288000        512          2 YES INACTIVE            1.6107E+13 16-FEB-2022   1.6107E+13 16-FEB-2022          0
         2          1          1      43641  524288000        512          2 YES INACTIVE            1.6107E+13 16-FEB-2022   1.6107E+13 16-FEB-2022          0
         2          2          1      43642  524288000        512          2 YES INACTIVE            1.6107E+13 16-FEB-2022   1.6107E+13 16-FEB-2022          0
         2          3          1      43643  524288000        512          2 NO  CURRENT             1.6107E+13 16-FEB-2022   9.2954E+18                      0
         2          4          1      43640  524288000        512          2 YES INACTIVE            1.6107E+13 16-FEB-2022   1.6107E+13 16-FEB-2022          0
         2          5          2      42278  524288000        512          2 NO  CURRENT             1.6107E+13 16-FEB-2022   9.2954E+18                      0
         2          6          2      42275  524288000        512          2 YES INACTIVE            1.6107E+13 16-FEB-2022   1.6107E+13 16-FEB-2022          0
         2          7          2      42276  524288000        512          2 YES INACTIVE            1.6107E+13 16-FEB-2022   1.6107E+13 16-FEB-2022          0
         2          8          2      42277  524288000        512          2 YES INACTIVE            1.6107E+13 16-FEB-2022   1.6107E+13 16-FEB-2022          0


SQL> alter database clear logfile group 1;

Database altered.

SQL> alter database clear logfile group 2;

Database altered.

SQL> alter database clear logfile group 3;

Database altered.

SQL> alter database clear logfile group 4;

Database altered.

SQL> alter database clear logfile group 5;

Database altered.

SQL> alter database clear logfile group 6;

Database altered.

SQL> alter database clear logfile group 7;

Database altered.

SQL> alter database clear logfile group 8;

Database altered.

Cleared all standby redo logfiles also.


Let's check status through broker.

rob46t1 > dgmgrl  /
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Wed Feb 16 15:21:56 2022
Version 19.10.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Welcome to DGMGRL, type "help" for information.
Connected to "rob46_tp"
Connected as SYSDG.
DGMGRL> show configuration

Configuration - rob46_dr

  Protection Mode: MaxPerformance
  Members:
  rob46_dy - Primary database
    rob46_tp - Physical standby database

Fast-Start Failover:  Disabled

Configuration Status:
SUCCESS   (status updated 78 seconds ago)

DGMGRL> show database rob46_tp

Database - rob46_tp

  Role:               PHYSICAL STANDBY
  Intended State:     APPLY-OFF
  Transport Lag:      0 seconds (computed 0 seconds ago)
  Apply Lag:          (unknown)
  Average Apply Rate: (unknown)
  Real Time Query:    OFF
  Instance(s):
    rob46t1 (apply instance)
    rob46t2

Database Status:
SUCCESS

Let's start the Redo Apply.


DGMGRL> edit database rob46_tp set state=APPLY-ON;
Succeeded.

DGMGRL> show database rob46_tp

Database - rob46_tp

  Role:               PHYSICAL STANDBY
  Intended State:     APPLY-ON
  Transport Lag:      0 seconds (computed 0 seconds ago)
  Apply Lag:          0 seconds (computed 0 seconds ago)
  Average Apply Rate: 15.05 MByte/s
  Real Time Query:    OFF
  Instance(s):
    rob46t1 (apply instance)
    rob46t2

Database Status:
SUCCESS

All Clear Now.

0 views0 comments