基于NBU的备份恢复

从NBU转储数据文件：

export ORACLE_SID=DWTH
rman target / <<EOF
run {
allocate channel c1 type 'sbt_tape';
allocate channel c2 type 'sbt_tape';
allocate channel c3 type 'sbt_tape';
allocate channel c4 type 'sbt_tape';
SEND 'NB_ORA_SERV=NBU-MEDIA2,NB_ORA_CLIENT=ods2';
set newname for datafile 00001 to '/oradata/dwth/datafile/rlvdwsys';
set newname for datafile 00002 to '/oradata/dwth/datafile/rlvdwundo1';
set newname for datafile 00003 to '/oradata/dwth/datafile/rlvdwsau';
set newname for datafile 00004 to '/oradata/dwth/datafile/rlvdwundo2';
set newname for datafile 00005 to '/oradata/dwth/datafile/rlvdwusr';
set newname for datafile 00006 to '/oradata/dwth/datafile/rlvdw10gdssdat1';
set newname for datafile 00007 to '/oradata/dwth/datafile/rlvdw10gdssdat2';
set newname for datafile 00008 to '/oradata/dwth/datafile/rlvdw10gdssdat3';
set newname for datafile 00009 to '/oradata/dwth/datafile/rlvdw10gdssdat4';
set newname for datafile 00010 to '/oradata/dwth/datafile/rlvdw10gdssdat5';
set newname for datafile 00011 to '/oradata/dwth/datafile/rlvdw10gdssdat6';
set newname for datafile 00012 to '/oradata/dwth/datafile/rlvdw10gdssdat7';
set newname for datafile 00013 to '/oradata/dwth/datafile/rlvdw10gdssdat8';
set newname for datafile 00014 to '/oradata/dwth/datafile/rlvdw10gdssdat9';
set newname for datafile 00015 to '/oradata/dwth/datafile/rlvdw4gdssidx1';
set newname for datafile 00016 to '/oradata/dwth/datafile/rlvdw4gsgdcdat';
set newname for datafile 00017 to '/oradata/dwth/datafile/rlvdw5gdxp1';
set newname for datafile 00018 to '/oradata/dwth/datafile/rlvdw5gdxp2';
set newname for datafile 00019 to '/oradata/dwth/datafile/rlvdw1gmaster';
set newname for datafile 00020 to '/oradata/dwth/datafile/rlvdw1geic1';
set newname for datafile 00021 to '/oradata/dwth/datafile/rlvdw1gmdods1';
set newname for datafile 00022 to '/oradata/dwth/datafile/rlvdw1gmdods2';
set newname for datafile 00023 to '/oradata/dwth/datafile/rlvdw1gmdods3';
set newname for datafile 00024 to '/oradata/dwth/datafile/rlvdw2gbmq1';
set newname for datafile 00025 to '/oradata/dwth/datafile/rlvdw10gec1';
set newname for datafile 00026 to '/oradata/dwth/datafile/rlvdw6gerp1';
set newname for datafile 00027 to '/oradata/dwth/datafile/rlvdw10ghr1';
set newname for datafile 00028 to '/oradata/dwth/datafile/rlvdw10ghr2';
set newname for datafile 00029 to '/oradata/dwth/datafile/rlvdw10ghr3';
set newname for datafile 00030 to '/oradata/dwth/datafile/rlvdw10ghrsot1';
set newname for datafile 00031 to '/oradata/dwth/datafile/rlvdw10ghryw1';
set newname for datafile 00032 to '/oradata/dwth/datafile/rlvdw10ghryw2';
set newname for datafile 00033 to '/oradata/dwth/datafile/rlvdw10ghryw3';
set newname for datafile 00034 to '/oradata/dwth/datafile/rlvdw10gims1';
set newname for datafile 00035 to '/oradata/dwth/datafile/rlvdw1gitg1';
set newname for datafile 00036 to '/oradata/dwth/datafile/rlvdw1gjj1';
set newname for datafile 00037 to '/oradata/dwth/datafile/rlvdw1gjjyy1';
set newname for datafile 00038 to '/oradata/dwth/datafile/rlvdw1gjjyytmp1';
set newname for datafile 00039 to '/oradata/dwth/datafile/rlvdw1glogis1';
set newname for datafile 00040 to '/oradata/dwth/datafile/rlvdw10gnd1';
set newname for datafile 00041 to '/oradata/dwth/datafile/rlvdw10gpms1';
set newname for datafile 00042 to '/oradata/dwth/datafile/rlvdw1gsgcs1';
set newname for datafile 00043 to '/oradata/dwth/datafile/rlvdw10gstat1';
set newname for datafile 00044 to '/oradata/dwth/datafile/rlvdw10gstat2';
set newname for datafile 00045 to '/oradata/dwth/datafile/rlvdw10gstat3';
set newname for datafile 00046 to '/oradata/dwth/datafile/rlvdw10gstat4';
set newname for datafile 00047 to '/oradata/dwth/datafile/rlvdw10gstat5';
set newname for datafile 00048 to '/oradata/dwth/datafile/rlvdw10gwz1';
set newname for datafile 00049 to '/oradata/dwth/datafile/rlvdw4gsgdc2';
set newname for datafile 00050 to '/oradata/dwth/datafile/rlvdw4gsgdc3';
set newname for datafile 00051 to '/oradata/dwth/datafile/rlvdw4gsgdc4';
set newname for datafile 00052 to '/oradata/dwth/datafile/rlvdw4gsgdc5';
set newname for datafile 00053 to '/oradata/dwth/datafile/rlvdw4gsgdc6';
set newname for datafile 00054 to '/oradata/dwth/datafile/rlvdw4gsgdc7';
set newname for datafile 00055 to '/oradata/dwth/datafile/rlvdw4gsgdc8';
set newname for datafile 00056 to '/oradata/dwth/datafile/rlvdw4gsgdc9';
set newname for datafile 00057 to '/oradata/dwth/datafile/rlvdw4gsgdc10';
set newname for datafile 00058 to '/oradata/dwth/datafile/rlvdw4gsgdc11';
set newname for datafile 00059 to '/oradata/dwth/datafile/rlvdw4gsgdc12';
set newname for datafile 00060 to '/oradata/dwth/datafile/rlvdw4gsgdc13';
set newname for datafile 00061 to '/oradata/dwth/datafile/rlvdw4gsgdc14';
set newname for datafile 00062 to '/oradata/dwth/datafile/rlvdwodspms';
set newname for datafile 00063 to '/oradata/dwth/datafile/rlvdwsgdcmm';
set newname for datafile 00064 to '/oradata/dwth/datafile/rlvdwmdpms';
set newname for datafile 00065 to '/oradata/dwth/datafile/rlvdwmdtzgl';
set newname for datafile 00066 to '/oradata/dwth/datafile/rlvdwyxgspms';
set newname for datafile 00067 to '/oradata/dwth/datafile/rlvdwjjgyy';
set newname for datafile 00068 to '/oradata/dwth/datafile/rlvdwtseicbase';
set newname for datafile 00069 to '/oradata/dwth/datafile/rlvdwtseicyysk';
set newname for datafile 00070 to '/oradata/dwth/datafile/rlvdw_logis_2G';
set newname for datafile 00071 to '/oradata/dwth/datafile/rlvdw_lpromis_2G';
set newname for datafile 00072 to '/oradata/dwth/datafile/rlvdwmdcwmdm';
set newname for datafile 00073 to '/oradata/dwth/datafile/rlvdwmdMDM_5G';
set newname for datafile 00074 to '/oradata/dwth/datafile/rlvdwtsycjkyx';
set newname for datafile 00075 to '/oradata/dwth/datafile/rlvdw10gwz2';
set newname for datafile 00076 to '/oradata/dwth/datafile/rlvdwcwgkxmjc5g';
set newname for datafile 00077 to '/oradata/dwth/datafile/rlvcwgk1xmjc2g';
set newname for datafile 00078 to '/oradata/dwth/datafile/rlvcwgk45ods2g';
set newname for datafile 00079 to '/oradata/dwth/datafile/rlvcwgk52xmjc2g';
set newname for datafile 00080 to '/oradata/dwth/datafile/rlvcwgk50xmjc2g';
set newname for datafile 00081 to '/oradata/dwth/datafile/rlvcwgk54xmjc2g';
set newname for datafile 00082 to '/oradata/dwth/datafile/rlvcwgk35ods2g';
set newname for datafile 00083 to '/oradata/dwth/datafile/rlvcwgk47ods2g';
set newname for datafile 00084 to '/oradata/dwth/datafile/rlvcwgk34ods2g';
set newname for datafile 00085 to '/oradata/dwth/datafile/rlvcwgk40ods2g';
set newname for datafile 00086 to '/oradata/dwth/datafile/rlvcwgk41ods2g';
set newname for datafile 00087 to '/oradata/dwth/datafile/rlvcwgk44ods2g';
set newname for datafile 00088 to '/oradata/dwth/datafile/rlvcwgk49ods2g';
set newname for datafile 00089 to '/oradata/dwth/datafile/rlvcwgk46ods2g';
set newname for datafile 00090 to '/oradata/dwth/datafile/rlvcwgk48ods2g';
set newname for datafile 00091 to '/oradata/dwth/datafile/rlvcwgk39ods2g';
set newname for datafile 00092 to '/oradata/dwth/datafile/rlvcwgk33ods2g';
set newname for datafile 00093 to '/oradata/dwth/datafile/rlvope_1';
set newname for datafile 00094 to '/oradata/dwth/datafile/rlvdwtsycjkyx10g';
set newname for datafile 00095 to '/oradata/dwth/datafile/rlvdw10gwz3';
set newname for datafile 00096 to '/oradata/dwth/datafile/rlvdw1gmdods4';
set newname for datafile 00097 to '/oradata/dwth/datafile/rlvdw5gmdods1';
set newname for datafile 00098 to '/oradata/dwth/datafile/rlvdwmdjjgk10G';
set newname for datafile 00099 to '/oradata/dwth/datafile/rlvdtsycjkyx10g2';
set newname for datafile 00100 to '/oradata/dwth/datafile/rlvmderppm10g1';
set newname for datafile 00101 to '/oradata/dwth/datafile/rlvdw10gwz4';
set newname for datafile 00102 to '/oradata/dwth/datafile/rlvmdml_5G';
set newname for datafile 00103 to '/oradata/dwth/datafile/rlvdw5gmdods3';
set newname for datafile 00104 to '/oradata/dwth/datafile/rlvdw10gwz5';
set newname for datafile 00105 to '/oradata/dwth/datafile/rlvmdyjzh_5G';
set newname for datafile 00106 to '/oradata/dwth/datafile/rlvlcamssync5g_1';
set newname for datafile 00107 to '/oradata/dwth/datafile/rlvrzyjkh5G_01';
set newname for datafile 00108 to '/oradata/dwth/datafile/rlvdtsycjkyx10g3';
set newname for datafile 00109 to '/oradata/dwth/datafile/rlvdwmdeicb2G';
set newname for datafile 00110 to '/oradata/dwth/datafile/rlvdwmdeicy1G';
set newname for datafile 00111 to '/oradata/dwth/datafile/rlvbufmmmmyw10g';
set newname for datafile 00112 to '/oradata/dwth/datafile/rlvodsmmmm20g_01';
set newname for datafile 00113 to '/oradata/dwth/datafile/rlvodsmmmm20g_02';
set newname for datafile 00114 to '/oradata/dwth/datafile/rlvodsmmmm20g_03';
set newname for datafile 00115 to '/oradata/dwth/datafile/rlvmdtsinfa20g_1';
set newname for datafile 00116 to '/oradata/dwth/datafile/rlvdw4gsgdc15';
set newname for datafile 00117 to '/oradata/dwth/datafile/rlvdw5geic1';
set newname for datafile 00118 to '/oradata/dwth/datafile/rlvmdpmsh1_5G';
set newname for datafile 00119 to '/oradata/dwth/datafile/rlvfinctrl15G01';
set newname for datafile 00120 to '/oradata/dwth/datafile/rlvdwsgdcmm5g_01';
set newname for datafile 00121 to '/oradata/dwth/datafile/rlvdw10gwz6';
set newname for datafile 00122 to '/oradata/dwth/datafile/rlvtscwgkbl10g01';
set newname for datafile 00123 to '/oradata/dwth/datafile/rlvdtsycjkyx10g4';
set newname for datafile 00124 to '/oradata/dwth/datafile/rlvtscwgkbl10g02';
set newname for datafile 00125 to '/oradata/dwth/datafile/rlvtscwgkbl10g03';
set newname for datafile 00126 to '/oradata/dwth/datafile/rlvtscwgkbl10g04';
set newname for datafile 00127 to '/oradata/dwth/datafile/rlvdtsycjkyx10g5';
set newname for datafile 00128 to '/oradata/dwth/datafile/rlvdw5gmdods4';
set newname for datafile 00129 to '/oradata/dwth/datafile/rlvdtsycjkyx10g6';
set newname for datafile 00130 to '/oradata/dwth/datafile/rlvdw10gsgdc1';
set newname for datafile 00131 to '/oradata/dwth/datafile/rlvdw5gjjyy1';
set newname for datafile 00132 to '/oradata/dwth/datafile/rlvsgcim20g1';
set newname for datafile 00133 to '/oradata/dwth/datafile/rlvdwdssdat10g10';
set newname for datafile 00134 to '/oradata/dwth/datafile/rlvbufmmmmyw10g2';
set newname for datafile 00135 to '/oradata/dwth/datafile/rlvdw20ghr1';
set newname for datafile 00136 to '/oradata/dwth/datafile/rlvdw20ghr2';
set newname for datafile 00137 to '/oradata/dwth/datafile/rlvdw20ghr3';
set newname for datafile 00138 to '/oradata/dwth/datafile/rlvdw20ghryw1';
set newname for datafile 00139 to '/oradata/dwth/datafile/rlvdw20ghryw2';
set newname for datafile 00140 to '/oradata/dwth/datafile/rlvdw20ghryw3';
set newname for datafile 00141 to '/oradata/dwth/datafile/rlvtscwgkbl20g01';
set newname for datafile 00142 to '/oradata/dwth/datafile/rlvdwodspms10G_1';
set newname for datafile 00143 to '/oradata/dwth/datafile/rlvodsmmmm20g_04';
set newname for datafile 00144 to '/oradata/dwth/datafile/rlvodserpps10G01';
set newname for datafile 00145 to '/oradata/dwth/datafile/rlvdw20gwz1';
set newname for datafile 00146 to '/oradata/dwth/datafile/rlvmdygbx';
set newname for datafile 00147 to '/oradata/dwth/datafile/rlvmdodsview10G';
set newname for datafile 00148 to '/oradata/dwth/datafile/rlvmdodsbuff10G';
set newname for datafile 00149 to '/oradata/dwth/datafile/rlvodsview';
set newname for datafile 00150 to '/oradata/dwth/datafile/rlvodsdxp10G';
set newname for datafile 00151 to '/oradata/dwth/datafile/rlvuser5G';
set newname for datafile 00152 to '/oradata/dwth/datafile/rlvfinctrl15G02';
set newname for datafile 00153 to '/oradata/dwth/datafile/rlvmdxtptlcjk10g';
set newname for datafile 00154 to '/oradata/dwth/datafile/rlvdw20gdssdat1';
set newname for datafile 00155 to '/oradata/dwth/datafile/rlvbufmmmmyw20g1';
set newname for datafile 00156 to '/oradata/dwth/datafile/rlvodsmmmm20g_05';
set newname for datafile 00157 to '/oradata/dwth/datafile/rlvfinctrl15G03';
set newname for datafile 00158 to '/oradata/dwth/datafile/rlvtscwgkbl20g02';
set newname for datafile 00159 to '/oradata/dwth/datafile/rlvfinctrl20G01';
set newname for datafile 00160 to '/oradata/dwth/datafile/rlvdw20gdssdat2';
set newname for datafile 00161 to '/oradata/dwth/datafile/rlvbufreadgis20G';
set newname for datafile 00162 to '/oradata/dwth/datafile/rlvdw20gdssdat3';
set newname for datafile 00163 to '/oradata/dwth/datafile/rlvdw20gdssdat4';
set newname for datafile 00164 to '/oradata/dwth/datafile/rlvdw20gdssdat5';
set newname for datafile 00165 to '/oradata/dwth/datafile/rlvdw20gwz2';
set newname for datafile 00166 to '/oradata/dwth/datafile/rlvtscwgkbl20g03';
set newname for datafile 00167 to '/oradata/dwth/datafile/rlvfinctrl20G02';
set newname for datafile 00168 to '/oradata/dwth/datafile/rlvfinctrl20G03';
set newname for datafile 00169 to '/oradata/dwth/datafile/rlvfinctrl20G04';
set newname for datafile 00170 to '/oradata/dwth/datafile/rlvfinctrl20G05';
set newname for datafile 00171 to '/oradata/dwth/datafile/rlvfinctrl20G06';
set newname for datafile 00172 to '/oradata/dwth/datafile/rlvfinctrl20G07';
set newname for datafile 00173 to '/oradata/dwth/datafile/rlvfinctrl20G08';
set newname for datafile 00174 to '/oradata/dwth/datafile/rlvdw10gmdods1';
set newname for datafile 00175 to '/oradata/dwth/datafile/rlvdw20Gsgdc1';
set newname for datafile 00176 to '/oradata/dwth/datafile/rlvodsmmmm20g_06';
set newname for datafile 00177 to '/oradata/dwth/datafile/rlvdw20gdssdat6';
set newname for datafile 00178 to '/oradata/dwth/datafile/rlvdw30gdssdat1';
set newname for datafile 00179 to '/oradata/dwth/datafile/rlvdw30gdssdat2';
set newname for datafile 00180 to '/oradata/dwth/datafile/rlvdw30gdssdat3';
set newname for datafile 00181 to '/oradata/dwth/datafile/rlvdw30gdssdat4';
set newname for datafile 00182 to '/oradata/dwth/datafile/rlvdw30gdssdat5';
set newname for datafile 00183 to '/oradata/dwth/datafile/rlvdw30gdssdat6';
set newname for datafile 00184 to '/oradata/dwth/datafile/rlvodsdxp20G';
set newname for datafile 00185 to '/oradata/dwth/datafile/rlvodsview30G_01';
set newname for datafile 00186 to '/oradata/dwth/datafile/rlvdw30gdssdat7';
set newname for datafile 00187 to '/oradata/dwth/datafile/rlvdw30gdssdat8';
set newname for datafile 00188 to '/oradata/dwth/datafile/rlvdw30gdssdat9';
set newname for datafile 00189 to '/oradata/dwth/datafile/rlvodsdxp10G_02';
set newname for datafile 00190 to '/oradata/dwth/datafile/rlvdw30gdsdat10';
set newname for datafile 00191 to '/oradata/dwth/datafile/rlvogg10G_01';
set newname for datafile 00192 to '/oradata/dwth/datafile/rlvodsview30G_02';
set newname for datafile 00193 to '/oradata/dwth/datafile/rlvodsdxpidx_20G';
set newname for datafile 00194 to '/oradata/dwth/datafile/rlvodsview30G_03';
set newname for datafile 00195 to '/oradata/dwth/datafile/odsview.256.815154191';
set newname for datafile 00196 to '/oradata/dwth/datafile/odsview.257.815154519';
set newname for datafile 00197 to '/oradata/dwth/datafile/odsview.258.815154629';
set newname for datafile 00198 to '/oradata/dwth/datafile/odsview.259.815154723';
set newname for datafile 00199 to '/oradata/dwth/datafile/odsview.260.815154827';
set newname for datafile 00200 to '/oradata/dwth/datafile/odsview.261.815154917';
set newname for datafile 00201 to '/oradata/dwth/datafile/odsview.262.815168655';
set newname for datafile 00202 to '/oradata/dwth/datafile/odsview.263.815169055';
set newname for datafile 00203 to '/oradata/dwth/datafile/odsview.264.815169149';
set newname for datafile 00204 to '/oradata/dwth/datafile/odsview.265.815169533';
set newname for datafile 00205 to '/oradata/dwth/datafile/odsview.266.815170699';
set newname for datafile 00206 to '/oradata/dwth/datafile/odsview.267.815170803';
set newname for datafile 00207 to '/oradata/dwth/datafile/odsview.268.815171249';
set newname for datafile 00208 to '/oradata/dwth/datafile/odsview.269.815171359';
set newname for datafile 00209 to '/oradata/dwth/datafile/odsview.270.815171529';
set newname for datafile 00210 to '/oradata/dwth/datafile/ts_ycjk_yx.271.815414265';
set newname for datafile 00211 to '/oradata/dwth/datafile/sgdc_wz_data.272.815414457';
set newname for datafile 00212 to '/oradata/dwth/datafile/odsview.273.817304285';
set newname for datafile 00213 to '/oradata/dwth/datafile/odsview.274.817304763';
set newname for datafile 00214 to '/oradata/dwth/datafile/odsview.275.817312249';
set newname for datafile 00215 to '/oradata/dwth/datafile/odsview.276.817312959';
set newname for datafile 00216 to '/oradata/dwth/datafile/odsview.277.817313575';
set newname for datafile 00217 to '/oradata/dwth/datafile/sgdc_mm_data.278.821114677';
set newname for datafile 00218 to '/oradata/dwth/datafile/ods_mm_mmods.279.821115049';
set newname for datafile 00219 to '/oradata/dwth/datafile/buf_mm_mmyw.280.821115293';
set newname for datafile 00220 to '/oradata/dwth/datafile/ts_cwgkblzc.281.821115505';
set newname for datafile 00221 to '/oradata/dwth/datafile/sgdc_finctrl.282.821439231';
set newname for datafile 00222 to '/oradata/dwth/datafile/undotbs1.283.822153365';
set newname for datafile 00223 to '/oradata/dwth/datafile/undotbs2.284.822153601';
set newname for datafile 00224 to '/oradata/dwth/datafile/ods_ghjh_telek.285.822154101';
set newname for datafile 00225 to '/oradata/dwth/datafile/odsdxp.286.822935717';
set newname for datafile 00226 to '/oradata/dwth/datafile/ts_eic_base.287.823601323';
set newname for datafile 00227 to '/oradata/dwth/datafile/odsview.288.824048185';
set newname for datafile 00228 to '/oradata/dwth/datafile/ods_mm_mmods.289.824468825';
set newname for datafile 00229 to '/oradata/dwth/datafile/sgdc_hryw_data.290.824469219';
set newname for datafile 00230 to '/oradata/dwth/datafile/sgdc_wz_data.291.824469297';
set newname for datafile 00231 to '/oradata/dwth/datafile/odsview.292.824641037';
set newname for datafile 00232 to '/oradata/dwth/datafile/buf_mm_mmyw.293.825259425';
set newname for datafile 00233 to '/oradata/dwth/datafile/sgdcdata.294.825933947';
set newname for datafile 00234 to '/oradata/dwth/datafile/odsdxp.295.826293647';
set newname for datafile 00235 to '/oradata/dwth/datafile/odsview.296.826293815';
set newname for datafile 00236 to '/oradata/dwth/datafile/ods_mm_mmods.297.828266331';
set newname for datafile 00237 to '/oradata/dwth/datafile/ts_share_hr.dbf';
set newname for datafile 00238 to '/oradata/dwth/datafile/dljy.299.831314077';
set newname for datafile 00239 to '/oradata/dwth/datafile/mdods.300.832208179';
set newname for datafile 00240 to '/oradata/dwth/datafile/sgdc_mm_data.301.832208337';
set newname for datafile 00241 to '/oradata/dwth/datafile/cwgkbzlc.302.832785553';
set newname for datafile 00242 to '/oradata/dwth/datafile/odsview.303.833103789';
set newname for datafile 00243 to '/oradata/dwth/datafile/tbs_top_dt.304.833916291';
set newname for datafile 00244 to '/oradata/dwth/datafile/tbs_mon_dt.305.833916321';
set newname for datafile 00245 to '/oradata/dwth/datafile/tbs_sot_dt.306.833916359';
set newname for datafile 00246 to '/oradata/dwth/datafile/tbs_ias_dt.307.833916581';
set newname for datafile 00247 to '/oradata/dwth/datafile/tbs_calc_dt.308.833916619';
set newname for datafile 00248 to '/oradata/dwth/datafile/tbs_calc_idx.309.833916685';
set newname for datafile 00249 to '/oradata/dwth/datafile/tbs_mon_idx.310.833916717';
set newname for datafile 00250 to '/oradata/dwth/datafile/tbs_top_idx.311.833916753';
set newname for datafile 00251 to '/oradata/dwth/datafile/tbs_ias_idx.312.833916769';
set newname for datafile 00252 to '/oradata/dwth/datafile/tbs_sot_idx.313.833916785';
set newname for datafile 00253 to '/oradata/dwth/datafile/tbs_bam_dt.314.833916803';
set newname for datafile 00254 to '/oradata/dwth/datafile/tbs_bpm_dt.315.833916825';
set newname for datafile 00255 to '/oradata/dwth/datafile/tbs_bpm_idx.316.833916839';
set newname for datafile 00256 to '/oradata/dwth/datafile/tbs_omcw_idx.317.833916893';
set newname for datafile 00257 to '/oradata/dwth/datafile/tbs_omcw_dt.270.833917137';
set newname for datafile 00258 to '/oradata/dwth/datafile/tbs_omcw_dt.1074.833917687';
set newname for datafile 00259 to '/oradata/dwth/datafile/tbs_omcw_dt.316.833917921';
set newname for datafile 00260 to '/oradata/dwth/datafile/sg_mdm.318.833946033';
set newname for datafile 00261 to '/oradata/dwth/datafile/tbs_bam_idx.319.833957531';
set newname for datafile 00262 to '/oradata/dwth/datafile/odsview.320.833991645';
set newname for datafile 00263 to '/oradata/dwth/datafile/tbs_bam_dt.323.834530039';
set newname for datafile 00264 to '/oradata/dwth/datafile/odsview.324.835303049';
set newname for datafile 00265 to '/oradata/dwth/datafile/ods_zg.325.835622721';
set newname for datafile 00266 to '/oradata/dwth/datafile/odsview.326.836414167';
set newname for datafile 00267 to '/oradata/dwth/datafile/dssdat1.327.836931017';
set newname for datafile 00268 to '/oradata/dwth/datafile/sgdc_hr_data.328.836931621';
set newname for datafile 00269 to '/oradata/dwth/datafile/ind_ts.256.837124961';
set newname for datafile 00270 to '/oradata/dwth/datafile/ind_ts.257.837125103';
set newname for datafile 00271 to '/oradata/dwth/datafile/ind_ts.258.837125249';
set newname for datafile 00272 to '/oradata/dwth/datafile/ind_ts.259.837125379';
set newname for datafile 00273 to '/oradata/dwth/datafile/ind_ts.260.837125523';
set newname for datafile 00274 to '/oradata/dwth/datafile/ind_ts.261.837125667';
set newname for datafile 00275 to '/oradata/dwth/datafile/ind_ts.262.837125815';
set newname for datafile 00276 to '/oradata/dwth/datafile/ind_ts.263.837125955';
set newname for datafile 00277 to '/oradata/dwth/datafile/ind_ts.264.837126097';
set newname for datafile 00278 to '/oradata/dwth/datafile/ind_ts.265.837126239';
set newname for datafile 00279 to '/oradata/dwth/datafile/ind_ts.266.837126385';
set newname for datafile 00280 to '/oradata/dwth/datafile/ind_ts.267.837126525';
set newname for datafile 00281 to '/oradata/dwth/datafile/sysaux.329.837286313';
set newname for datafile 00282 to '/oradata/dwth/datafile/ods_mm_mmods.330.837454917';
set newname for datafile 00283 to '/oradata/dwth/datafile/ts_cwgkblzc.331.837637341';
set newname for datafile 00284 to '/oradata/dwth/datafile/dssdat1.332.838029645';
set newname for datafile 00285 to '/oradata/dwth/datafile/odsview.333.839784283';
set newname for datafile 00286 to '/oradata/dwth/datafile/odsview.334.840479109';
set newname for datafile 00287 to '/oradata/dwth/datafile/odsview.335.841576459';
set newname for datafile 00288 to '/oradata/dwth/datafile/odsview.336.841577093';
set newname for datafile 00289 to '/oradata/dwth/datafile/odsview.337.841843085';
set newname for datafile 00290 to '/oradata/dwth/datafile/sg_mdm.338.842000005';
set newname for datafile 00291 to '/oradata/dwth/datafile/users.339.842000757';
set newname for datafile 00292 to '/oradata/dwth/datafile/tbs_calc_dt.340.842119157';
set newname for datafile 00293 to '/oradata/dwth/datafile/odsview.341.842120329';
set newname for datafile 00294 to '/oradata/dwth/datafile/dljyzx.342.842805689';
set newname for datafile 00295 to '/oradata/dwth/datafile/odsview.343.843087757';
set newname for datafile 00296 to '/oradata/dwth/datafile/odsview.344.844022681';
set newname for datafile 00297 to '/oradata/dwth/datafile/zlb.345.844538839';
set newname for datafile 00298 to '/oradata/dwth/datafile/odsview.346.844970423';
set newname for datafile 00299 to '/oradata/dwth/datafile/odsview.347.844971539';
set newname for datafile 00300 to '/oradata/dwth/datafile/yxpt.348.844972177';
set newname for datafile 00301 to '/oradata/dwth/datafile/sgdc_hryw_data.349.845492459';
set newname for datafile 00302 to '/oradata/dwth/datafile/ts_cwgkblzc.350.845493369';
set newname for datafile 00303 to '/oradata/dwth/datafile/odsview.351.845493989';
set newname for datafile 00304 to '/oradata/dwth/datafile/tbs_sot_idx.352.845757909';
set newname for datafile 00305 to '/oradata/dwth/datafile/odsview.353.846188119';
set newname for datafile 00306 to '/oradata/dwth/datafile/tbs_top_dt.354.846694701';
set newname for datafile 00307 to '/oradata/dwth/datafile/dssdat1.355.846950617';
set newname for datafile 00308 to '/oradata/dwth/datafile/dssdat1.356.846950893';
set newname for datafile 00309 to '/oradata/dwth/datafile/sgdc_wz_data.357.846951241';
set newname for datafile 00310 to '/oradata/dwth/datafile/ts_ycjk_yx.358.846951585';
set newname for datafile 00311 to '/oradata/dwth/datafile/sgdcdata.359.846952075';
set newname for datafile 00312 to '/oradata/dwth/datafile/odsview.360.846952953';
set newname for datafile 00313 to '/oradata/dwth/datafile/odsview.361.846953697';
set newname for datafile 00314 to '/oradata/dwth/datafile/sgdcdata.362.846955015';
set newname for datafile 00315 to '/oradata/dwth/datafile/tbs_top_dt.363.847376133';
set newname for datafile 00316 to '/oradata/dwth/datafile/sgccerpjzbs.364.848244665';
set newname for datafile 00317 to '/oradata/dwth/datafile/odsview.365.848574257';
set newname for datafile 00318 to '/oradata/dwth/datafile/tbs_omcw_dt.366.848575217';
set newname for datafile 00319 to '/oradata/dwth/datafile/ts_cwgkblzc.367.848575933';
set newname for datafile 00320 to '/oradata/dwth/datafile/odsdxp.368.848576517';
set newname for datafile 00321 to '/oradata/dwth/datafile/dssdat1.369.848576819';
set newname for datafile 00322 to '/oradata/dwth/datafile/tbs_top_dt.370.848582281';
set newname for datafile 00323 to '/oradata/dwth/datafile/odsview.371.848582679';
set newname for datafile 00324 to '/oradata/dwth/datafile/undotbs1.373.848920587';
set newname for datafile 00325 to '/oradata/dwth/datafile/undotbs2.374.848920971';
set newname for datafile 00326 to '/oradata/dwth/datafile/mws_ajyth.375.849799827';
set newname for datafile 00327 to '/oradata/dwth/datafile/tbs_ias_dt.376.850474981';
set newname for datafile 00328 to '/oradata/dwth/datafile/sgdc_mm_data.377.850475303';
set newname for datafile 00329 to '/oradata/dwth/datafile/odsview.378.850482549';
set newname for datafile 00330 to '/oradata/dwth/datafile/odsview.379.850482767';
set newname for datafile 00331 to '/oradata/dwth/datafile/odsview.380.850671901';
set newname for datafile 00332 to '/oradata/dwth/datafile/odsview.381.851009489';
set newname for datafile 00333 to '/oradata/dwth/datafile/odsview.382.851011697';
set newname for datafile 00334 to '/oradata/dwth/datafile/odsview.383.851014275';
set newname for datafile 00335 to '/oradata/dwth/datafile/odsview.384.851017531';
set newname for datafile 00336 to '/oradata/dwth/datafile/odsview.394.853187171';
set newname for datafile 00337 to '/oradata/dwth/datafile/dssidx.385.851856185';
set newname for datafile 00338 to '/oradata/dwth/datafile/ts_cwgkblzc.386.851856365';
set newname for datafile 00339 to '/oradata/dwth/datafile/odsview.387.851856861';
set newname for datafile 00340 to '/oradata/dwth/datafile/tbs_calc_dt.388.852302975';
set newname for datafile 00341 to '/oradata/dwth/datafile/dssdat1.389.852303321';
set newname for datafile 00342 to '/oradata/dwth/datafile/sgdc_jjyy_data.390.852303701';
set newname for datafile 00343 to '/oradata/dwth/datafile/sgdc_finctrl.391.852664155';
set newname for datafile 00344 to '/oradata/dwth/datafile/odsview.392.852666209';
set newname for datafile 00345 to '/oradata/dwth/datafile/odsview.393.852668383';
set newname for datafile 00346 to '/oradata/dwth/datafile/sgdc_hryw_data.395.853187509';
set newname for datafile 00347 to '/oradata/dwth/datafile/tbs_sq_dt.396.853778881';
set newname for datafile 00348 to '/oradata/dwth/datafile/dssdat1.397.854381693';
set newname for datafile 00349 to '/oradata/dwth/datafile/dssdat1.398.854382441';
set newname for datafile 00350 to '/oradata/dwth/datafile/odsview.399.854385165';
set newname for datafile 00351 to '/oradata/dwth/datafile/dssdat1.400.855340119';
set newname for datafile 00352 to '/oradata/dwth/datafile/dssdat1.401.855340821';
set newname for datafile 00353 to '/oradata/dwth/datafile/dssdat1.402.855341239';
set newname for datafile 00354 to '/oradata/dwth/datafile/sgdc_hr_data.403.855341583';
set newname for datafile 00355 to '/oradata/dwth/datafile/sgdc_hr_data.404.855342507';
set newname for datafile 00356 to '/oradata/dwth/datafile/tbs_top_dt.405.855342935';
set newname for datafile 00357 to '/oradata/dwth/datafile/tbs_top_dt.406.855343181';
set newname for datafile 00358 to '/oradata/dwth/datafile/odsview.407.855343555';
set newname for datafile 00359 to '/oradata/dwth/datafile/odsview.408.855343807';
set newname for datafile 00360 to '/oradata/dwth/datafile/odsview.409.855344169';
set newname for datafile 00361 to '/oradata/dwth/datafile/ods_mm_mmods.410.855344747';
set newname for datafile 00362 to '/oradata/dwth/datafile/ods_mm_mmods.411.855345467';
set newname for datafile 00363 to '/oradata/dwth/datafile/sgdc_finctrl.412.855346583';
set newname for datafile 00364 to '/oradata/dwth/datafile/odsview.413.857502421';
set newname for datafile 00365 to '/oradata/dwth/datafile/odsview.414.857502541';
set newname for datafile 00366 to '/oradata/dwth/datafile/ts_cwgkblzc.415.857502741';
set newname for datafile 00367 to '/oradata/dwth/datafile/odsdxp.416.857502833';
set newname for datafile 00368 to '/oradata/dwth/datafile/dssdat1.417.857502957';
set newname for datafile 00369 to '/oradata/dwth/datafile/dssdat1.419.859198511';
set newname for datafile 00370 to '/oradata/dwth/datafile/dssdat1.418.859199201';
set newname for datafile 00371 to '/oradata/dwth/datafile/dssdat1.420.859199625';
set newname for datafile 00372 to '/oradata/dwth/datafile/dssdat1.421.859200701';
set newname for datafile 00373 to '/oradata/dwth/datafile/dssdat1.422.859200999';
set newname for datafile 00374 to '/oradata/dwth/datafile/tbs_sot_idx.423.859566319';
set newname for datafile 00375 to '/oradata/dwth/datafile/sg_cim.424.859908019';
set newname for datafile 00376 to '/oradata/dwth/datafile/imserpdata.425.860694381';
set newname for datafile 00377 to '/oradata/dwth/datafile/tbs_omcw_dt.3132.861458093';
set newname for datafile 00378 to '/oradata/dwth/datafile/sgdc_finctrl.426.861460169';
set newname for datafile 00379 to '/oradata/dwth/datafile/sgdc_finctrl.427.861461451';
set newname for datafile 00380 to '/oradata/dwth/datafile/sgdc_finctrl.428.861462625';
set newname for datafile 00381 to '/oradata/dwth/datafile/sgdc_finctrl.429.861465213';
set newname for datafile 00382 to '/oradata/dwth/datafile/odsview.430.861560429';
set newname for datafile 00383 to '/oradata/dwth/datafile/odsview.431.861560613';
set newname for datafile 00384 to '/oradata/dwth/datafile/odsview.432.861560907';
set newname for datafile 00385 to '/oradata/dwth/datafile/odsview.433.861561387';
set newname for datafile 00386 to '/oradata/dwth/datafile/odsview.434.861561551';
set newname for datafile 00387 to '/oradata/dwth/datafile/odsview.435.861613339';
set newname for datafile 00388 to '/oradata/dwth/datafile/odsview.436.861613839';
set newname for datafile 00389 to '/oradata/dwth/datafile/odsview.437.861615001';
set newname for datafile 00390 to '/oradata/dwth/datafile/ts_cwgkblzc.438.861615201';
set newname for datafile 00391 to '/oradata/dwth/datafile/odsview.439.861615411';
set newname for datafile 00392 to '/oradata/dwth/datafile/ts_cwgkblzc.440.861615685';
set newname for datafile 00393 to '/oradata/dwth/datafile/odsview.441.861615749';
set newname for datafile 00394 to '/oradata/dwth/datafile/dssdat1.442.861620547';
set newname for datafile 00395 to '/oradata/dwth/datafile/dssdat1.443.861621321';
set newname for datafile 00396 to '/oradata/dwth/datafile/dssdat1.444.861622517';
set newname for datafile 00397 to '/oradata/dwth/datafile/performance.445.862323735';
set newname for datafile 00398 to '/oradata/dwth/datafile/tbs_omcw_dt.1104.862429047';
set newname for datafile 00399 to '/oradata/dwth/datafile/sgdc_wz_data.446.862429197';
set newname for datafile 00400 to '/oradata/dwth/datafile/tech.447.862587827';
set newname for datafile 00401 to '/oradata/dwth/datafile/odsview.448.865591179';
set newname for datafile 00402 to '/oradata/dwth/datafile/odsview.449.865592303';
set newname for datafile 00403 to '/oradata/dwth/datafile/odsview.450.865593683';
set newname for datafile 00404 to '/oradata/dwth/datafile/odsview.451.865594783';
set newname for datafile 00405 to '/oradata/dwth/datafile/odsview.452.865596953';
set newname for datafile 00406 to '/oradata/dwth/datafile/odsview.453.865598687';
set newname for datafile 00407 to '/oradata/dwth/datafile/dssdat1.454.865598927';
set newname for datafile 00408 to '/oradata/dwth/datafile/odsview.455.865607383';
set newname for datafile 00409 to '/oradata/dwth/datafile/dssdat1.456.865607391';
set newname for datafile 00410 to '/oradata/dwth/datafile/odsview.457.865609015';
set newname for datafile 00411 to '/oradata/dwth/datafile/dssdat1.458.865609021';
set newname for datafile 00412 to '/oradata/dwth/datafile/odsview.459.865761983';
set newname for datafile 00413 to '/oradata/dwth/datafile/dssdat1.460.865761995';
set newname for datafile 00414 to '/oradata/dwth/datafile/dssdat1.461.865764117';
set newname for datafile 00415 to '/oradata/dwth/datafile/dssdat1.462.865764121';
set newname for datafile 00416 to '/oradata/dwth/datafile/dssdat1.463.865765341';
set newname for datafile 00417 to '/oradata/dwth/datafile/dssdat1.464.865765347';
set newname for datafile 00418 to '/oradata/dwth/datafile/dssdat1.465.865769709';
set newname for datafile 00419 to '/oradata/dwth/datafile/dssdat1.466.865769715';
set newname for datafile 00420 to '/oradata/dwth/datafile/dssdat1.467.865847197';
set newname for datafile 00421 to '/oradata/dwth/datafile/dssdat1.468.865847205';
set newname for datafile 00422 to '/oradata/dwth/datafile/odsview.469.865854249';
set newname for datafile 00423 to '/oradata/dwth/datafile/odsview.470.865856919';
set newname for datafile 00424 to '/oradata/dwth/datafile/odsview.471.865865757';
set newname for datafile 00425 to '/oradata/dwth/datafile/odsview.472.865890631';
set newname for datafile 00426 to '/oradata/dwth/datafile/odsview.473.865891749';
set newname for datafile 00427 to '/oradata/dwth/datafile/odsview.474.865901021';
set newname for datafile 00428 to '/oradata/dwth/datafile/odsview.475.865931433';
set newname for datafile 00429 to '/oradata/dwth/datafile/odsview.476.865934147';
set newname for datafile 00430 to '/oradata/dwth/datafile/odsview.477.865935185';
set newname for datafile 00431 to '/oradata/dwth/datafile/odsview.478.865951825';
set newname for datafile 00432 to '/oradata/dwth/datafile/sg_cim.479.868099419';
set newname for datafile 00433 to '/oradata/dwth/datafile/odsdxp.480.868111083';
set newname for datafile 00434 to '/oradata/dwth/datafile/ind_ts.268.868111233';
set newname for datafile 00435 to '/oradata/dwth/datafile/ind_ts.269.868113373';
set newname for datafile 00436 to '/oradata/dwth/datafile/sgdc_hryw_data.481.868554435';
set newname for datafile 00437 to '/oradata/dwth/datafile/tbs_calc_dt.482.868820583';
set newname for datafile 00438 to '/oradata/dwth/datafile/odsview.483.868821075';
set newname for datafile 00439 to '/oradata/dwth/datafile/odsview.484.868821315';
set newname for datafile 00440 to '/oradata/dwth/datafile/odsview.485.868821591';
set newname for datafile 00441 to '/oradata/dwth/datafile/odsview.486.868822061';
set newname for datafile 00442 to '/oradata/dwth/datafile/odsview.487.868822307';
set newname for datafile 00443 to '/oradata/dwth/datafile/tbs_omcw_dt.488.870702005';
set newname for datafile 00444 to '/oradata/dwth/datafile/ods_pms_data.489.871414351';
set newname for datafile 00445 to '/oradata/dwth/datafile/sgdc_hr_data.490.871415669';
set newname for datafile 00446 to '/oradata/dwth/datafile/ind_ts.491.874239045';
set newname for datafile 00447 to '/oradata/dwth/datafile/sgdc_hryw_data.492.876072895';
set newname for datafile 00448 to '/oradata/dwth/datafile/ind_ts.493.877604537';
set newname for datafile 00449 to '/oradata/dwth/datafile/odsdxp.494.877604591';
set newname for datafile 00450 to '/oradata/dwth/datafile/sgdc_mm_data.495.877604631';
set newname for datafile 00451 to '/oradata/dwth/datafile/odsview.496.877628025';
set newname for datafile 00452 to '/oradata/dwth/datafile/odsview.497.877628269';
set newname for datafile 00453 to '/oradata/dwth/datafile/odsview.498.877628685';
set newname for datafile 00454 to '/oradata/dwth/datafile/odsview.499.879617595';
set newname for datafile 00455 to '/oradata/dwth/datafile/odsview.500.879618343';
set newname for datafile 00456 to '/oradata/dwth/datafile/ind_ts.270.880055439';
set newname for datafile 00457 to '/oradata/dwth/datafile/sg_cim.501.880302661';
set newname for datafile 00458 to '/oradata/dwth/datafile/odsview.502.881513263';
set newname for datafile 00459 to '/oradata/dwth/datafile/odsview.503.881513839';
set newname for datafile 00460 to '/oradata/dwth/datafile/odsview.504.881514261';
set newname for datafile 00461 to '/oradata/dwth/datafile/tbs_omcw_idx.505.882700197';
set newname for datafile 00462 to '/oradata/dwth/datafile/ind_ts.506.882701009';
set newname for datafile 00463 to '/oradata/dwth/datafile/ts_cwgkblzc.507.882716651';
set newname for datafile 00464 to '/oradata/dwth/datafile/sgdc_wz_data.508.882717337';
set newname for datafile 00465 to '/oradata/dwth/datafile/ind_ts.509.883327661';
set newname for datafile 00466 to '/oradata/dwth/datafile/odsview.510.884100467';
set newname for datafile 00467 to '/oradata/dwth/datafile/odsview.511.884100967';
set newname for datafile 00468 to '/oradata/dwth/datafile/odsdxp.512.884101565';
set newname for datafile 00469 to '/oradata/dwth/datafile/odsdxp.513.884102153';
set newname for datafile 00470 to '/oradata/dwth/datafile/dssdat1.514.884102209';
set newname for datafile 00471 to '/oradata/dwth/datafile/dssdat1.515.884102427';
set newname for datafile 00472 to '/oradata/dwth/datafile/tbs_calc_dt.516.884102477';
set newname for datafile 00473 to '/oradata/dwth/datafile/odsdxp.517.884102519';
set newname for datafile 00474 to '/oradata/dwth/datafile/dssdat1.518.884537953';
set newname for datafile 00475 to '/oradata/dwth/datafile/dssdat1.519.884538531';
set newname for datafile 00476 to '/oradata/dwth/datafile/dssdat1.520.884586545';
set newname for datafile 00477 to '/oradata/dwth/datafile/dssdat1.521.884586981';
set newname for datafile 00478 to '/oradata/dwth/datafile/sgdc_hr_data.522.884587525';
set newname for datafile 00479 to '/oradata/dwth/datafile/sgdc_erp_data.523.884588147';
set newname for datafile 00480 to '/oradata/dwth/datafile/ts_cwgkblzc.524.884589655';
set newname for datafile 00481 to '/oradata/dwth/datafile/odsview.525.884591531';
set newname for datafile 00482 to '/oradata/dwth/datafile/ts_cwgkblzc.526.884611265';
set newname for datafile 00483 to '/oradata/dwth/datafile/ods_mdwzdp_data.527.886352195';
set newname for datafile 00484 to '/oradata/dwth/datafile/ods_mm_mmods.528.887398371';
set newname for datafile 00485 to '/oradata/dwth/datafile/ods_mm_mmods.529.887399163';
set newname for datafile 00486 to '/oradata/dwth/datafile/dssdat1.530.888332877';
set newname for datafile 00487 to '/oradata/dwth/datafile/dssdat1.531.888333273';
set newname for datafile 00488 to '/oradata/dwth/datafile/dssdat1.532.888333737';
set newname for datafile 00489 to '/oradata/dwth/datafile/sysaux.533.888694723';
set newname for datafile 00490 to '/oradata/dwth/datafile/dssdat1.534.889036625';
set newname for datafile 00491 to '/oradata/dwth/datafile/dssdat1.535.889037121';
set newname for datafile 00492 to '/oradata/dwth/datafile/dssdat1.536.889037597';
set newname for datafile 00493 to '/oradata/dwth/datafile/dssdat1.537.889038077';
set newname for datafile 00494 to '/oradata/dwth/datafile/dssdat1.538.889038345';
set newname for datafile 00495 to '/oradata/dwth/datafile/odsview.539.889804379';
set newname for datafile 00496 to '/oradata/dwth/datafile/odsview.540.889805051';
set newname for datafile 00497 to '/oradata/dwth/datafile/odsview.541.889805777';
set newname for datafile 00498 to '/oradata/dwth/datafile/odsview.542.889806743';
set newname for datafile 00499 to '/oradata/dwth/datafile/odsview.543.889807447';
set newname for datafile 00500 to '/oradata/dwth/datafile/odsview.544.889811037';
set newname for datafile 00501 to '/oradata/dwth/datafile/odsview.545.889875087';
set newname for datafile 00502 to '/oradata/dwth/datafile/odsview.546.889875447';
set newname for datafile 00503 to '/oradata/dwth/datafile/odsview.547.889875723';
set newname for datafile 00504 to '/oradata/dwth/datafile/dssdat1.548.890666871';
set newname for datafile 00505 to '/oradata/dwth/datafile/dssdat1.549.890667877';
set newname for datafile 00506 to '/oradata/dwth/datafile/dssdat1.550.890668469';
set newname for datafile 00507 to '/oradata/dwth/datafile/dssdat1.551.890670149';
set newname for datafile 00508 to '/oradata/dwth/datafile/odsview.552.890751985';
set newname for datafile 00509 to '/oradata/dwth/datafile/odsview.553.890753107';
set newname for datafile 00510 to '/oradata/dwth/datafile/odsview.554.890755025';
set newname for datafile 00511 to '/oradata/dwth/datafile/odsview.555.890756245';
set newname for datafile 00512 to '/oradata/dwth/datafile/odsview.556.890756979';
set newname for datafile 00513 to '/oradata/dwth/datafile/sg_cim.557.891364757';
set newname for datafile 00514 to '/oradata/dwth/datafile/sg_cim.558.891365217';
set newname for datafile 00515 to '/oradata/dwth/datafile/buf_mm_mmyw.561.892650701';
set newname for datafile 00516 to '/oradata/dwth/datafile/tbs_calc_dt.562.892651801';
set newname for datafile 00517 to '/oradata/dwth/datafile/dssdat1.563.892652745';
set newname for datafile 00518 to '/oradata/dwth/datafile/odsview.564.892655627';
set newname for datafile 00519 to '/oradata/dwth/datafile/ind_ts.565.892657133';
set newname for datafile 00520 to '/oradata/dwth/datafile/ind_ts.566.892658417';
set newname for datafile 00521 to '/oradata/dwth/datafile/odsview.567.893005381';
set newname for datafile 00522 to '/oradata/dwth/datafile/gwdbsjzx.568.895517029';
set newname for datafile 00523 to '/oradata/dwth/datafile/tbs_omcw_dt.569.896009269';
set newname for datafile 00524 to '/oradata/dwth/datafile/sg_eesmp.570.896112553';
set newname for datafile 00525 to '/oradata/dwth/datafile/sbjcirs.571.896112867';
set newname for datafile 00526 to '/oradata/dwth/datafile/ind_ts.271.897477505';
set newname for datafile 00527 to '/oradata/dwth/datafile/ts_share_hr.572.897487289';
set newname for datafile 00528 to '/oradata/dwth/datafile/ts_cwgkblzc.573.897497483';
set newname for datafile 00529 to '/oradata/dwth/datafile/ts_cwgkblzc.574.897497911';
set newname for datafile 00530 to '/oradata/dwth/datafile/ts_cwgkblzc.575.897498405';
set newname for datafile 00531 to '/oradata/dwth/datafile/odsview.577.897851559';
set newname for datafile 00532 to '/oradata/dwth/datafile/odsview.578.897851939';
set newname for datafile 00533 to '/oradata/dwth/datafile/sgdc_wz_data.579.897996301';
set newname for datafile 00534 to '/oradata/dwth/datafile/dssdat1.580.897997397';
set newname for datafile 00535 to '/oradata/dwth/datafile/dssdat1.581.897997867';
set newname for datafile 00536 to '/oradata/dwth/datafile/dssdat1.582.897998603';
set newname for datafile 00537 to '/oradata/dwth/datafile/dssdat1.583.898005707';
set newname for datafile 00538 to '/oradata/dwth/datafile/dssdat1.584.898006261';
set newname for datafile 00539 to '/oradata/dwth/datafile/odsview.585.898007505';
set newname for datafile 00540 to '/oradata/dwth/datafile/odsview.586.898008587';
set newname for datafile 00541 to '/oradata/dwth/datafile/ind_ts.272.898457201';
set newname for datafile 00542 to '/oradata/dwth/datafile/pmr_ods_data.588.898615047';
set newname for datafile 00543 to '/oradata/dwth/datafile/fxkz.589.898704873';
set newname for datafile 00544 to '/oradata/dwth/datafile/sg_ods_ldkb.590.898716611';
set newname for datafile 00545 to '/oradata/dwth/datafile/dzxltzdata.591.899634045';
set newname for datafile 00546 to '/oradata/dwth/datafile/odsdxp.592.899918045';
set newname for datafile 00547 to '/oradata/dwth/datafile/odsdxp.593.899918455';
set newname for datafile 00548 to '/oradata/dwth/datafile/precise.594.900588423';
set newname for datafile 00549 to '/oradata/dwth/datafile/tbs_omcw_dt.596.900945731';
set newname for datafile 00550 to '/oradata/dwth/datafile/tbs_omcw_dt.597.900946217';
set newname for datafile 00551 to '/oradata/dwth/datafile/tbs_omcw_dt.598.900946735';
set newname for datafile 00552 to '/oradata/dwth/datafile/undotbs2.599.901562713';
set newname for datafile 00553 to '/oradata/dwth/datafile/undotbs1.600.901563477';
set newname for datafile 00554 to '/oradata/dwth/datafile/ts_share_hr.601.901637873';
set newname for datafile 00555 to '/oradata/dwth/datafile/ts_share_hr.602.901638407';
set newname for datafile 00556 to '/oradata/dwth/datafile/sgdcdata.603.901638945';
set newname for datafile 00557 to '/oradata/dwth/datafile/ods_mm_mmods.604.901639901';
set newname for datafile 00558 to '/oradata/dwth/datafile/undotbs1.605.901640659';
set newname for datafile 00559 to '/oradata/dwth/datafile/undotbs1.606.901641749';
set newname for datafile 00560 to '/oradata/dwth/datafile/odsview.607.901816267';
set newname for datafile 00561 to '/oradata/dwth/datafile/odsview.608.901816909';
set newname for datafile 00562 to '/oradata/dwth/datafile/odsview.609.901817439';
set newname for datafile 00563 to '/oradata/dwth/datafile/odsview.610.901818169';
set newname for datafile 00564 to '/oradata/dwth/datafile/odsdxp.611.902671781';
set newname for datafile 00565 to '/oradata/dwth/datafile/tbs_mon_dt.612.902672279';
set newname for datafile 00566 to '/oradata/dwth/datafile/tbs_mon_dt.613.902672585';
set newname for datafile 00567 to '/oradata/dwth/datafile/sg_ythxs.614.902940669';
set newname for datafile 00568 to '/oradata/dwth/datafile/odsview.615.904058967';
set newname for datafile 00569 to '/oradata/dwth/datafile/odsview.616.904059593';
set newname for datafile 00570 to '/oradata/dwth/datafile/odsview.617.904060311';
set newname for datafile 00571 to '/oradata/dwth/datafile/odsview.618.904060985';
set newname for datafile 00572 to '/oradata/dwth/datafile/odsview.619.904061629';
set newname for datafile 00573 to '/oradata/dwth/datafile/odsview.620.904061999';
set newname for datafile 00574 to '/oradata/dwth/datafile/odsdxp.621.904225663';
set newname for datafile 00575 to '/oradata/dwth/datafile/odsdxp.622.904226125';
set newname for datafile 00576 to '/oradata/dwth/datafile/odsdxp.623.904227025';
set newname for datafile 00577 to '/oradata/dwth/datafile/odsview.624.906043057';
set newname for datafile 00578 to '/oradata/dwth/datafile/odsview.625.906043375';
set newname for datafile 00579 to '/oradata/dwth/datafile/odsview.626.906043597';
set newname for datafile 00580 to '/oradata/dwth/datafile/odsdxp_idx.627.906558581';
set newname for datafile 00581 to '/oradata/dwth/datafile/ind_ts.273.907164715';
set newname for datafile 00582 to '/oradata/dwth/datafile/odsdxp.628.908378639';
set newname for datafile 00583 to '/oradata/dwth/datafile/odsdxp.629.908378885';
set newname for datafile 00584 to '/oradata/dwth/datafile/odsdxp.630.908379455';
set newname for datafile 00585 to '/oradata/dwth/datafile/lcam_ods_zcqsm.631.910281871';
set newname for datafile 00586 to '/oradata/dwth/datafile/odsdxp.632.910285249';
set newname for datafile 00587 to '/oradata/dwth/datafile/odsdxp.633.910285685';
set newname for datafile 00588 to '/oradata/dwth/datafile/odsdxp.634.910285997';
set newname for datafile 00589 to '/oradata/dwth/datafile/odsdxp.635.910286367';
set newname for datafile 00590 to '/oradata/dwth/datafile/tbs_jjfl.636.911411773';
set newname for datafile 00591 to '/oradata/dwth/datafile/odsview.637.912700605';
set newname for datafile 00592 to '/oradata/dwth/datafile/odsview.638.912701287';
set newname for datafile 00593 to '/oradata/dwth/datafile/odsview.639.912702221';
set newname for datafile 00594 to '/oradata/dwth/datafile/odsview.640.912702749';
set newname for datafile 00595 to '/oradata/dwth/datafile/ods_mm_mmods.641.912703469';
set newname for datafile 00596 to '/oradata/dwth/datafile/ods_mm_mmods.642.912704493';
set newname for datafile 00597 to '/oradata/dwth/datafile/ods_mm_mmods.643.912705509';
set newname for datafile 00598 to '/oradata/dwth/datafile/odsdxp.644.912797687';
set newname for datafile 00599 to '/oradata/dwth/datafile/odsdxp.645.912797933';
set newname for datafile 00600 to '/oradata/dwth/datafile/pmr_ods_data.646.914518849';
set newname for datafile 00601 to '/oradata/dwth/datafile/sgdc_wz_data.647.915125909';
set newname for datafile 00602 to '/oradata/dwth/datafile/sgdc_wz_data.648.915126147';
set newname for datafile 00603 to '/oradata/dwth/datafile/sgdc_wz_data.649.915126353';
set newname for datafile 00604 to '/oradata/dwth/datafile/jzbs_cwgkbzlc.650.915806357';
set newname for datafile 00605 to '/oradata/dwth/datafile/sgdc_mm_data.651.916165213';
set newname for datafile 00606 to '/oradata/dwth/datafile/sgdcdata.652.916167397';
set newname for datafile 00607 to '/oradata/dwth/datafile/ind_ts.274.916171795';
set newname for datafile 00608 to '/oradata/dwth/datafile/ind_ts.653.916172121';
set newname for datafile 00609 to '/oradata/dwth/datafile/ind_ts.654.916172629';
set newname for datafile 00610 to '/oradata/dwth/datafile/ind_ts.655.916172945';
set newname for datafile 00611 to '/oradata/dwth/datafile/odsview.656.916173565';
set newname for datafile 00612 to '/oradata/dwth/datafile/odsview.657.916173975';
set newname for datafile 00613 to '/oradata/dwth/datafile/odsview.658.916174421';
set newname for datafile 00614 to '/oradata/dwth/datafile/odsview.659.916179157';
set newname for datafile 00615 to '/oradata/dwth/datafile/odsview.660.916179657';
set newname for datafile 00616 to '/oradata/dwth/datafile/odsview.661.916179953';
set newname for datafile 00617 to '/oradata/dwth/datafile/odsview.662.916180255';
set newname for datafile 00618 to '/oradata/dwth/datafile/odsview.663.916180589';
set newname for datafile 00619 to '/oradata/dwth/datafile/odsview.664.916180985';
set newname for datafile 00620 to '/oradata/dwth/datafile/odsview.665.916181419';
set newname for datafile 00621 to '/oradata/dwth/datafile/odsview.666.916181789';
set newname for datafile 00622 to '/oradata/dwth/datafile/odsview.667.916182403';
set newname for datafile 00623 to '/oradata/dwth/datafile/tbs_mon_dt.668.916586641';
set newname for datafile 00624 to '/oradata/dwth/datafile/tbs_omcw_dt.669.916587671';
set newname for datafile 00625 to '/oradata/dwth/datafile/tbs_omcw_dt.670.916588135';
set newname for datafile 00626 to '/oradata/dwth/datafile/tbs_omcw_dt.671.916588709';
set newname for datafile 00627 to '/oradata/dwth/datafile/sgdcdata.672.916589917';
set newname for datafile 00628 to '/oradata/dwth/datafile/sgdcdata.673.916592039';
set newname for datafile 00629 to '/oradata/dwth/datafile/tbs_sot_dt.674.916964937';
set newname for datafile 00630 to '/oradata/dwth/datafile/odsview.675.918143803';
set newname for datafile 00631 to '/oradata/dwth/datafile/pmr_ods_data.677.918145075';
set newname for datafile 00632 to '/oradata/dwth/datafile/sg_mdm.678.918145609';
set newname for datafile 00633 to '/oradata/dwth/datafile/odsview.676.918144999';
set newname for datafile 00634 to '/oradata/dwth/datafile/sgdc_mm_data.679.918146057';
set newname for datafile 00635 to '/oradata/dwth/datafile/odsview.680.918146209';
set newname for datafile 00636 to '/oradata/dwth/datafile/sgdcdata.682.918147053';
set newname for datafile 00637 to '/oradata/dwth/datafile/ts_cwgkblzc.681.918146621';
set newname for datafile 00638 to '/oradata/dwth/datafile/odsview.683.918147787';
set newname for datafile 00639 to '/oradata/dwth/datafile/ods_mm_mmods.685.918148403';
set newname for datafile 00640 to '/oradata/dwth/datafile/ind_ts.684.918148301';
set newname for datafile 00641 to '/oradata/dwth/datafile/ind_ts.686.918149819';
set newname for datafile 00642 to '/oradata/dwth/datafile/ts_cwgkblzc.687.918150065';
set newname for datafile 00643 to '/oradata/dwth/datafile/ods_mm_mmods.688.918150171';
set newname for datafile 00644 to '/oradata/dwth/datafile/dssdat1.689.918150319';
set newname for datafile 00645 to '/oradata/dwth/datafile/dssdat1.690.918150423';
set newname for datafile 00646 to '/oradata/dwth/datafile/ods_mm_mmods.691.918151709';
set newname for datafile 00647 to '/oradata/dwth/datafile/dssdat1.692.918152231';
set newname for datafile 00648 to '/oradata/dwth/datafile/ts_cwgkblzc.693.918152367';
set newname for datafile 00649 to '/oradata/dwth/datafile/sgdcdata.695.918226693';
set newname for datafile 00650 to '/oradata/dwth/datafile/dssdat1.694.918226487';
set newname for datafile 00651 to '/oradata/dwth/datafile/odsview.696.918226843';
set newname for datafile 00652 to '/oradata/dwth/datafile/undotbs2.697.918227683';
set newname for datafile 00653 to '/oradata/dwth/datafile/dssdat1.698.918227815';
set newname for datafile 00654 to '/oradata/dwth/datafile/ts_cwgkblzc.699.918228049';
set newname for datafile 00655 to '/oradata/dwth/datafile/odsview.700.918228655';
set newname for datafile 00656 to '/oradata/dwth/datafile/ods_mm_mmods.701.918228973';
set newname for datafile 00657 to '/oradata/dwth/datafile/dssdat1.702.918229167';
set newname for datafile 00658 to '/oradata/dwth/datafile/odsview.703.918229461';
set newname for datafile 00659 to '/oradata/dwth/datafile/dssdat1.704.918230087';
set newname for datafile 00660 to '/oradata/dwth/datafile/odsview.705.918230267';
set newname for datafile 00661 to '/oradata/dwth/datafile/dssdat1.706.918230349';
set newname for datafile 00662 to '/oradata/dwth/datafile/odsview.707.918230463';
set newname for datafile 00663 to '/oradata/dwth/datafile/odsview.708.918231581';
set newname for datafile 00664 to '/oradata/dwth/datafile/odsview.709.918232343';
set newname for datafile 00665 to '/oradata/dwth/datafile/odsview.710.918232557';
set newname for datafile 00666 to '/oradata/dwth/datafile/dssdat1.711.918232631';
set newname for datafile 00667 to '/oradata/dwth/datafile/odsview.712.918232891';
set newname for datafile 00668 to '/oradata/dwth/datafile/odsview.713.918233343';
set newname for datafile 00669 to '/oradata/dwth/datafile/odsview.714.918233775';
set newname for datafile 00670 to '/oradata/dwth/datafile/odsview.715.918234155';
set newname for datafile 00671 to '/oradata/dwth/datafile/odsview.716.918234293';
set newname for datafile 00672 to '/oradata/dwth/datafile/odsview.717.918234603';
set newname for datafile 00673 to '/oradata/dwth/datafile/odsview.718.918235613';
set newname for datafile 00674 to '/oradata/dwth/datafile/odsview.719.918235651';
set newname for datafile 00675 to '/oradata/dwth/datafile/odsview.720.918235737';
set newname for datafile 00676 to '/oradata/dwth/datafile/odsview.721.918297559';
set newname for datafile 00677 to '/oradata/dwth/datafile/undotbs2.722.918298215';
set newname for datafile 00678 to '/oradata/dwth/datafile/undotbs1.723.918299071';
set newname for datafile 00679 to '/oradata/dwth/datafile/undotbs2.724.922037961';
set newname for datafile 00680 to '/oradata/dwth/datafile/undotbs2.725.922039971';
set newname for datafile 00681 to '/oradata/dwth/datafile/undotbs1.726.922040195';
set newname for datafile 00682 to '/oradata/dwth/datafile/undotbs1.727.922040395';
set newname for datafile 00683 to '/oradata/dwth/datafile/undotbs1.728.922040597';
set newname for datafile 00684 to '/oradata/dwth/datafile/sgdcdata.729.922110679';
set newname for datafile 00685 to '/oradata/dwth/datafile/ind_ts.730.922111027';
set newname for datafile 00686 to '/oradata/dwth/datafile/ind_ts.731.922111413';
set newname for datafile 00687 to '/oradata/dwth/datafile/odsview.732.922111813';
set newname for datafile 00688 to '/oradata/dwth/datafile/odsview.733.922112429';
set newname for datafile 00689 to '/oradata/dwth/datafile/odsview.734.922113501';
set newname for datafile 00690 to '/oradata/dwth/datafile/odsview.735.922114079';
set newname for datafile 00691 to '/oradata/dwth/datafile/sg_cim.736.922115493';
restore database;
switch datafile all;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}
exit;
EOF

从NBU转储归档日志：

export ORACLE_SID=DWTH
rman target / <<EOF
run {
allocate channel c1 type 'sbt_tape';
allocate channel c2 type 'sbt_tape';
allocate channel c3 type 'sbt_tape';
allocate channel c4 type 'sbt_tape';
SEND 'NB_ORA_SERV=NBU-MEDIA2,NB_ORA_CLIENT=ods2';
restore archivelog  SCN between 14839448778789 and 14845354130546;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}
exit;
EOF

执行恢复操作：

recover database until cancel;
如果报RMAN-06025，则可使用catalog start with ‘?/arch’或在sqlplus中使用以下命令
alter system recover database until cancel;

启动数据库

alter database open resetlogs;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29802484/viewspace-2126997/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29802484/viewspace-2126997/