Sudipta Bhaskar

Feb 16, 202226 min

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

Updated: Sep 16, 2023

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.

    1220
    0