Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Restoring To the DR Server

NewmanJun 3 2008 — edited Jun 3 2008
Dear Friends and Co-DBA's

I have this script that i want to run to restore my database to the DR server.
but I have doubts if is going to work well.
The Environment is like this:
The Production server and the DR server.The DR server is the rman database of the production server.My Production database had disk failure few day ago and we could not be able to restore it back from the DR server.So we had to fall back on our last full backup which took place a night before the failure.thereby making us to loose all data that was inputed after the backup.
Now the production server is up,but we want to restore the production server to the DR server.

check the script and let me have your inputs.
The script is as follows:


connect catalog rman/rman@rman.world
set DBID=xxxxxxxxxx
connect target
shutdown immediate;
startup force nomount;



run
{

allocate channel p1 type 'SBT_TAPE' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';

restore controlfile;
release channel p1;

allocate channel p1 type 'SBT_TAPE' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';

allocate channel p2 type 'SBT_TAPE' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';

allocate channel p3 type 'SBT_TAPE' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';




SET NEWNAME FOR DATAFILE 1 TO '/drdata01/mlprod/test.dbf ';
SET NEWNAME FOR DATAFILE 2 TO '/drdata04/mlprod/undo02.dbf ';
SET NEWNAME FOR DATAFILE 3 TO '/drdata01/mlprod/test01.dbf ';
SET NEWNAME FOR DATAFILE 4 TO '/drdata01/mlprod/rman1.dbf ';
SET NEWNAME FOR DATAFILE 5 TO '/drdata01/mlprod/tsm01.dbf ';
SET NEWNAME FOR DATAFILE 6 TO '/drdata01/mlprod/xdb.dbf ';
SET NEWNAME FOR DATAFILE 7 TO '/drdata03/mlprod/users01.dbf ';
SET NEWNAME FOR DATAFILE 8 TO '/drdata02/mlprod/tabno_analyze_01.dbf';
SET NEWNAME FOR DATAFILE 9 TO '/drdata03/mlprod/odm01.dbf ';
SET NEWNAME FOR DATAFILE 10 TO '/drdata02/mlprod/ind_usage06_01.dbf ';
SET NEWNAME FOR DATAFILE 11 TO '/drdata02/mlprod/ind_usage06_02.dbf ';
SET NEWNAME FOR DATAFILE 12 TO '/drdata02/mlprod/ind_usage05_01.dbf ';
SET NEWNAME FOR DATAFILE 13 TO '/drdata02/mlprod/ind_usage05_02.dbf ';
SET NEWNAME FOR DATAFILE 14 TO '/drdata02/mlprod/ind_usage04_01.dbf ';
SET NEWNAME FOR DATAFILE 15 TO '/drdata02/mlprod/ind_usage04_02.dbf ';
SET NEWNAME FOR DATAFILE 16 TO '/drdata02/mlprod/ind_usage04_03.dbf ';
SET NEWNAME FOR DATAFILE 17 TO '/drdata02/mlprod/ind_usage03_01.dbf ';
SET NEWNAME FOR DATAFILE 18 TO '/drdata02/mlprod/ind_usage03_02.dbf ';
SET NEWNAME FOR DATAFILE 19 TO '/drdata02/mlprod/ind_usage03_03.dbf ';
SET NEWNAME FOR DATAFILE 20 TO '/drdata02/mlprod/ind_usage02_01.dbf ';
SET NEWNAME FOR DATAFILE 21 TO '/drdata02/mlprod/ind_usage02_02.dbf ';
SET NEWNAME FOR DATAFILE 22 TO '/drdata02/mlprod/ind_usage02_03.dbf ';
SET NEWNAME FOR DATAFILE 23 TO '/drdata02/mlprod/ind_usage01_01.dbf ';
SET NEWNAME FOR DATAFILE 24 TO '/drdata02/mlprod/ind_usage01_02.dbf ';
SET NEWNAME FOR DATAFILE 25 TO '/drdata02/mlprod/ind_usage01_03.dbf ';
SET NEWNAME FOR DATAFILE 26 TO '/drdata02/mlprod/ind_rating_02.dbf ';
SET NEWNAME FOR DATAFILE 27 TO '/drdata02/mlprod/ind_rating_01.dbf ';
SET NEWNAME FOR DATAFILE 28 TO '/drdata02/mlprod/ind_mediation_02.dbf';
SET NEWNAME FOR DATAFILE 29 TO '/drdata02/mlprod/ind_mediation_01.dbf';
SET NEWNAME FOR DATAFILE 30 TO '/drdata01/mlprod/ind_general_04.dbf ';
SET NEWNAME FOR DATAFILE 31 TO '/drdata01/mlprod/ind_general_03.dbf ';
SET NEWNAME FOR DATAFILE 32 TO '/drdata01/mlprod/ind_general_02.dbf ';
SET NEWNAME FOR DATAFILE 33 TO '/drdata01/mlprod/ind_general_01.dbf ';
SET NEWNAME FOR DATAFILE 34 TO '/drdata03/mlprod/indx01.dbf ';
SET NEWNAME FOR DATAFILE 35 TO '/drdata03/mlprod/example01.dbf ';
SET NEWNAME FOR DATAFILE 36 TO '/drdata03/mlprod/drsys01.dbf ';
SET NEWNAME FOR DATAFILE 37 TO '/drdata02/mlprod/df_index_01.dbf ';
SET NEWNAME FOR DATAFILE 38 TO '/drdata01/mlprod/df_data_01.dbf ';
SET NEWNAME FOR DATAFILE 39 TO '/drdata02/mlprod/da_usage06_01.dbf ';
SET NEWNAME FOR DATAFILE 40 TO '/drdata04/mlprod/da_usage06_02.dbf ';
SET NEWNAME FOR DATAFILE 41 TO '/drdata02/mlprod/da_usage05_01.dbf ';
SET NEWNAME FOR DATAFILE 42 TO '/drdata04/mlprod/da_usage05_02.dbf ';
SET NEWNAME FOR DATAFILE 43 TO '/drdata04/mlprod/da_usage05_03.dbf ';
SET NEWNAME FOR DATAFILE 44 TO '/drdata04/mlprod/da_usage04_04.dbf ';
SET NEWNAME FOR DATAFILE 45 TO '/drdata04/mlprod/da_usage04_03.dbf ';
SET NEWNAME FOR DATAFILE 46 TO '/drdata02/mlprod/da_usage04_02.dbf ';
SET NEWNAME FOR DATAFILE 47 TO '/drdata02/mlprod/da_usage04_01.dbf ';
SET NEWNAME FOR DATAFILE 48 TO '/drdata04/mlprod/da_usage03_02.dbf ';
SET NEWNAME FOR DATAFILE 49 TO '/drdata01/mlprod/da_usage03_01.dbf ';
SET NEWNAME FOR DATAFILE 50 TO '/drdata01/mlprod/da_usage03_03.dbf ';
SET NEWNAME FOR DATAFILE 51 TO '/drdata04/mlprod/da_usage03_03.dbf ';
SET NEWNAME FOR DATAFILE 52 TO '/drdata04/mlprod/da_usage02_02.dbf ';
SET NEWNAME FOR DATAFILE 53 TO '/drdata01/mlprod/da_usage02_01.dbf ';
SET NEWNAME FOR DATAFILE 54 TO '/drdata01/mlprod/da_usage02_03.dbf ';
SET NEWNAME FOR DATAFILE 55 TO '/drdata04/mlprod/da_usage02_04.dbf ';
SET NEWNAME FOR DATAFILE 56 TO '/drdata01/mlprod/da_usage01_01.dbf ';
SET NEWNAME FOR DATAFILE 57 TO '/drdata04/mlprod/da_usage01_02.dbf ';
SET NEWNAME FOR DATAFILE 58 TO '/drdata04/mlprod/da_usage01_03.dbf ';
SET NEWNAME FOR DATAFILE 59 TO '/drdata01/mlprod/da_usage01_04.dbf ';
SET NEWNAME FOR DATAFILE 60 TO '/drdata03/mlprod/da_usage01_05.dbf ';
SET NEWNAME FOR DATAFILE 61 TO '/drdata02/mlprod/da_rating_04.dbf ';
SET NEWNAME FOR DATAFILE 62 TO '/drdata02/mlprod/da_rating_03.dbf ';
SET NEWNAME FOR DATAFILE 63 TO '/drdata02/mlprod/da_rating_02.dbf ';
SET NEWNAME FOR DATAFILE 64 TO '/drdata03/mlprod/da_rating_01.dbf ';
SET NEWNAME FOR DATAFILE 65 TO '/drdata03/mlprod/da_rating_05.dbf ';
SET NEWNAME FOR DATAFILE 66 TO '/drdata03/mlprod/da_rating_06.dbf ';
SET NEWNAME FOR DATAFILE 67 TO '/drdata03/mlprod/da_mediation_03.dbf ';
SET NEWNAME FOR DATAFILE 68 TO '/drdata03/mlprod/da_mediation_02.dbf ';
SET NEWNAME FOR DATAFILE 69 TO '/drdata03/mlprod/da_mediation_01.dbf ';
SET NEWNAME FOR DATAFILE 70 TO '/drdata04/mlprod/da_mediation_04.dbf ';
SET NEWNAME FOR DATAFILE 71 TO '/drdata04/mlprod/da_mediation_05.dbf ';
SET NEWNAME FOR DATAFILE 72 TO '/drdata04/mlprod/da_mediation_06.dbf ';
SET NEWNAME FOR DATAFILE 73 TO '/drdata04/mlprod/da_mediation_07.dbf ';
SET NEWNAME FOR DATAFILE 74 TO '/drdata01/mlprod/DA_LOB_01.dbf ';
SET NEWNAME FOR DATAFILE 75 TO '/drdata03/mlprod/da_general_10.dbf ';
SET NEWNAME FOR DATAFILE 76 TO '/drdata03/mlprod/da_general_09.dbf ';
SET NEWNAME FOR DATAFILE 77 TO '/drdata03/mlprod/da_general_08.dbf ';
SET NEWNAME FOR DATAFILE 78 TO '/drdata03/mlprod/da_general_07.dbf ';
SET NEWNAME FOR DATAFILE 79 TO '/drdata03/mlprod/da_general_06.dbf ';
SET NEWNAME FOR DATAFILE 80 TO '/drdata03/mlprod/da_general_05.dbf ';
SET NEWNAME FOR DATAFILE 81 TO '/drdata03/mlprod/da_general_04.dbf ';
SET NEWNAME FOR DATAFILE 82 TO '/drdata03/mlprod/da_general_03.dbf ';
SET NEWNAME FOR DATAFILE 83 TO '/drdata03/mlprod/da_general_02.dbf ';
SET NEWNAME FOR DATAFILE 84 TO '/drdata03/mlprod/da_general_01.dbf ';
SET NEWNAME FOR DATAFILE 85 TO '/drdata01/mlprod/da_general_11.dbf ';
SET NEWNAME FOR DATAFILE 86 TO '/drdata02/mlprod/da_general_12.dbf ';
SET NEWNAME FOR DATAFILE 87 TO '/drdata02/mlprod/da_fits_01.dbf ';
SET NEWNAME FOR DATAFILE 88 TO '/drdata03/mlprod/cwmlite01.dbf ';
SET NEWNAME FOR DATAFILE 89 TO '/drdata03/mlprod/tools01.dbf ';
SET NEWNAME FOR DATAFILE 90 TO '/drdata04/mlprod/da_usage06_03.dbf ';
SET NEWNAME FOR DATAFILE 91 TO '/drdata04/mlprod/da_usage02_05.dbf ';
SET NEWNAME FOR DATAFILE 92 TO '/drdata03/mlprod/da_general_11.dbf ';
SET NEWNAME FOR DATAFILE 93 TO '/drdata02/mlprod/ind_usage06_03.dbf ';
SET NEWNAME FOR DATAFILE 94 TO '/drdata02/mlprod/ind_usage06_04.dbf ';
SET NEWNAME FOR DATAFILE 95 TO '/drdata01/mlprod/da_usage01_06.dbf ';
SET NEWNAME FOR DATAFILE 96 TO '/drdata04/mlprod/da_usage02_06.dbf ';
SET NEWNAME FOR DATAFILE 97 TO '/drdata02/mlprod/da_usage05_04.dbf ';
SET NEWNAME FOR DATAFILE 98 TO '/drdata04/mlprod/da_usage03_05.dbf ';
SET NEWNAME FOR DATAFILE 99 TO '/drdata02/mlprod/da_usage04_05.dbf ';
SET NEWNAME FOR DATAFILE 100 TO '/drdata02/mlprod/da_usage06_04.dbf ';
SET NEWNAME FOR DATAFILE 101 TO '/drdata02/mlprod/ind_usage01_04.dbf ';
SET NEWNAME FOR DATAFILE 102 TO '/drdata04/mlprod/da_usage01_07.dbf ';
SET NEWNAME FOR DATAFILE 103 TO '/drdata04/mlprod/ind_usage01_04.dbf ';
SET NEWNAME FOR DATAFILE 104 TO '/drdata04/mlprod/da_usage03_06.dbf ';
SET NEWNAME FOR DATAFILE 105 TO '/drdata04/mlprod/da_usage05_05.dbf ';
SET NEWNAME FOR DATAFILE 106 TO '/drdata02/mlprod/ind_usage03_04.dbf ';
SET NEWNAME FOR DATAFILE 107 TO '/drdata02/mlprod/ind_usage05_03.dbf ';
SET NEWNAME FOR DATAFILE 108 TO '/drdata02/mlprod/ind_usage06_05.dbf ';
SET NEWNAME FOR DATAFILE 109 TO '/drdata04/mlprod/da_usage04_05 ';
SET NEWNAME FOR DATAFILE 110 TO '/drdata04/mlprod/da_usage04_06 ';
SET NEWNAME FOR DATAFILE 111 TO '/drdata04/mlprod/da_usage05_06 ';
SET NEWNAME FOR DATAFILE 112 TO '/drdata04/mlprod/da_usage05_07 ';
SET NEWNAME FOR DATAFILE 113 TO '/drdata04/mlprod/da_usage06_04 ';
SET NEWNAME FOR DATAFILE 114 TO '/drdata03/mlprod/ind_usage06_06 ';
SET NEWNAME FOR DATAFILE 115 TO '/drdata03/mlprod/ind_usage05_04 ';
SET NEWNAME FOR DATAFILE 116 TO '/drdata04/mlprod/da_usage06_05 ';
SET NEWNAME FOR DATAFILE 117 TO '/drdata04/mlprod/ind_usage01_05 ';
SET NEWNAME FOR DATAFILE 118 TO '/drdata03/mlprod/ind_usage06_07 ';
SET NEWNAME FOR DATAFILE 119 TO '/drdata04/mlprod/da_usage01_08 ';
SET NEWNAME FOR DATAFILE 120 TO '/drdata04/mlprod/da_usage06_06 ';
SET NEWNAME FOR DATAFILE 121 TO '/drdata04/mlprod/da_usage01_09 ';
SET NEWNAME FOR DATAFILE 122 TO '/drdata04/mlprod/da_usage02_07.dbf ';
SET NEWNAME FOR DATAFILE 123 TO '/drdata02/mlprod/ind_usage02_04.dbf ';
SET NEWNAME FOR DATAFILE 124 TO '/drdata04/mlprod/da_usage02_10.dbf ';
SET NEWNAME FOR DATAFILE 125 TO '/drdata04/mlprod/ind_usage_06.dbf ';
SET NEWNAME FOR DATAFILE 126 TO '/drdata02/mlprod/ind_mediation_03.dbf';
SET NEWNAME FOR DATAFILE 127 TO '/drdata03/mlprod/ind_usage06_08.dbf ';
SET NEWNAME FOR DATAFILE 128 TO '/drdata04/mlprod/da_usage02_08.dbf ';
SET NEWNAME FOR DATAFILE 129 TO '/drdata01/mlprod/ind_usage02_05.dbf ';
SET NEWNAME FOR DATAFILE 130 TO '/drdata02/mlprod/ind_mediation_04.dbf';
SET NEWNAME FOR DATAFILE 131 TO '/drdata03/mlprod/ind_usage06_09.dbf ';
SET NEWNAME FOR DATAFILE 132 TO '/drdata01/mlprod/ind_usage_06_07.dbf ';
SET NEWNAME FOR DATAFILE 133 TO '/drdata03/mlprod/da_usage02_09 ';
SET NEWNAME FOR DATAFILE 134 TO '/drdata01/mlprod/da_usage03_07 ';
SET NEWNAME FOR DATAFILE 135 TO '/drdata03/mlprod/da_general_12 ';
SET NEWNAME FOR DATAFILE 136 TO '/drdata01/mlprod/da_usage03_08 ';
SET NEWNAME FOR DATAFILE 137 TO '/drdata01/mlprod/da_general_13 ';
SET NEWNAME FOR DATAFILE 138 TO '/drdata01/mlprod/da_usage_10 ';
SET NEWNAME FOR DATAFILE 139 TO '/drdata01/mlprod/da_general_14 ';
SET NEWNAME FOR DATAFILE 140 TO '/drdata01/mlprod/da_usage03_09 ';
SET NEWNAME FOR DATAFILE 141 TO '/drdata01/mlprod/da_general_15 ';
SET NEWNAME FOR DATAFILE 142 TO '/drdata01/mlprod/da_usage03_10 ';
SET NEWNAME FOR DATAFILE 143 TO '/drdata04/mlprod/da_usage04_07 ';
SET NEWNAME FOR DATAFILE 144 TO '/drdata01/mlprod/da_usage04_08 ';
SET NEWNAME FOR DATAFILE 145 TO '/drdata01/mlprod/ind_usage04_04 ';
SET NEWNAME FOR DATAFILE 146 TO '/drdata01/mlprod/da_general_16 ';
SET NEWNAME FOR DATAFILE 147 TO '/drdata01/mlprod/ind_general_05 ';
SET NEWNAME FOR DATAFILE 148 TO '/drdata03/mlprod/ind_usage06_10 ';
SET NEWNAME FOR DATAFILE 149 TO '/drdata01/mlprod/da_usage05_08 ';
SET NEWNAME FOR DATAFILE 150 TO '/drdata01/mlprod/da_usage04_09 ';
SET NEWNAME FOR DATAFILE 151 TO '/drdata01/mlprod/da_usage05_09 ';
SET NEWNAME FOR DATAFILE 152 TO '/drdata01/mlprod/da_usage05_10 ';
SET NEWNAME FOR DATAFILE 153 TO '/drdata01/mlprod/da_usage05_11 ';
SET NEWNAME FOR DATAFILE 154 TO '/drdata03/mlprod/ind_usage05_05 ';
SET NEWNAME FOR DATAFILE 155 TO '/drdata01/mlprod/ind_usage01_08 ';
SET NEWNAME FOR DATAFILE 156 TO '/drdata01/mlprod/da_usage05_12 ';
SET NEWNAME FOR DATAFILE 157 TO '/drdata03/mlprod/da_usage06_07 ';
SET NEWNAME FOR DATAFILE 158 TO '/drdata02/mlprod/ind_usage06_11 ';
SET NEWNAME FOR DATAFILE 159 TO '/drdata03/mlprod/da_usage06_08 ';
SET NEWNAME FOR DATAFILE 160 TO '/drdata03/mlprod/ind_usage06_12 ';
SET NEWNAME FOR DATAFILE 161 TO '/drdata01/mlprod/da_usage01_11 ';
SET NEWNAME FOR DATAFILE 162 TO '/drdata01/mlprod/ind_usage01_09 ';
SET NEWNAME FOR DATAFILE 163 TO '/drdata03/mlprod/da_general_17 ';
SET NEWNAME FOR DATAFILE 164 TO '/drdata01/mlprod/ind_usage_13 ';
SET NEWNAME FOR DATAFILE 165 TO '/drdata01/mlprod/ind_mediation_05 ';
SET NEWNAME FOR DATAFILE 166 TO '/drdata03/mlprod/da_usage03_12 ';
SET NEWNAME FOR DATAFILE 167 TO '/drdata01/mlprod/da_mediation_08 ';
SET NEWNAME FOR DATAFILE 168 TO '/drdata03/mlprod/da_general_18 ';
SET NEWNAME FOR DATAFILE 169 TO '/drdata03/mlprod/da_usage_09 ';
SET NEWNAME FOR DATAFILE 170 TO '/drdata01/mlprod/da_usage06_10 ';
SET NEWNAME FOR DATAFILE 171 TO '/drdata03/mlprod/da_usage06_09 ';
SET NEWNAME FOR DATAFILE 172 TO '/drdata03/mlprod/da_usage01_13 ';
SET NEWNAME FOR DATAFILE 173 TO '/drdata01/mlprod/ind_usage01_10 ';
SET NEWNAME FOR DATAFILE 174 TO '/drdata03/mlprod/ind_usage06_13 ';
SET NEWNAME FOR DATAFILE 175 TO '/drdata03/mlprod/da_usage_14 ';
SET NEWNAME FOR DATAFILE 176 TO '/drdata02/mlprod/da_usage01_15 ';
SET NEWNAME FOR DATAFILE 177 TO '/drdata02/mlprod/ind_general_06 ';
SET NEWNAME FOR DATAFILE 178 TO '/drdata02/mlprod/da_usage02_11 ';
SET NEWNAME FOR DATAFILE 179 TO '/drdata06/mlprod/da_usage02_09 ';
SET NEWNAME FOR DATAFILE 180 TO '/drdata06/mlprod/ind_usage01 ';
SET NEWNAME FOR DATAFILE 181 TO '/drdata06/mlprod/da_usage01 ';
SET NEWNAME FOR DATAFILE 182 TO '/drdata06/mlprod/da_general_19 ';
SET NEWNAME FOR DATAFILE 183 TO '/drdata06/mlprod/ind_usage06_14 ';
SET NEWNAME FOR DATAFILE 184 TO '/drdata06/mlprod/da_usage03_11 ';
SET NEWNAME FOR DATAFILE 185 TO '/drdata06/mlprod/ind_usage03 ';
SET NEWNAME FOR DATAFILE 186 TO '/drdata06/mlprod/ind_usage02_05 ';
SET NEWNAME FOR DATAFILE 187 TO '/drdata06/mlprod/da_usage02_12 ';
SET NEWNAME FOR DATAFILE 188 TO '/drdata06/mlprod/ind_mediation_06 ';
SET NEWNAME FOR DATAFILE 189 TO '/drdata06/mlprod/da_mediation_09 ';
SET NEWNAME FOR DATAFILE 190 TO '/drdata06/mlprod/da_general_20 ';
SET NEWNAME FOR DATAFILE 191 TO '/drdata06/mlprod/ind_general_07 ';
SET NEWNAME FOR DATAFILE 192 TO '/drdata06/mlprod/da_usage01_16 ';
SET NEWNAME FOR DATAFILE 193 TO '/drdata06/mlprod/da_usage02_13 ';
SET NEWNAME FOR DATAFILE 194 TO '/drdata06/mlprod/DA_LOB_02 ';
SET NEWNAME FOR DATAFILE 195 TO '/drdata06/mlprod/system_01 ';
SET NEWNAME FOR DATAFILE 196 TO '/drdata06/mlprod/ind_usage01_11 ';
SET NEWNAME FOR DATAFILE 197 TO '/drdata06/mlprod/da_usage02_14 ';
SET NEWNAME FOR DATAFILE 198 TO '/drdata06/mlprod/da_usage04_10 ';
SET NEWNAME FOR DATAFILE 199 TO '/drdata06/mlprod/ind_usage04_05 ';
SET NEWNAME FOR DATAFILE 200 TO '/drdata06/mlprod/da_general_21 ';
SET NEWNAME FOR DATAFILE 201 TO '/drdata06/mlprod/da_usage03_12 ';
SET NEWNAME FOR DATAFILE 202 TO '/drdata06/mlprod/da_usage05_13 ';
SET NEWNAME FOR DATAFILE 203 TO '/drdata08/mlprod/da_usage04_11 ';
SET NEWNAME FOR DATAFILE 204 TO '/drdata06/mlprod/ind_usage05_06 ';
SET NEWNAME FOR DATAFILE 205 TO '/drdata08/mlprod/ind_usage04_06 ';
SET NEWNAME FOR DATAFILE 206 TO '/drdata08/mlprod/da_general_22 ';
SET NEWNAME FOR DATAFILE 207 TO '/drdata08/mlprod/da_rating_07 ';
SET NEWNAME FOR DATAFILE 208 TO '/drdata08/mlprod/da_fits_02.dbf ';
SET NEWNAME FOR DATAFILE 209 TO '/drdata08/mlprod/da_usage05_14 ';
SET NEWNAME FOR DATAFILE 210 TO '/drdata08/mlprod/ind_usage06_15 ';
SET NEWNAME FOR DATAFILE 211 TO '/drdata08/mlprod/ind_usage01_12 ';
SET NEWNAME FOR DATAFILE 212 TO '/drdata08/mlprod/da_usage04_12 ';
SET NEWNAME FOR DATAFILE 213 TO '/drdata08/mlprod/ind_usage05_07 ';
SET NEWNAME FOR DATAFILE 214 TO '/drdata06/mlprod/ind_general_08 ';
SET NEWNAME FOR DATAFILE 215 TO '/drdata06/mlprod/da_usage06_11 ';
SET NEWNAME FOR DATAFILE 216 TO '/drdata08/mlprod/da_general_23 ';
SET NEWNAME FOR DATAFILE 217 TO '/drdata08/mlprod/da_usage05_15 ';
SET NEWNAME FOR DATAFILE 218 TO '/drdata08/mlprod/ind_general_09 ';
SET NEWNAME FOR DATAFILE 219 TO '/drdata08/mlprod/ind_mediation_07 ';
SET NEWNAME FOR DATAFILE 220 TO '/drdata08/mlprod/da_usage05_16 ';
SET NEWNAME FOR DATAFILE 221 TO '/drdata08/mlprod/ind_usage06_16 ';
SET NEWNAME FOR DATAFILE 222 TO '/drdata08/mlprod/da_usage06_12 ';
SET NEWNAME FOR DATAFILE 223 TO '/drdata08/mlprod/da_general_24 ';
SET NEWNAME FOR DATAFILE 224 TO '/drdata08/mlprod/ind_usage05_08 ';
SET NEWNAME FOR DATAFILE 225 TO '/drdata07/mlprod/da_general_25 ';
SET NEWNAME FOR DATAFILE 226 TO '/drdata07/mlprod/ind_general_10 ';
SET NEWNAME FOR DATAFILE 227 TO '/drdata07/mlprod/da_usage06_13 ';
SET NEWNAME FOR DATAFILE 228 TO '/drdata07/mlprod/ind_usage06_17 ';
SET NEWNAME FOR DATAFILE 229 TO '/drdata07/mlprod/tabno_analyze_02.dbf';
SET NEWNAME FOR DATAFILE 230 TO '/drdata08/mlprod/da_mediation_10 ';
SET NEWNAME FOR DATAFILE 231 TO '/drdata08/mlprod/da_rating_08 ';
SET NEWNAME FOR DATAFILE 232 TO '/drdata08/mlprod/da_mediation_11 ';
SET NEWNAME FOR DATAFILE 233 TO '/drdata07/mlprod/da_usage01_17 ';
SET NEWNAME FOR DATAFILE 234 TO '/drdata07/mlprod/ind_usage06_18 ';
SET NEWNAME FOR DATAFILE 235 TO '/drdata07/mlprod/da_usage05_17 ';
SET NEWNAME FOR DATAFILE 236 TO '/drdata07/mlprod/ind_usage01_13 ';
SET NEWNAME FOR DATAFILE 237 TO '/drdata07/mlprod/da_rating_09 ';
SET NEWNAME FOR DATAFILE 238 TO '/drdata07/mlprod/da_rating_10 ';
SET NEWNAME FOR DATAFILE 239 TO '/drdata07/mlprod/da_rating_11 ';
SET NEWNAME FOR DATAFILE 240 TO '/drdata06/mlprod/system_02 ';
SET NEWNAME FOR DATAFILE 241 TO '/drdata07/mlprod/da_rating_12 ';
SET NEWNAME FOR DATAFILE 242 TO '/drdata08/mlprod/da_rating_13 ';
SET NEWNAME FOR DATAFILE 243 TO '/drdata08/mlprod/system_03 ';
SET NEWNAME FOR DATAFILE 244 TO '/drdata07/mlprod/da_rating_14 ';
SET NEWNAME FOR DATAFILE 245 TO '/drdata07/mlprod/ind_usage02_06.dbf ';
SET NEWNAME FOR DATAFILE 246 TO '/drdata07/mlprod/da_usage06_14 ';
SET NEWNAME FOR DATAFILE 247 TO '/drdata07/mlprod/da_usage01_18 ';
SET NEWNAME FOR DATAFILE 248 TO '/drdata06/mlprod/da_usage02_15 ';
SET NEWNAME FOR DATAFILE 249 TO '/drdata07/mlprod/da_general_26 ';
SET NEWNAME FOR DATAFILE 250 TO '/drdata07/mlprod/da_usage05_18 ';
SET NEWNAME FOR DATAFILE 251 TO '/drdata07/mlprod/ind_usage01_14 ';
SET NEWNAME FOR DATAFILE 252 TO '/drdata07/mlprod/da_usage02_16 ';
SET NEWNAME FOR DATAFILE 253 TO '/drdata07/mlprod/da_general_27 ';
SET NEWNAME FOR DATAFILE 254 TO '/drdata07/mlprod/da_usage01_19 ';
SET NEWNAME FOR DATAFILE 255 TO '/drdata07/mlprod/da_general_28 ';
SET NEWNAME FOR DATAFILE 256 TO '/drdata07/mlprod/ind_general_11 ';
SET NEWNAME FOR DATAFILE 257 TO '/drdata07/mlprod/da_usage06_15 ';
SET NEWNAME FOR DATAFILE 258 TO '/drdata07/mlprod/da_usage02_17 ';
SET NEWNAME FOR DATAFILE 259 TO '/drdata07/mlprod/ind_usage02_07.dbf ';
SET NEWNAME FOR DATAFILE 260 TO '/drdata07/mlprod/da_usage03_13 ';
SET NEWNAME FOR DATAFILE 261 TO '/drdata07/mlprod/ind_usage03_05 ';
SET NEWNAME FOR DATAFILE 262 TO '/drdata07/mlprod/da_usage01_20 ';
SET NEWNAME FOR DATAFILE 263 TO '/drdata07/mlprod/da_general_29 ';
SET NEWNAME FOR DATAFILE 264 TO '/drdata07/mlprod/da_usage02_18 ';
SET NEWNAME FOR DATAFILE 265 TO '/drdata08/mlprod/ind_usage01_15 ';
SET NEWNAME FOR DATAFILE 266 TO '/drdata07/mlprod/DA_LOB_03 ';
SET NEWNAME FOR DATAFILE 267 TO '/drdata07/mlprod/xdb_02 ';
SET NEWNAME FOR DATAFILE 268 TO '/drdata07/mlprod/da_general_30 ';
SET NEWNAME FOR DATAFILE 269 TO '/drdata07/mlprod/da_usage02_19 ';
SET NEWNAME FOR DATAFILE 270 TO '/drdata07/mlprod_usage02_08.dbf ';
SET NEWNAME FOR DATAFILE 271 TO '/drdata07/mlprod/da_rating_15 ';
SET NEWNAME FOR DATAFILE 272 TO '/drdata07/mlprod/da_general_31 ';
SET NEWNAME FOR DATAFILE 273 TO '/drdata08/mlprod/da_mediation_12 ';
SET NEWNAME FOR DATAFILE 274 TO '/drdata08/mlprod/da_rating_16 ';
SET NEWNAME FOR DATAFILE 275 TO '/drdata08/mlprod/da_mediation_13 ';
SET NEWNAME FOR DATAFILE 276 TO '/drdata08/mlprod/da_rating_17 ';
SET NEWNAME FOR DATAFILE 277 TO '/drdata08/mlprod/da_rating_18 ';
SET NEWNAME FOR DATAFILE 278 TO '/drdata08/mlprod/da_rating_19 ';
SET NEWNAME FOR DATAFILE 279 TO '/drdata08/mlprod/da_rating_20 ';
SET NEWNAME FOR DATAFILE 280 TO '/drdata08/mlprod/da_rating_21 ';
SET NEWNAME FOR DATAFILE 281 TO '/drdata07/mlprod/da_rating_22 ';
SET NEWNAME FOR DATAFILE 282 TO '/drdata08/mlprod/da_rating_23 ';
SET NEWNAME FOR DATAFILE 283 TO '/drdata08/mlprod/da_general_32 ';
SET NEWNAME FOR DATAFILE 284 TO '/drdata07/mlprod/da_usage03_14 ';
SET NEWNAME FOR DATAFILE 285 TO '/drdata07/mlprod/da_rating_24 ';
SET NEWNAME FOR DATAFILE 286 TO '/drdata08/mlprod/da_rating_24 ';
SET NEWNAME FOR DATAFILE 287 TO '/drdata07/mlprod/ind_usage01_16 ';
SET NEWNAME FOR DATAFILE 288 TO '/drdata07/mlprod/da_mediation_14 ';
SET NEWNAME FOR DATAFILE 289 TO '/drdata06/mlprod/ind_usage03_06 ';
SET NEWNAME FOR DATAFILE 290 TO '/drdata06/mlprod/da_rating_25 ';
SET NEWNAME FOR DATAFILE 291 TO '/drdata06/mlprod/da_mediation_14 ';
SET NEWNAME FOR DATAFILE 292 TO '/drdata06/mlprod/ind_usage02_09 ';
SET NEWNAME FOR DATAFILE 293 TO '/drdata06/mlprod/da_usage03_15.dbf ';
SET NEWNAME FOR DATAFILE 294 TO '/drdata06/mlprod/da_general_33.dbf ';
SET NEWNAME FOR DATAFILE 295 TO '/drdata06/mlprod/da_mediation_15.dbf ';
SET NEWNAME FOR DATAFILE 296 TO '/drdata06/mlprod/da_usage03_15 ';
SET NEWNAME FOR DATAFILE 297 TO '/drdata08/mlprod/da_usage03_15 ';
SET NEWNAME FOR DATAFILE 298 TO '/drdata08/mlprod/da_mediation_16 ';
SET NEWNAME FOR DATAFILE 299 TO '/drdata02/mlprod/da_generall_34 ';
SET NEWNAME FOR DATAFILE 300 TO '/drdata02/mlprod/da_usage02_20.dbf ';
SET NEWNAME FOR DATAFILE 301 TO '/drdata04/mlprod/system_04 ';
SET NEWNAME FOR DATAFILE 302 TO '/drdata09/mlprod/da_general_35 ';
SET NEWNAME FOR DATAFILE 303 TO '/drdata09/mlprod/da_mediation_17 ';
SET NEWNAME FOR DATAFILE 304 TO '/drdata09/mlprod/da_rating_26 ';
SET NEWNAME FOR DATAFILE 305 TO '/drdata09/mlprod/system_05 ';
SET NEWNAME FOR DATAFILE 306 TO '/drdata10/mlprod/ind_general_12 ';
SET NEWNAME FOR DATAFILE 307 TO '/drdata10/mlprod/da_rating_27 ';
SET NEWNAME FOR DATAFILE 308 TO '/drdata10/mlprod/da_rating_28 ';
SET NEWNAME FOR DATAFILE 309 TO '/drdata9/mlprod/da_mediation_18 ';
SET NEWNAME FOR DATAFILE 310 TO '/drdata10/mlprod/da_mediation_19 ';
SET NEWNAME FOR DATAFILE 311 TO '/drdata10/mlprod/da_rating_29 ';
SET NEWNAME FOR DATAFILE 312 TO '/drdata10/mlprod/da_mediation_20 ';
SET NEWNAME FOR DATAFILE 313 TO '/drdata10/mlprod/da_rating_30 ';
SET NEWNAME FOR DATAFILE 314 TO '/drdata10/mlprod/da_rating_31 ';
SET NEWNAME FOR DATAFILE 315 TO '/drdata09/mlprod/da_rating_32 ';
SET NEWNAME FOR DATAFILE 316 TO '/drdata10/mlprod/da_rating_33 ';
SET NEWNAME FOR DATAFILE 317 TO '/drdata10/mlprod/da_rating_34 ';
SET NEWNAME FOR DATAFILE 318 TO '/drdata10/mlprod/da_rating_35 ';
SET NEWNAME FOR DATAFILE 319 TO '/drdata10/mlprod/da_rating_36 ';
SET NEWNAME FOR DATAFILE 320 TO '/drdata10/mlprod/da_rating_37 ';
SET NEWNAME FOR DATAFILE 321 TO '/drdata10/mlprod/da_rating_38 ';
SET NEWNAME FOR DATAFILE 322 TO '/drdata10/mlprod/da_mediation_21 ';
SET NEWNAME FOR DATAFILE 323 TO '/drdata09/mlprod/da_rating_39 ';
SET NEWNAME FOR DATAFILE 324 TO '/drdata09/mlprod/da_usage03_16 ';
SET NEWNAME FOR DATAFILE 325 TO '/drdata09/mlprod/da_usage04_13 ';
SET NEWNAME FOR DATAFILE 326 TO '/drdata07/mlprod/ind_usage03_06 ';
SET NEWNAME FOR DATAFILE 327 TO '/drdata09/mlprod/ind_usage04_07 ';
SET NEWNAME FOR DATAFILE 328 TO '/drdata09/mlprod/ind_usage03_07 ';
SET NEWNAME FOR DATAFILE 329 TO '/drdata10/mlprod/da_rating_39 ';
SET NEWNAME FOR DATAFILE 330 TO '/drdata09/mlprod/da_rating_40 ';
SET NEWNAME FOR DATAFILE 331 TO '/drdata10/mlprod/da_usage01_21 ';
SET NEWNAME FOR DATAFILE 332 TO '/drdata10/mlprod/da_general_36 ';
SET NEWNAME FOR DATAFILE 333 TO '/drdata09/mlprod/ind_general_13 ';
SET NEWNAME FOR DATAFILE 334 TO '/drdata09/mlprod/da_usage05_19 ';
SET NEWNAME FOR DATAFILE 335 TO '/drdata09/mlprod/ind_usage05_09 ';
SET NEWNAME FOR DATAFILE 336 TO '/drdata10/mlprod/da_usage02_21 ';
SET NEWNAME FOR DATAFILE 337 TO '/drdata10/mlprod/da_mediation_22 ';
SET NEWNAME FOR DATAFILE 338 TO '/drdata10/mlprod/da_general_37 ';
SET NEWNAME FOR DATAFILE 339 TO '/drdata10/mlprod/da_general_38 ';
SET NEWNAME FOR DATAFILE 340 TO '/drdata10/mlprod/undo03.dbf ';
SET NEWNAME FOR DATAFILE 341 TO '/drdata10/mlprod/da_mediation_23 ';
SET NEWNAME FOR DATAFILE 342 TO '/drdata10/mlprod/DA_LOB_04 ';
SET NEWNAME FOR DATAFILE 343 TO '/drdata10/mlprod/da_mediation_24 ';
SET NEWNAME FOR DATAFILE 344 TO '/drdata10/mlprod/da_rating_40 ';
SET NEWNAME FOR DATAFILE 345 TO '/drdata09/mlprod/da_mediation_25.dbf ';



restore database;
alter database mount;
SWITCH DATAFILE ALL;
recover database;
release channel p1;
release channel p2;
release channel p3;
}
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 1 2008
Added on Jun 3 2008
2 comments
699 views