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:
WARNINGLet'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 STANDBYCheck 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
----------------
16075439297096DGMGRL> 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:
SUCCESSNow 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:
SUCCESSAll Clear Now.