Oracle Fusion Applications

RMAN-03002: failure of switch to copy command

RMAN-06571: datafile 1 does not have recoverable copy

Case
When we are Performing the Rolling forward with the Physical Standby database we may get this error when we are in the final step switch database to copy this error can occur if we have multiple data file destinations

RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of switch to copy command at 05/24/2016 12:53:45
RMAN-06571: datafile 1 does not have recoverable copy

Steps to fix the issue

Step 1 check the data file size's after getting the error by using the report schema command on the physical stand by database

RMAN> report schema;

RMAN-06139: WARNING: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name OMTST

List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.355.867865357
2 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.356.867865373
3 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.357.867865387
4 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.358.867865403
5 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.359.867865417
6 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.345.867865095
7 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.346.867865121
8 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.347.867865145
9 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.348.867865171
10 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.360.867865433
11 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.361.867865449
12 0 APPS_TS_IZU_DAT *** +DATA/omtst/omprod/datafile/apps_ts_izu_dat.364.867865477
13 0 APPS_TS_ARCHIVE *** +DATA/omtst/omprod/datafile/apps_ts_archive.335.867864683
14 0 APPS_TS_INTERFACE *** +DATA/omtst/omprod/datafile/apps_ts_interface.258.867855485
15 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.259.867855671
16 0 APPS_TS_NOLOGGING *** +DATA/omtst/omprod/datafile/apps_ts_nologging.309.867862737
17 0 APPS_TS_QUEUES *** +DATA/omtst/omprod/datafile/apps_ts_queues.316.867863425
18 0 APPS_TS_QUEUES *** +DATA/omtst/omprod/datafile/apps_ts_queues.332.867864497
19 0 APPS_TS_SEED *** +DATA/omtst/omprod/datafile/apps_ts_seed.353.867865317
20 0 APPS_TS_SEED *** +DATA/omtst/omprod/datafile/apps_ts_seed.349.867865197
21 0 APPS_TS_SUMMARY *** +DATA/omtst/omprod/datafile/apps_ts_summary.256.867855057
22 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.271.867857825
23 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.273.867858165
24 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.272.867858001
25 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.313.867863169
26 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.308.867862611
27 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.310.867862863
28 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.299.867861393
29 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.274.867858331
30 0 CTXD *** +DATA/omtst/omprod/datafile/ctxd.367.867865487
31 0 ODM *** +DATA/omtst/omprod/datafile/odm.368.867865491
32 0 OLAP *** +DATA/omtst/omprod/datafile/olap.369.867865491
33 0 OWAPUB *** +DATA/omtst/omprod/datafile/owapub.372.867865495
34 0 PORTAL *** +DATA/omtst/omprod/datafile/portal.370.867865493
35 0 SYSAUX *** +DATA/omtst/omprod/datafile/sysaux.350.867865221
36 0 APPS_TS_CUSTM_DATA *** +DATA/omtst/omprod/datafile/apps_ts_custm_data.307.867862477
37 0 APPS_TS_CUSTM_IDX *** +DATA/omtst/omprod/datafile/apps_ts_custm_idx.362.867865463
38 0 SYSAUX *** +DATA/omtst/omprod/datafile/sysaux.343.867865025
39 0 UNDOTBS1 *** +DATA/omtst/omprod/datafile/undotbs1.336.867864739
40 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.266.867856949
41 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.311.867862967
42 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.260.867855855
43 0 ORABPEL *** +DATA/omtst/omprod/datafile/orabpel.371.867865493
44 0 APPS_TS_IZU_IDX *** +DATA/omtst/omprod/datafile/apps_ts_izu_idx.365.867865481
45 0 APPS_TS_TOOLS *** +DATA/omtst/omprod/datafile/apps_ts_tools.363.867865471
46 0 UNDOTBS1 *** +DATA/omtst/omprod/datafile/undotbs1.333.867864573
47 0 UNDOTBS2 *** +DATA/omtst/omprod/datafile/undotbs2.337.867864773
48 0 APPS_TS_ARCHIVE *** +DATA/omtst/omprod/datafile/apps_ts_archive.338.867864809
49 0 SYSAUX *** +DATA/omtst/omprod/datafile/sysaux.351.867865257
50 0 APPS_TS_INTERFACE *** +DATA/omtst/omprod/datafile/apps_ts_interface.275.867858487
51 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.300.867861529
52 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.261.867856041
53 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.301.867861665
54 0 UNDOTBS1 *** +DATA/omtst/omprod/datafile/undotbs1.339.867864855
55 0 UNDOTBS2 *** +DATA/omtst/omprod/datafile/undotbs2.315.867863369
56 0 APPS_TS_CUSTM_DATA *** +DATA/omtst/omprod/datafile/apps_ts_custm_data.302.867861799
57 0 APPS_TS_INTERFACE *** +DATA/omtst/omprod/datafile/apps_ts_interface.276.867858621
58 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.262.867856227
59 0 UNDOTBS1 *** +DATA/omtst/omprod/datafile/undotbs1.340.867864889
60 0 APPS_TS_ARCHIVE *** +DATA/omtst/omprod/datafile/apps_ts_archive.312.867863073
61 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.267.867857133
62 0 SYSAUX *** +DATA/omtst/omprod/datafile/sysaux.352.867865291
63 0 APPS_TS_CUSTM_DATA *** +DATA/omtst/omprod/datafile/apps_ts_custm_data.303.867861935
64 0 APPS_TS_CUSTM_DATA *** +DATA/omtst/omprod/datafile/apps_ts_custm_data.334.867864619
65 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.277.867858757
66 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.263.867856403
67 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.268.867857309
68 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.304.867862071
69 0 APPS_TS_SUMMARY *** +DATA/omtst/omprod/datafile/apps_ts_summary.257.867855299
70 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.269.867857475
71 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.278.867858923
72 0 SYSAUX *** +DATA/omtst/omprod/datafile/sysaux.354.867865343
73 0 APPS_TS_NOLOGGING *** +DATA/omtst/omprod/datafile/apps_ts_nologging.314.867863273
74 0 APPS_TS_QUEUES *** +DATA/omtst/omprod/datafile/apps_ts_queues.317.867863509
75 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.305.867862205
76 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.264.867856577
77 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.265.867856763
78 0 APPS_TS_NOLOGGING *** +DATA/omtst/omprod/datafile/apps_ts_nologging.306.867862341
79 0 SYSAUX *** +DATA/omtst/omprod/datafile/sysaux.341.867864935
80 0 APPS_TS_TOOLS *** +DATA/omtst/omprod/datafile/apps_ts_tools.344.867865071
81 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.270.867857649
82 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.279.867859087
83 0 INTERIM *** +DATA/omtst/omprod/datafile/interim.366.867865483
84 0 UNDOTBS2 *** +DATA/omtst/omprod/datafile/undotbs2.318.867863595
85 0 UNDOTBS2 *** +DATA/omtst/omprod/datafile/undotbs2.319.867863639
86 0 UNDOTBS1 *** +DATA/omtst/omprod/datafile/undotbs1.320.867863685
87 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.280.867859263
88 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.281.867859399
89 0 APPS_TS_CUSTM_IDX *** +DATA/omtst/omprod/datafile/apps_ts_custm_idx.282.867859543
90 0 APPS_TS_CUSTM_DATA *** +DATA/omtst/omprod/datafile/apps_ts_custm_data.321.867863731
91 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.322.867863805
92 0 APPS_TS_NOLOGGING *** +DATA/omtst/omprod/datafile/apps_ts_nologging.293.867860723
93 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.323.867863881
94 0 APPS_TS_INTERFACE *** +DATA/omtst/omprod/datafile/apps_ts_interface.324.867863955
95 0 APPS_TS_QUEUES *** +DATA/omtst/omprod/datafile/apps_ts_queues.325.867864001
96 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.326.867864067
97 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.327.867864141
98 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.328.867864217
99 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.329.867864283
100 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.330.867864347
101 0 APPS_TS_CUSTM_DATA *** +DATA/omtst/omprod/datafile/apps_ts_custm_data.331.867864423
102 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.283.867859639
103 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.284.867859785
104 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.342.867864979
105 0 UNDOTBS1 *** +DATA/omtst/omprod/datafile/undotbs1.285.867859919
106 0 UNDOTBS1 *** +DATA/omtst/omprod/datafile/undotbs1.286.867860005
107 0 UNDOTBS1 *** +DATA/omtst/omprod/datafile/undotbs1.287.867860091
108 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.288.867860185
109 0 APPS_TS_CUSTM_DATA *** +DATA/omtst/omprod/datafile/apps_ts_custm_data.294.867860847
110 0 APPS_TS_SUMMARY *** +DATA/omtst/omprod/datafile/apps_ts_summary.295.867860953
111 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.296.867861037
112 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.297.867861163
113 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.298.867861259
114 0 SYSAUX *** +DATA/omtst/omprod/datafile/sysaux.289.867860321
115 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.290.867860427
116 0 UNDOTBS1 *** +DATA/omtst/omprod/datafile/undotbs1.291.867860521
117 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.292.867860607
118 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.394.869490097
119 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.395.872426247
120 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.396.872426271
121 0 APPS_TS_QUEUES *** +DATA/omtst/omprod/datafile/apps_ts_queues.397.872509221
122 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.398.872509571
123 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.399.872509661
124 0 APPS_TS_NOLOGGING *** +DATA/omtst/omprod/datafile/apps_ts_nologging.400.872510081
125 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.409.875113199
126 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.410.875262145
127 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.411.875262309
128 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.412.876319533
129 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.413.876562541
130 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.414.877597745
131 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.415.877600247
132 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.416.877600353
133 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.417.878573823
134 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.418.878831985
135 0 AUDIT_TS *** +DATA/omtst/omprod/datafile/audit_ts.419.878575229
136 0 AUDIT_TS *** +DATA/omtst/omprod/datafile/audit_ts.420.878575491
137 0 APPS_TS_CUSTM_DATA *** +DATA/omtst/omprod/datafile/apps_ts_custm_data.421.878832133
138 0 CTXD *** +DATA/omtst/omprod/datafile/ctxd.422.881502199
139 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.423.881502271
140 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.424.881502327
141 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.425.881502379
142 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.426.881628301
143 0 SYSTEM *** +DATA/omtst/omprod/datafile/system.427.881809197
144 0 SYSAUX *** +DATA/omtst/omprod/datafile/sysaux.428.882271107
145 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.429.883236289
146 0 SYSAUX *** +DATA/omtst/omprod/datafile/sysaux.430.885207931
147 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.431.885208011
148 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.432.887565481
149 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.433.889281883
150 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.434.890506819
151 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.435.892462431
152 10204 XXLAAPPS_TS_PGC *** +DATA/omtst/omprod/datafile/xxlaapps_ts_pgc.dbf
153 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.437.893754595
154 0 SYSAUX *** +DATA/omtst/omprod/datafile/sysaux.438.894619813
155 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.439.894979101
156 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.440.896180625
157 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.441.896180719
158 0 APPS_TS_NOLOGGING *** +DATA/omtst/omprod/datafile/apps_ts_nologging.442.897699837
159 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.443.898082229
160 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.444.899803901
161 0 SYSAUX *** +DATA/omtst/omprod/datafile/sysaux.445.900753991
162 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.446.900846513
163 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.447.901015201
164 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.448.902575489
165 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.449.902575561
166 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.450.903180065
167 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.451.903180117
168 0 APPS_TS_CUSTM_DATA *** +DATA/omtst/omprod/datafile/apps_ts_custm_data.452.903180321
169 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.453.903784535
170 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.454.904572949
171 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.455.904573113
172 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.456.906548515
173 0 SYSAUX *** +DATA/omtst/omprod/datafile/sysaux.457.906986501
174 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.458.907597677
175 0 APPS_TS_ARCHIVE *** +DATA/omtst/omprod/datafile/apps_ts_archive.459.907837785
176 0 APPS_TS_ARCHIVE *** +DATA/omtst/omprod/datafile/apps_ts_archive.460.907837823
177 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.461.908189713
178 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.462.908528903
179 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.463.909752353
180 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.464.910091463
181 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.465.910259333
182 0 SYSAUX *** +DATA/omtst/omprod/datafile/sysaux.466.910787657
183 0 APPS_TS_TX_IDX *** +DATA/omtst/omprod/datafile/apps_ts_tx_idx.467.911390073
184 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.468.911578213
185 0 APPS_TS_TX_DATA *** +DATA/omtst/omprod/datafile/apps_ts_tx_data.469.912070637
186 0 APPS_TS_MEDIA *** +DATA/omtst/omprod/datafile/apps_ts_media.470.912247599

List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20460 TMP 20460 +DATA/omtst/omprod/tempfile/tmp.393.868592555

RMAN>

Check the File size if it is zero we are good and we can proceed as the particular file structure is not available in the server . the File structure had been mentioned in the wrong path and the actual files lies in the different place inside the ASM . so to check the current file path structure we need to use list copy of database command to find the current structure of the database

Step 2 Check the database copy in the Physical stand by database

Check the copy of the database by using the list copy of database command in rman to find what is the location of the data file and if it is the oracle managed files the file names[ the numeric digit appeared in the file names might be changed but the data file number remains same ]

RMAN> list copy of database;

using target database control file instead of recovery catalog

List of Datafile Copies

=======================

Key File S Completion Time Ckp SCN Ckp Time

------- ---- - --------------- ---------- ---------------

631 1 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/system.806.911262335

766 2 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/system.1115.911357993

735 3 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/system.910.911310973

678 4 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/system.853.911278423

632 5 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/system.807.911262345

732 6 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/system.907.911310387

674 7 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/system.849.911277801

628 8 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/system.803.911261643

764 9 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/system.1113.911357807

767 10 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/system.1116.911358029

736 11 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/system.911.911311025

768 12 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_izu_dat.1117.911358163

729 13 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_archive.904.911309895

636 14 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_interface.811.911262669

637 15 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.812.911262669

752 16 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_nologging.1101.911354973

665 17 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_queues.840.911275265

670 18 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_queues.845.911277123

734 19 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_seed.909.911310941

733 20 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_seed.908.911310925

682 21 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_summary.857.911278681

594 22 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.768.911247503

698 23 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.875.911295151

686 24 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.861.911278685

722 25 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.897.911307251

721 26 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.896.911307149

618 27 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.793.911258823

661 28 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.836.911274599

595 29 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.419.911247503

634 30 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/ctxd.809.911262553

680 31 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/odm.855.911278599

770 32 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/olap.1119.911358175

635 33 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/owapub.810.911262553

681 34 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/portal.856.911278599

675 35 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/sysaux.850.911278095

617 36 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_custm_data.792.911258635

679 37 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_custm_idx.854.911278589

627 38 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/sysaux.802.911261641

625 39 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/undotbs1.800.911261379

639 40 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.814.911262671

664 41 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.839.911275115

591 42 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.771.911247499

738 43 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/orabpel.913.911311065

769 44 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_izu_idx.1118.911358169

633 45 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tools.808.911262553

671 46 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/undotbs1.846.911277279

730 47 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/undotbs2.905.911309895

672 48 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_archive.847.911277643

629 49 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/sysaux.804.911261715

641 50 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_interface.816.911262671

719 51 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.894.911306493

683 52 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.858.911278683

750 53 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.1099.911354347

626 54 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/undotbs1.801.911261379

723 55 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/undotbs2.898.911307481

662 56 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_custm_data.837.911274599

699 57 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_interface.874.911295151

638 58 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.813.911262669

761 59 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/undotbs1.1110.911357433

753 60 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_archive.1102.911355143

593 61 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.767.911247501

765 62 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/sysaux.1114.911357895

616 63 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_custm_data.791.911258447

760 64 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_custm_data.1109.911357283

687 65 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.862.911278685

592 66 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.418.911247501

685 67 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.860.911278685

720 68 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.895.911307147

590 69 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_summary.772.911247499

697 70 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.876.911295149

596 71 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.770.911247503

676 72 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/sysaux.851.911278367

619 73 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_nologging.794.911259193

754 74 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_queues.1103.911355439

751 75 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.1100.911354831

684 76 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.859.911278683

696 77 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.870.911295149

663 78 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_nologging.838.911274961

731 79 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/sysaux.906.911310071

762 80 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tools.1111.911357433

640 81 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.815.911262671

642 82 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.817.911262673

737 83 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/interim.912.911311025

755 84 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/undotbs2.1104.911355441

724 85 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/undotbs2.899.911307789

620 86 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/undotbs1.795.911259193

700 87 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.873.911295151

688 88 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.863.911278687

597 89 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_custm_idx.769.911247505

667 90 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_custm_data.842.911275271

756 91 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.1105.911356719

709 92 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_nologging.884.911300681

725 93 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.900.911309439

621 94 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_interface.796.911259557

668 95 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_queues.843.911276821

757 96 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.1106.911356887

726 97 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.901.911309571

622 98 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.797.911260813

669 99 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.844.911276843

758 100 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.1107.911357121

727 101 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_custm_data.902.911309679

643 102 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.818.911262673

701 103 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.872.911295153

673 104 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.848.911277801

689 105 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/undotbs1.864.911278687

598 106 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/undotbs1.773.911251135

644 107 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/undotbs1.819.911266667

702 108 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.877.911295153

741 109 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_custm_data.916.911350069

606 110 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_summary.781.911254385

652 111 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.827.911270197

710 112 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.885.911303003

742 113 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.917.911350779

690 114 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/sysaux.865.911283137

599 115 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.774.911251781

645 116 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/undotbs1.820.911267235

703 117 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.878.911299341

607 118 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.782.911254843

695 119 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.871.911295147

653 120 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.828.911270773

711 121 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_queues.886.911303003

691 122 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.866.911283137

600 123 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.775.911251783

646 124 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_nologging.821.911267235

704 125 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/system.879.911299341

692 126 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.867.911283807

601 127 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.776.911251971

647 128 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/system.822.911267587

743 129 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/system.918.911350781

705 130 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/system.880.911299341

693 131 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/system.868.911283997

608 132 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/system.783.911254843

623 133 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/system.798.911261103

654 134 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/system.829.911270775

602 135 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/audit_ts.777.911252157

712 136 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/audit_ts.887.911303003

744 137 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_custm_data.919.911351415

630 138 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/ctxd.805.911262279

648 139 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.823.911267759

706 140 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.881.911299949

759 141 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/system.1108.911357185

728 142 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/system.903.911309827

624 143 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/system.799.911261205

677 144 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/sysaux.852.911278423

609 145 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.784.911254975

655 146 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/sysaux.830.911271109

713 147 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.888.911303583

745 148 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.920.911351611

610 149 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.785.911255151

656 150 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.831.911271281

714 151 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.889.911303583

694 153 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.869.911284185

611 154 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/sysaux.786.911255465

657 155 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.832.911271459

715 156 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.890.911303933

746 157 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.410.911352141

603 158 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_nologging.778.911252493

612 159 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.787.911255501

658 160 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.833.911271459

649 161 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/sysaux.824.911267929

716 162 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.891.911304275

707 163 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.882.911299951

747 164 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.411.911352143

613 165 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.788.911255865

659 166 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.834.911271481

739 167 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.914.911348447

604 168 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_custm_data.779.911252493

650 169 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.825.911267929

717 170 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.892.911306437

748 171 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.412.911353695

614 172 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.789.911257795

660 173 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/sysaux.835.911273921

718 174 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.893.911306447

763 175 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_archive.1112.911357623

749 176 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_archive.413.911354345

708 177 A 24-MAY-16 67283504852 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.883.911300319

740 178 A 24-MAY-16 67283503824 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.915.911348447

605 179 A 24-MAY-16 67283504283 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.780.911252815

615 180 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.790.911258445

651 181 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.826.911267929

666 182 A 24-MAY-16 67283501457 23-MAY-16

Name: +DATA/omtst/datafile/sysaux.841.911275265

771 183 A 24-MAY-16 67283502006 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_idx.755.911422499

772 184 A 24-MAY-16 67283505081 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.753.911638093

773 185 A 24-MAY-16 67283502578 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_tx_data.752.912085467

774 186 A 24-MAY-16 67283503343 23-MAY-16

Name: +DATA/omtst/datafile/apps_ts_media.751.912523391

Step 3 IF some files has the values zero then run the Switch data file command

The file path which is stored inside the control_file is wrong we need to use the switch data file command to update the control file from the old path to the new Path the old path is where the path mentioned in the report schema and the new path is the path mentioned in the list copy of database command the physical file will be residing in the path of list copy of database command result

In Rman connect as the Physical standby database as target and run the switch data file command
run
{
Switch datafile '+DATA/omtst/omprod/datafile/APPS_TS_ARCHIVE.1102.911355143' to datafilecopy '+DATA/omtst/datafile/APPS_TS_ARCHIVE.1102.911355143';

}

Prepare a script with the source and destination path for all the files and run in rman the switch data file command should be executed under the run { } command syntax in rman

Once the script complete's you can check by using the report schema now you will find all the filw with the original size's which is equal to the source [Primary database]

Step 4 Issue report schema command to check and verify the size of the data file and issue the switch database to copy

RMAN> report schema;

RMAN-06139: WARNING: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name OMTST

List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 1000 SYSTEM *** +DATA/omtst/datafile/system.806.911262335
2 1000 SYSTEM *** +DATA/omtst/datafile/system.1115.911357993
3 1000 SYSTEM *** +DATA/omtst/datafile/system.910.911310973
4 1000 SYSTEM *** +DATA/omtst/datafile/system.853.911278423
5 1000 SYSTEM *** +DATA/omtst/datafile/system.807.911262345
6 2000 SYSTEM *** +DATA/omtst/datafile/system.907.911310387
7 2000 SYSTEM *** +DATA/omtst/datafile/system.849.911277801
8 2000 SYSTEM *** +DATA/omtst/datafile/system.803.911261643
9 2000 SYSTEM *** +DATA/omtst/datafile/system.1113.911357807
10 1000 SYSTEM *** +DATA/omtst/datafile/system.1116.911358029
11 1000 SYSTEM *** +DATA/omtst/datafile/system.911.911311025
12 200 APPS_TS_IZU_DAT *** +DATA/omtst/datafile/apps_ts_izu_dat.1117.911358163
13 4000 APPS_TS_ARCHIVE *** +DATA/omtst/datafile/apps_ts_archive.904.911309895
14 14000 APPS_TS_INTERFACE *** +DATA/omtst/datafile/apps_ts_interface.811.911262669
15 14000 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.812.911262669
16 8500 APPS_TS_NOLOGGING *** +DATA/omtst/datafile/apps_ts_nologging.1101.911354973
17 6000 APPS_TS_QUEUES *** +DATA/omtst/datafile/apps_ts_queues.840.911275265
18 5000 APPS_TS_QUEUES *** +DATA/omtst/datafile/apps_ts_queues.845.911277123
19 1500 APPS_TS_SEED *** +DATA/omtst/datafile/apps_ts_seed.909.911310941
20 2000 APPS_TS_SEED *** +DATA/omtst/datafile/apps_ts_seed.908.911310925
21 18500 APPS_TS_SUMMARY *** +DATA/omtst/datafile/apps_ts_summary.857.911278681
22 12500 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.768.911247503
23 12000 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.875.911295151
24 12500 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.861.911278685
25 7500 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.897.911307251
26 9000 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.896.911307149
27 8000 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.793.911258823
28 10000 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.836.911274599
29 12000 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.419.911247503
30 100 CTXD *** +DATA/omtst/datafile/ctxd.809.911262553
31 100 ODM *** +DATA/omtst/datafile/odm.855.911278599
32 100 OLAP *** +DATA/omtst/datafile/olap.1119.911358175
33 10 OWAPUB *** +DATA/omtst/datafile/owapub.810.911262553
34 100 PORTAL *** +DATA/omtst/datafile/portal.856.911278599
35 2000 SYSAUX *** +DATA/omtst/datafile/sysaux.850.911278095
36 9500 APPS_TS_CUSTM_DATA *** +DATA/omtst/datafile/apps_ts_custm_data.792.911258635
37 512 APPS_TS_CUSTM_IDX *** +DATA/omtst/datafile/apps_ts_custm_idx.854.911278589
38 3000 SYSAUX *** +DATA/omtst/datafile/sysaux.802.911261641
39 4000 UNDOTBS1 *** +DATA/omtst/datafile/undotbs1.800.911261379
40 13500 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.814.911262671
41 8000 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.839.911275115
42 14000 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.771.911247499
43 100 ORABPEL *** +DATA/omtst/datafile/orabpel.913.911311065
44 200 APPS_TS_IZU_IDX *** +DATA/omtst/datafile/apps_ts_izu_idx.1118.911358169
45 500 APPS_TS_TOOLS *** +DATA/omtst/datafile/apps_ts_tools.808.911262553
46 4500 UNDOTBS1 *** +DATA/omtst/datafile/undotbs1.846.911277279
47 4000 UNDOTBS2 *** +DATA/omtst/datafile/undotbs2.905.911309895
48 4000 APPS_TS_ARCHIVE *** +DATA/omtst/datafile/apps_ts_archive.847.911277643
49 2000 SYSAUX *** +DATA/omtst/datafile/sysaux.804.911261715
50 12000 APPS_TS_INTERFACE *** +DATA/omtst/datafile/apps_ts_interface.816.911262671
51 10000 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.894.911306493
52 14000 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.858.911278683
53 10000 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.1099.911354347
54 4000 UNDOTBS1 *** +DATA/omtst/datafile/undotbs1.801.911261379
55 6500 UNDOTBS2 *** +DATA/omtst/datafile/undotbs2.898.911307481
56 10000 APPS_TS_CUSTM_DATA *** +DATA/omtst/datafile/apps_ts_custm_data.837.911274599
57 12000 APPS_TS_INTERFACE *** +DATA/omtst/datafile/apps_ts_interface.874.911295151
58 14000 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.813.911262669
59 4000 UNDOTBS1 *** +DATA/omtst/datafile/undotbs1.1110.911357433
60 8000 APPS_TS_ARCHIVE *** +DATA/omtst/datafile/apps_ts_archive.1102.911355143
61 13000 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.767.911247501
62 2000 SYSAUX *** +DATA/omtst/datafile/sysaux.1114.911357895
63 10000 APPS_TS_CUSTM_DATA *** +DATA/omtst/datafile/apps_ts_custm_data.791.911258447
64 4500 APPS_TS_CUSTM_DATA *** +DATA/omtst/datafile/apps_ts_custm_data.1109.911357283
65 12000 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.862.911278685
66 14000 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.418.911247501
67 13000 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.860.911278685
68 10000 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.895.911307147
69 15000 APPS_TS_SUMMARY *** +DATA/omtst/datafile/apps_ts_summary.772.911247499
70 13000 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.876.911295149
71 12000 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.770.911247503
72 1024 SYSAUX *** +DATA/omtst/datafile/sysaux.851.911278367
73 7000 APPS_TS_NOLOGGING *** +DATA/omtst/datafile/apps_ts_nologging.794.911259193
74 6000 APPS_TS_QUEUES *** +DATA/omtst/datafile/apps_ts_queues.1103.911355439
75 10000 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.1100.911354831
76 14000 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.859.911278683
77 14000 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.870.911295149
78 10000 APPS_TS_NOLOGGING *** +DATA/omtst/datafile/apps_ts_nologging.838.911274961
79 3072 SYSAUX *** +DATA/omtst/datafile/sysaux.906.911310071
80 2048 APPS_TS_TOOLS *** +DATA/omtst/datafile/apps_ts_tools.1111.911357433
81 13000 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.815.911262671
82 12000 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.817.911262673
83 200 INTERIM *** +DATA/omtst/datafile/interim.912.911311025
84 5120 UNDOTBS2 *** +DATA/omtst/datafile/undotbs2.1104.911355441
85 5120 UNDOTBS2 *** +DATA/omtst/datafile/undotbs2.899.911307789
86 5120 UNDOTBS1 *** +DATA/omtst/datafile/undotbs1.795.911259193
87 10240 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.873.911295151
88 10240 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.863.911278687
89 10240 APPS_TS_CUSTM_IDX *** +DATA/omtst/datafile/apps_ts_custm_idx.769.911247505
90 5120 APPS_TS_CUSTM_DATA *** +DATA/omtst/datafile/apps_ts_custm_data.842.911275271
91 5120 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.1105.911356719
92 10204 APPS_TS_NOLOGGING *** +DATA/omtst/datafile/apps_ts_nologging.884.911300681
93 5120 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.900.911309439
94 5120 APPS_TS_INTERFACE *** +DATA/omtst/datafile/apps_ts_interface.796.911259557
95 5120 APPS_TS_QUEUES *** +DATA/omtst/datafile/apps_ts_queues.843.911276821
96 5120 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.1106.911356887
97 5120 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.901.911309571
98 5120 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.797.911260813
99 5120 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.844.911276843
100 5120 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.1107.911357121
101 5120 APPS_TS_CUSTM_DATA *** +DATA/omtst/datafile/apps_ts_custm_data.902.911309679
102 10240 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.818.911262673
103 10240 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.872.911295153
104 3072 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.848.911277801
105 10240 UNDOTBS1 *** +DATA/omtst/datafile/undotbs1.864.911278687
106 10240 UNDOTBS1 *** +DATA/omtst/datafile/undotbs1.773.911251135
107 10240 UNDOTBS1 *** +DATA/omtst/datafile/undotbs1.819.911266667
108 10240 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.877.911295153
109 10204 APPS_TS_CUSTM_DATA *** +DATA/omtst/datafile/apps_ts_custm_data.916.911350069
110 10204 APPS_TS_SUMMARY *** +DATA/omtst/datafile/apps_ts_summary.781.911254385
111 10204 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.827.911270197
112 10204 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.885.911303003
113 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.917.911350779
114 10240 SYSAUX *** +DATA/omtst/datafile/sysaux.865.911283137
115 10240 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.774.911251781
116 10240 UNDOTBS1 *** +DATA/omtst/datafile/undotbs1.820.911267235
117 10240 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.878.911299341
118 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.782.911254843
119 32767 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.871.911295147
120 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.828.911270773
121 10204 APPS_TS_QUEUES *** +DATA/omtst/datafile/apps_ts_queues.886.911303003
122 10240 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.866.911283137
123 10240 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.775.911251783
124 10240 APPS_TS_NOLOGGING *** +DATA/omtst/datafile/apps_ts_nologging.821.911267235
125 10240 SYSTEM *** +DATA/omtst/datafile/system.879.911299341
126 10240 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.867.911283807
127 10240 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.776.911251971
128 10240 SYSTEM *** +DATA/omtst/datafile/system.822.911267587
129 10204 SYSTEM *** +DATA/omtst/datafile/system.918.911350781
130 10240 SYSTEM *** +DATA/omtst/datafile/system.880.911299341
131 10240 SYSTEM *** +DATA/omtst/datafile/system.868.911283997
132 10204 SYSTEM *** +DATA/omtst/datafile/system.783.911254843
133 5024 SYSTEM *** +DATA/omtst/datafile/system.798.911261103
134 10204 SYSTEM *** +DATA/omtst/datafile/system.829.911270775
135 10240 AUDIT_TS *** +DATA/omtst/datafile/audit_ts.777.911252157
136 10204 AUDIT_TS *** +DATA/omtst/datafile/audit_ts.887.911303003
137 10204 APPS_TS_CUSTM_DATA *** +DATA/omtst/datafile/apps_ts_custm_data.919.911351415
138 1024 CTXD *** +DATA/omtst/datafile/ctxd.805.911262279
139 10240 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.823.911267759
140 10240 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.881.911299949
141 5000 SYSTEM *** +DATA/omtst/datafile/system.1108.911357185
142 5000 SYSTEM *** +DATA/omtst/datafile/system.903.911309827
143 5000 SYSTEM *** +DATA/omtst/datafile/system.799.911261205
144 1024 SYSAUX *** +DATA/omtst/datafile/sysaux.852.911278423
145 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.784.911254975
146 10204 SYSAUX *** +DATA/omtst/datafile/sysaux.830.911271109
147 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.888.911303583
148 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.920.911351611
149 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.785.911255151
150 10204 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.831.911271281
151 10204 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.889.911303583
152 10204 XXLAAPPS_TS_PGC *** +DATA/omtst/omprod/datafile/xxlaapps_ts_pgc.dbf
153 10240 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.869.911284185
154 10204 SYSAUX *** +DATA/omtst/datafile/sysaux.786.911255465
155 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.832.911271459
156 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.890.911303933
157 10204 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.410.911352141
158 10240 APPS_TS_NOLOGGING *** +DATA/omtst/datafile/apps_ts_nologging.778.911252493
159 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.787.911255501
160 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.833.911271459
161 10240 SYSAUX *** +DATA/omtst/datafile/sysaux.824.911267929
162 10204 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.891.911304275
163 10240 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.882.911299951
164 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.411.911352143
165 10204 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.788.911255865
166 10204 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.834.911271481
167 10240 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.914.911348447
168 10240 APPS_TS_CUSTM_DATA *** +DATA/omtst/datafile/apps_ts_custm_data.779.911252493
169 10240 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.825.911267929
170 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.892.911306437
171 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.412.911353695
172 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.789.911257795
173 10204 SYSAUX *** +DATA/omtst/datafile/sysaux.835.911273921
174 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.893.911306447
175 2048 APPS_TS_ARCHIVE *** +DATA/omtst/datafile/apps_ts_archive.1112.911357623
176 10204 APPS_TS_ARCHIVE *** +DATA/omtst/datafile/apps_ts_archive.413.911354345
177 10240 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.883.911300319
178 10240 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.915.911348447
179 10240 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.780.911252815
180 10204 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.790.911258445
181 10240 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.826.911267929
182 5124 SYSAUX *** +DATA/omtst/datafile/sysaux.841.911275265
183 10240 APPS_TS_TX_IDX *** +DATA/omtst/datafile/apps_ts_tx_idx.755.911422499
184 10204 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.753.911638093
185 10240 APPS_TS_TX_DATA *** +DATA/omtst/datafile/apps_ts_tx_data.752.912085467
186 10240 APPS_TS_MEDIA *** +DATA/omtst/datafile/apps_ts_media.751.912523391

List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20460 TMP 20460 +DATA/omtst/tempfile/tmp.454.912764621

RMAN>

Oracle Fusion Applications

Thursday, May 26, 2016

RMAN-03002: failure of switch to copy command

RMAN-06571: datafile 1 does not have recoverable copy

No comments:

Post a Comment