restore_rman.sql

run{

set newname for datafile 354 to '/ORADB/oradata/UAT/system11.dbf';

set newname for datafile 353 to '/ORADB/oradata/UAT/system08.dbf';

set newname for datafile 352 to '/ORADB/oradata/UAT/system09.dbf';

set newname for datafile 351 to '/ORADB/oradata/UAT/system07.dbf';

set newname for datafile 295 to '/ORADB/oradata/UAT/system06.dbf';

set newname for datafile 288 to '/ORADB/oradata/UAT/system10.dbf';

set newname for datafile 13 to '/ORADB/oradata/UAT/system12.dbf';

set newname for datafile 5 to '/ORADB/oradata/UAT/system05.dbf';

set newname for datafile 4 to '/ORADB/oradata/UAT/system04.dbf';

set newname for datafile 3 to '/ORADB/oradata/UAT/system03.dbf';

set newname for datafile 2 to '/ORADB/oradata/UAT/system02.dbf';

set newname for datafile 1 to '/ORADB/oradata/UAT/system01.dbf';

set newname for datafile 163 to '/ORADB/oradata/UAT/system012.dbf';

set newname for datafile 235 to '/ORADB/oradata/UAT/system013.dbf ';

set newname for datafile 6 to '/ORADB/oradata/UAT/ctxd01.dbf';

set newname for datafile 7 to '/ORADB/oradata/UAT/owad01.dbf';

set newname for datafile 8 to '/ORADB/oradata/UAT/a_queue02.dbf';

set newname for datafile 9 to '/ORADB/oradata/UAT/odm.dbf';

set newname for datafile 10 to '/ORADB/oradata/UAT/olap.dbf';

set newname for datafile 11 to '/ORADB/oradata/UAT/sysaux01.dbf';

set newname for datafile 12 to '/ORADB/oradata/UAT/apps_ts_tools01.dbf';

set newname for datafile 14 to '/ORADB/oradata/UAT/a_txn_data04.dbf';

set newname for datafile 15 to '/ORADB/oradata/UAT/a_txn_ind06.dbf';

set newname for datafile 16 to '/ORADB/oradata/UAT/a_ref03.dbf';

set newname for datafile 17 to '/ORADB/oradata/UAT/a_int02.dbf';

set newname for datafile 18 to '/ORADB/oradata/UAT/sysaux02.dbf';

set newname for datafile 19 to '/ORADB/oradata/UAT/olap01.dbf';

set newname for datafile 20 to '/ORADB/oradata/UAT/TGTJ01.dbf';

set newname for datafile 21 to '/ORADB/oradata/UAT/TGTJ02.dbf';

set newname for datafile 22 to '/ORADB/oradata/UAT/undo02.dbf';

set newname for datafile 23 to '/ORADB/oradata/UAT/users01.dbf';

set newname for datafile 24 to '/ORADB/oradata/UAT/users02.dbf';

set newname for datafile 25 to '/ORADB/oradata/UAT/undo03.dbf';

set newname for datafile 26 to '/ORADB/oradata/UAT/a_media02.dbf';

set newname for datafile 27 to '/ORADB/oradata/UAT/a_summ02.dbf';

set newname for datafile 28 to '/ORADB/oradata/UAT/undo04.dbf';

set newname for datafile 29 to '/ORADB/oradata/UAT/a_txn_data05.dbf';

set newname for datafile 30 to '/ORADB/oradata/UAT/undo05.dbf';

set newname for datafile 31 to '/ORADB/oradata/UAT/a_txn_data06.dbf';

set newname for datafile 32 to '/ORADB/oradata/UAT/a_txn_data07.dbf';

set newname for datafile 33 to '/ORADB/oradata/UAT/a_media03.dbf';

set newname for datafile 34 to '/ORADB/oradata/UAT/a_txn_data08.dbf';

set newname for datafile 35 to '/ORADB/oradata/UAT/a_summ03.dbf';

set newname for datafile 36 to '/ORADB/oradata/UAT/a_txn_data09.dbf';

set newname for datafile 37 to '/ORADB/oradata/UAT/a_txn_data10.dbf';

set newname for datafile 38 to '/ORADB/oradata/UAT/a_archive02.dbf';

set newname for datafile 39 to '/ORADB/oradata/UAT/a_txn_ind07.dbf';

set newname for datafile 40 to '/ORADB/oradata/UAT/users03.dbf';

set newname for datafile 41 to '/ORADB/oradata/UAT/a_txn_data11.dbf';

set newname for datafile 42 to '/ORADB/oradata/UAT/a_txn_data12.dbf';

set newname for datafile 43 to '/ORADB/oradata/UAT/a_txn_ind08.dbf';

set newname for datafile 44 to '/ORADB/oradata/UAT/a_txn_ind09.dbf';

set newname for datafile 45 to '/ORADB/oradata/UAT/a_txn_data13.dbf';

set newname for datafile 46 to '/ORADB/oradata/UAT/a_txn_data14.dbf';

set newname for datafile 47 to '/ORADB/oradata/UAT/a_media04.dbf';

set newname for datafile 48 to '/ORADB/oradata/UAT/a_txn_ind10.dbf';

set newname for datafile 49 to '/ORADB/oradata/UAT/a_txn_data15.dbf';

set newname for datafile 50 to '/ORADB/oradata/UAT/a_txn_data16.dbf';

set newname for datafile 51 to '/ORADB/oradata/UAT/a_txn_ind11.dbf';

set newname for datafile 52 to '/ORADB/oradata/UAT/a_txn_ind12.dbf';

set newname for datafile 53 to '/ORADB/oradata/UAT/a_txn_ind13.dbf';

set newname for datafile 54 to '/ORADB/oradata/UAT/a_txn_ind14.dbf';

set newname for datafile 55 to '/ORADB/oradata/UAT/a_txn_ind15.dbf';

set newname for datafile 56 to '/ORADB/oradata/UAT/a_txn_ind16.dbf';

set newname for datafile 57 to '/ORADB/oradata/UAT/a_txn_ind17.dbf';

set newname for datafile 58 to '/ORADB/oradata/UAT/a_txn_ind18.dbf';

set newname for datafile 59 to '/ORADB/oradata/UAT/a_txn_ind19.dbf';

set newname for datafile 60 to '/ORADB/oradata/UAT/a_txn_ind20.dbf';

set newname for datafile 61 to '/ORADB/oradata/UAT/a_txn_ind21.dbf';

set newname for datafile 62 to '/ORADB/oradata/UAT/undo06.dbf';

set newname for datafile 63 to '/ORADB/oradata/UAT/a_txn_data17.dbf';

set newname for datafile 64 to '/ORADB/oradata/UAT/a_txn_ind22.dbf';

set newname for datafile 65 to '/ORADB/oradata/UAT/a_txn_data18.dbf';

set newname for datafile 66 to '/ORADB/oradata/UAT/a_txn_ind23.dbf';

set newname for datafile 67 to '/ORADB/oradata/UAT/a_txn_ind24.dbf';

set newname for datafile 68 to '/ORADB/oradata/UAT/a_txn_data19.dbf';

set newname for datafile 69 to '/ORADB/oradata/UAT/a_txn_ind25.dbf';

set newname for datafile 70 to '/ORADB/oradata/UAT/a_txn_ind26.dbf';

set newname for datafile 71 to '/ORADB/oradata/UAT/a_txn_data20.dbf';

set newname for datafile 72 to '/ORADB/oradata/UAT/a_txn_ind27.dbf';

set newname for datafile 73 to '/ORADB/oradata/UAT/a_txn_ind28.dbf';

set newname for datafile 74 to '/ORADB/oradata/UAT/a_txn_data21.dbf';

set newname for datafile 75 to '/ORADB/oradata/UAT/a_txn_ind29.dbf';

set newname for datafile 76 to '/ORADB/oradata/UAT/a_txn_ind30.dbf';

set newname for datafile 77 to '/ORADB/oradata/UAT/a_txn_ind31.dbf';

set newname for datafile 78 to '/ORADB/oradata/UAT/a_txn_data22.dbf';

set newname for datafile 79 to '/ORADB/oradata/UAT/a_txn_ind32.dbf';

set newname for datafile 80 to '/ORADB/oradata/UAT/a_txn_data23.dbf';

set newname for datafile 81 to '/ORADB/oradata/UAT/a_txn_ind33.dbf';

set newname for datafile 82 to '/ORADB/oradata/UAT/a_txn_ind34.dbf';

set newname for datafile 83 to '/ORADB/oradata/UAT/a_txn_data24.dbf';

set newname for datafile 84 to '/ORADB/oradata/UAT/a_txn_ind35.dbf';

set newname for datafile 85 to '/ORADB/oradata/UAT/a_txn_ind36.dbf';

set newname for datafile 86 to '/ORADB/oradata/UAT/a_txn_data25.dbf';

set newname for datafile 87 to '/ORADB/oradata/UAT/a_txn_ind37.dbf';

set newname for datafile 88 to '/ORADB/oradata/UAT/a_txn_data26.dbf';

set newname for datafile 89 to '/ORADB/oradata/UAT/a_txn_data27.dbf';

set newname for datafile 90 to '/ORADB/oradata/UAT/a_txn_ind38.dbf';

set newname for datafile 91 to '/ORADB/oradata/UAT/a_txn_ind39.dbf';

set newname for datafile 92 to '/ORADB/oradata/UAT/a_txn_data28.dbf';

set newname for datafile 93 to '/ORADB/oradata/UAT/a_txn_ind40.dbf';

set newname for datafile 94 to '/ORADB/oradata/UAT/a_txn_ind41.dbf';

set newname for datafile 95 to '/ORADB/oradata/UAT/a_txn_data29.dbf';

set newname for datafile 96 to '/ORADB/oradata/UAT/a_txn_ind42.dbf';

set newname for datafile 97 to '/ORADB/oradata/UAT/a_txn_ind43.dbf';

set newname for datafile 98 to '/ORADB/oradata/UAT/a_txn_data30.dbf';

set newname for datafile 99 to '/ORADB/oradata/UAT/a_txn_ind44.dbf';

set newname for datafile 100 to '/ORADB/oradata/UAT/a_media05.dbf';

set newname for datafile 101 to '/ORADB/oradata/UAT/a_txn_ind44.dbf;';

set newname for datafile 102 to '/ORADB/oradata/UAT/a_txn_data31.dbf';

set newname for datafile 103 to '/ORADB/oradata/UAT/a_txn_ind45.dbf';

set newname for datafile 105 to '/ORADB/oradata/UAT/a_txn_ind46.dbf';

set newname for datafile 106 to '/ORADB/oradata/UAT/a_media06.dbf';

set newname for datafile 109 to '/ORADB/oradata/UAT/a_txn_ind48.dbf';

set newname for datafile 110 to '/ORADB/oradata/UAT/a_txn_ind49.dbf';

set newname for datafile 113 to '/ORADB/oradata/UAT/a_txn_ind51.dbf';

set newname for datafile 114 to '/ORADB/oradata/UAT/a_txn_data35.dbf';

set newname for datafile 115 to '/ORADB/oradata/UAT/a_txn_ind52.dbf';

set newname for datafile 118 to '/ORADB/oradata/UAT/a_txn_ind54.dbf';

set newname for datafile 119 to '/ORADB/oradata/UAT/a_txn_data37.dbf';

set newname for datafile 122 to '/ORADB/oradata/UAT/a_txn_ind56.dbf';

set newname for datafile 123 to '/ORADB/oradata/UAT/a_txn_ind57.dbf';

set newname for datafile 126 to '/ORADB/oradata/UAT/a_txn_data40.dbf';

set newname for datafile 127 to '/ORADB/oradata/UAT/a_txn_ind59.dbf';

set newname for datafile 130 to '/ORADB/oradata/UAT/a_media07.dbf';

set newname for datafile 132 to '/ORADB/oradata/UAT/a_txn_data41.dbf';

set newname for datafile 133 to '/ORADB/oradata/UAT/a_txn_ind61.dbf';

set newname for datafile 136 to '/ORADB/oradata/UAT/a_txn_ind63.dbf';

set newname for datafile 137 to '/ORADB/oradata/UAT/a_txn_data42.dbf';

set newname for datafile 140 to '/ORADB/oradata/UAT/a_txn_ind87.dbf';

set newname for datafile 141 to '/ORADB/oradata/UAT/a_txn_ind189.dbf';

set newname for datafile 144 to '/ORADB/oradata/UAT/undo090.dbf';

set newname for datafile 145 to '/ORADB/oradata/UAT/undo091.dbf';

set newname for datafile 148 to '/ORADB/oradata/UAT/undo095.dbf';

set newname for datafile 149 to '/ORADB/oradata/UAT/undo096.dbf';

set newname for datafile 152 to '/ORADB/oradata/UAT/undo099.dbf';

set newname for datafile 153 to '/ORADB/oradata/UAT/undo0101.dbf';

set newname for datafile 156 to '/ORADB/oradata/UAT/undo104.dbf';

set newname for datafile 157 to '/ORADB/oradata/UAT/undo106.dbf';

set newname for datafile 158 to '/ORADB/oradata/UAT/undo118.dbf';

set newname for datafile 161 to '/ORADB/oradata/UAT/a_txn_ind109.dbf';

set newname for datafile 164 to '/ORADB/oradata/UAT/sysaux03.dbf';

set newname for datafile 167 to '/ORADB/oradata/UAT/a_int03.dbf';

set newname for datafile 168 to '/ORADB/oradata/UAT/users04.dbf';

set newname for datafile 171 to '/ORADB/oradata/UAT/a_ref04.dbf';

set newname for datafile 172 to '/ORADB/oradata/UAT/undo0111.dbf';

set newname for datafile 175 to '/ORADB/oradata/UAT/a_txn_data191.dbf';

set newname for datafile 176 to '/ORADB/oradata/UAT/a_txn_ind114.dbf';

set newname for datafile 177 to '/ORADB/oradata/UAT/undo0120.dbf';

set newname for datafile 180 to '/ORADB/oradata/UAT/undo123.dbf';

set newname for datafile 181 to '/ORADB/oradata/UAT/a_txn_ind111.dbf';

set newname for datafile 184 to '/ORADB/oradata/UAT/undo0124.dbf';

set newname for datafile 185 to '/ORADB/oradata/UAT/a_txn_data208.dbf';

set newname for datafile 188 to '/ORADB/oradata/UAT/undo0113.dbf';

set newname for datafile 189 to '/ORADB/oradata/UAT/a_txn_data209.dbf';

set newname for datafile 192 to '/ORADB/oradata/UAT/a_txn_data210.dbf';

set newname for datafile 194 to '/ORADB/oradata/UAT/undo0125.dbf';

set newname for datafile 196 to '/ORADB/oradata/UAT/undo0112.dbf';

set newname for datafile 198 to '/ORADB/oradata/UAT/a_txn_data211.dbf';

set newname for datafile 200 to '/ORADB/oradata/UAT/a_txn_data212.dbf';

set newname for datafile 202 to '/ORADB/oradata/UAT/undo0140.dbf';

set newname for datafile 203 to '/ORADB/oradata/UAT/a_txn_ind122.dbf';

set newname for datafile 206 to '/ORADB/oradata/UAT/a_txn_ind123.dbf';

set newname for datafile 207 to '/ORADB/oradata/UAT/a_txn_ind124.dbf';

set newname for datafile 210 to '/ORADB/oradata/UAT/a_txn_data215.dbf';

set newname for datafile 211 to '/ORADB/oradata/UAT/a_txn_ind126.dbf';

set newname for datafile 214 to '/ORADB/oradata/UAT/a_txn_ind128.dbf';

set newname for datafile 215 to '/ORADB/oradata/UAT/undo092.dbf';

set newname for datafile 218 to '/ORADB/oradata/UAT/undo100.dbf';

set newname for datafile 219 to '/ORADB/oradata/UAT/undo103.dbf';

set newname for datafile 221 to '/ORADB/oradata/UAT/undo121.dbf';

set newname for datafile 223 to '/ORADB/oradata/UAT/undo113.dbf';

set newname for datafile 225 to '/ORADB/oradata/UAT/undo115.dbf';

set newname for datafile 226 to '/ORADB/oradata/UAT/a_txn_ind064.dbf';

set newname for datafile 227 to '/ORADB/oradata/UAT/a_txn_ind065.dbf';

set newname for datafile 228 to '/ORADB/oradata/UAT/a_txn_data217.dbf';

set newname for datafile 229 to '/ORADB/oradata/UAT/a_txn_ind129.dbf';

set newname for datafile 230 to '/ORADB/oradata/UAT/undo127.dbf';

set newname for datafile 231 to '/ORADB/oradata/UAT/undo128.dbf';

set newname for datafile 232 to '/ORADB/oradata/UAT/a_txn_data218.dbf';

set newname for datafile 233 to '/ORADB/oradata/UAT/a_txn_ind130.dbf';

set newname for datafile 234 to '/ORADB/oradata/UAT/a_txn_ind131.dbf';

set newname for datafile 236 to '/ORADB/oradata/UAT/undo141.dbf';

set newname for datafile 237 to '/ORADB/oradata/UAT/undo142.dbf';

set newname for datafile 238 to '/ORADB/oradata/UAT/a_txn_data219.dbf';

set newname for datafile 239 to '/ORADB/oradata/UAT/a_txn_ind132.dbf';

set newname for datafile 240 to '/ORADB/oradata/UAT/a_txn_ind133.dbf';

set newname for datafile 241 to '/ORADB/oradata/UAT/a_txn_ind134.dbf';

set newname for datafile 242 to '/ORADB/oradata/UAT/a_txn_data220.dbf';

set newname for datafile 108 to '/ORADB/oradata/UAT/a_txn_data33.dbf';

set newname for datafile 112 to '/ORADB/oradata/UAT/a_txn_ind50.dbf';

set newname for datafile 116 to '/ORADB/oradata/UAT/a_txn_data36.dbf';

set newname for datafile 120 to '/ORADB/oradata/UAT/a_txn_ind55.dbf';

set newname for datafile 124 to '/ORADB/oradata/UAT/a_txn_data39.dbf';

set newname for datafile 128 to '/ORADB/oradata/UAT/undo07.dbf';

set newname for datafile 131 to '/ORADB/oradata/UAT/a_txn_ind60.dbf';

set newname for datafile 135 to '/ORADB/oradata/UAT/a_txn_ind62.dbf';

set newname for datafile 139 to '/ORADB/oradata/UAT/apps_ro_data01.dbf';

set newname for datafile 143 to '/ORADB/oradata/UAT/undo089.dbf';

set newname for datafile 147 to '/ORADB/oradata/UAT/a_txn_ind093.dbf';

set newname for datafile 151 to '/ORADB/oradata/UAT/a_txn_data192.dbf';

set newname for datafile 155 to '/ORADB/oradata/UAT/a_txn_ind95.dbf';

set newname for datafile 159 to '/ORADB/oradata/UAT/a_txn_ind0102.dbf';

set newname for datafile 162 to '/ORADB/oradata/UAT/undo109.dbf';

set newname for datafile 166 to '/ORADB/oradata/UAT/a_archive03.dbf';

set newname for datafile 170 to '/ORADB/oradata/UAT/a_queue03.dbf';

set newname for datafile 174 to '/ORADB/oradata/UAT/a_txn_ind113.dbf';

set newname for datafile 178 to '/ORADB/oradata/UAT/undo0121.dbf';

set newname for datafile 182 to '/ORADB/oradata/UAT/a_txn_data201.dbf';

set newname for datafile 186 to '/ORADB/oradata/UAT/a_txn_ind101.dbf';

set newname for datafile 190 to '/ORADB/oradata/UAT/a_txn_ind116.dbf';

set newname for datafile 193 to '/ORADB/oradata/UAT/a_txn_ind118.dbf';

set newname for datafile 197 to '/ORADB/oradata/UAT/a_txn_ind119.dbf';

set newname for datafile 201 to '/ORADB/oradata/UAT/a_txn_ind121.dbf';

set newname for datafile 205 to '/ORADB/oradata/UAT/a_media090.dbf';

set newname for datafile 209 to '/ORADB/oradata/UAT/a_txn_ind125.dbf';

set newname for datafile 213 to '/ORADB/oradata/UAT/a_txn_data216.dbf';

set newname for datafile 217 to '/ORADB/oradata/UAT/undo098.dbf';

set newname for datafile 220 to '/ORADB/oradata/UAT/undo107.dbf';

set newname for datafile 224 to '/ORADB/oradata/UAT/undo114.dbf';

set newname for datafile 314 to '/ORADB/oradata/UAT/portal01.dbf';

set newname for datafile 379 to '/ORADB/oradata/UAT/undo01.dbf';

set newname for datafile 392 to '/ORADB/oradata/UAT/a_txn_data01.dbf';

set newname for datafile 393 to '/ORADB/oradata/UAT/a_txn_ind01.dbf';

set newname for datafile 394 to '/ORADB/oradata/UAT/a_ref01.dbf';

set newname for datafile 395 to '/ORADB/oradata/UAT/a_int01.dbf';

set newname for datafile 396 to '/ORADB/oradata/UAT/a_summ01.dbf';

set newname for datafile 397 to '/ORADB/oradata/UAT/a_nolog01.dbf';

set newname for datafile 398 to '/ORADB/oradata/UAT/a_archive01.dbf';

set newname for datafile 399 to '/ORADB/oradata/UAT/a_queue01.dbf';

set newname for datafile 400 to '/ORADB/oradata/UAT/a_media01.dbf';

set newname for datafile 401 to '/ORADB/oradata/UAT/a_txn_data02.dbf';

set newname for datafile 402 to '/ORADB/oradata/UAT/a_txn_data03.dbf';

set newname for datafile 403 to '/ORADB/oradata/UAT/a_txn_ind02.dbf';

set newname for datafile 404 to '/ORADB/oradata/UAT/a_txn_ind03.dbf';

set newname for datafile 405 to '/ORADB/oradata/UAT/a_txn_ind04.dbf';

set newname for datafile 406 to '/ORADB/oradata/UAT/a_txn_ind05.dbf';

set newname for datafile 407 to '/ORADB/oradata/UAT/a_ref02.dbf';

set newname for datafile 104 to '/ORADB/oradata/UAT/a_txn_data32.dbf';

set newname for datafile 107 to '/ORADB/oradata/UAT/a_txn_ind47.dbf';

set newname for datafile 111 to '/ORADB/oradata/UAT/a_txn_data34.dbf';

set newname for datafile 117 to '/ORADB/oradata/UAT/a_txn_ind53.dbf';

set newname for datafile 121 to '/ORADB/oradata/UAT/a_txn_data38.dbf';

set newname for datafile 125 to '/ORADB/oradata/UAT/a_txn_ind58.dbf';

set newname for datafile 129 to '/ORADB/oradata/UAT/undo08.dbf';

set newname for datafile 134 to '/ORADB/oradata/UAT/undo09.dbf';

set newname for datafile 138 to '/ORADB/oradata/UAT/a_txn_data43.dbf';

set newname for datafile 142 to '/ORADB/oradata/UAT/a_media088.dbf';

set newname for datafile 146 to '/ORADB/oradata/UAT/undo093.dbf';

set newname for datafile 150 to '/ORADB/oradata/UAT/undo097.dbf';

set newname for datafile 154 to '/ORADB/oradata/UAT/undo102.dbf';

set newname for datafile 160 to '/ORADB/oradata/UAT/a_txn_data107.dbf';

set newname for datafile 165 to '/ORADB/oradata/UAT/a_media08.dbf';

set newname for datafile 169 to '/ORADB/oradata/UAT/a_summ04.dbf';

set newname for datafile 173 to '/ORADB/oradata/UAT/a_txn_ind112.dbf';

set newname for datafile 179 to '/ORADB/oradata/UAT/undo0122.dbf';

set newname for datafile 183 to '/ORADB/oradata/UAT/a_txn_ind115.dbf';

set newname for datafile 187 to '/ORADB/oradata/UAT/a_txn_data118.dbf';

set newname for datafile 191 to '/ORADB/oradata/UAT/a_txn_ind117.dbf';

set newname for datafile 195 to '/ORADB/oradata/UAT/undo0126.dbf';

set newname for datafile 199 to '/ORADB/oradata/UAT/a_txn_ind120.dbf';

set newname for datafile 204 to '/ORADB/oradata/UAT/a_txn_data213.dbf';

set newname for datafile 208 to '/ORADB/oradata/UAT/a_txn_data214.dbf';

set newname for datafile 212 to '/ORADB/oradata/UAT/a_txn_ind127.dbf';

set newname for datafile 216 to '/ORADB/oradata/UAT/undo094.dbf';

set newname for datafile 222 to '/ORADB/oradata/UAT/undo122.dbf';

restore database;

switch datafile all;

}