1.编辑spfile
略
2.恢复控制文件
run 
{
allocate channel ch00 type 'SBT_TAPE' ;
SEND 'NB_ORA_CLIENT=xx,NB_ORA_SERV=nbumaster,NB_ORA_POLICY=xx,NB_ORA_SCHED=default-ERP';   
restore controlfile from  'c-3984149248-20170126-02';
release channel ch00;
}


3.restore 数据文件



run
{
allocate channel ch00 type 'SBT_TAPE';
allocate channel ch01 type 'SBT_TAPE';
allocate channel ch02 type 'SBT_TAPE';
allocate channel ch03 type 'SBT_TAPE';
allocate channel ch04 type 'SBT_TAPE';
allocate channel ch05 type 'SBT_TAPE';
allocate channel ch06 type 'SBT_TAPE';
allocate channel ch07 type 'SBT_TAPE';
allocate channel ch08 type 'SBT_TAPE';
allocate channel ch09 type 'SBT_TAPE';
allocate channel ch10 type 'SBT_TAPE';
allocate channel ch11 type 'SBT_TAPE';
allocate channel ch12 type 'SBT_TAPE';
allocate channel ch13 type 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=xxxx,NB_ORA_SERV=nbumaster,NB_ORA_POLICY=xx,NB_ORA_SCHED=default-ERP';    
set newname for datafile  70 to '/u01/app/oracle/admin/jcerpcb/datafile/arch_index.399.838851711';
set newname for datafile  4 to '/u01/app/oracle/admin/jcerpcb/datafile/users.432.838851717';
set newname for datafile  3 to '/u01/app/oracle/admin/jcerpcb/datafile/undotbs1.727.838851691';
set newname for datafile  2 to '/u01/app/oracle/admin/jcerpcb/datafile/sysaux.338.838851691';
set newname for datafile  1 to '/u01/app/oracle/admin/jcerpcb/datafile/system.426.838851715';
set newname for datafile  5 to '/u01/app/oracle/admin/jcerpcb/datafile/undotbs2.729.838851691';
set newname for datafile  6 to '/u01/app/oracle/admin/jcerpcb/datafile/undotbs3.733.838851689';
set newname for datafile  7 to '/u01/app/oracle/admin/jcerpcb/datafile/undotbs4.732.838851689';
set newname for datafile  71 to '/u01/app/oracle/admin/jcerpcb/datafile/undotbs4.391.838851709';
set newname for datafile  72 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.405.838851711';
set newname for datafile  73 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.396.838851711';
set newname for datafile  74 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.400.838851711';
set newname for datafile  75 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.395.838851711';
set newname for datafile  76 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.393.838851711';
set newname for datafile  8 to '/u01/app/oracle/admin/jcerpcb/datafile/sysaux.336.838851691';
set newname for datafile  9 to '/u01/app/oracle/admin/jcerpcb/datafile/undotbs1.726.838851691';
set newname for datafile  10 to '/u01/app/oracle/admin/jcerpcb/datafile/undotbs2.334.838851691';
set newname for datafile  11 to '/u01/app/oracle/admin/jcerpcb/datafile/undotbs3.731.838851689';
set newname for datafile  12 to '/u01/app/oracle/admin/jcerpcb/datafile/undotbs4.730.838851691';
set newname for datafile  13 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.337.838851691';
set newname for datafile  14 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.333.838851691';
set newname for datafile  15 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.335.838851691';
set newname for datafile  16 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.347.838851691';
set newname for datafile  17 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.728.838851691';
set newname for datafile  18 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.328.838851695';
set newname for datafile  19 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.355.838851693';
set newname for datafile  20 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.354.838851693';
set newname for datafile  21 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.339.838851693';
set newname for datafile  22 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.359.838851695';
set newname for datafile  23 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.357.838851693';
set newname for datafile  24 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.360.838851695';
set newname for datafile  25 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.315.838851693';
set newname for datafile  26 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.362.838851695';
set newname for datafile  27 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.361.838851695';
set newname for datafile  28 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.325.838851695';
set newname for datafile  29 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.358.838851695';
set newname for datafile  30 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.356.838851693';
set newname for datafile  31 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.317.838851693';
set newname for datafile  32 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.316.838851693';
set newname for datafile  33 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.351.838851697';
set newname for datafile  34 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.318.838851697';
set newname for datafile  35 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.323.838851697';
set newname for datafile  36 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.327.838851695';
set newname for datafile  37 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.348.838851697';
set newname for datafile  38 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.465.838851697';
set newname for datafile  39 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.466.838851697';
set newname for datafile  40 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.324.838851697';
set newname for datafile  41 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.349.838851697';
set newname for datafile  42 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.468.838851697';
set newname for datafile  43 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.350.838851697';
set newname for datafile  44 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.467.838851697';
set newname for datafile  45 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.464.838851697';
set newname for datafile  46 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.321.838851695';
set newname for datafile  47 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.320.838851697';
set newname for datafile  48 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.387.838851707';
set newname for datafile  49 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.375.838851707';
set newname for datafile  50 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.373.838851707';
set newname for datafile  51 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.352.838851707';
set newname for datafile  52 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.379.838851707';
set newname for datafile  53 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.376.838851707';
set newname for datafile  54 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.378.838851707';
set newname for datafile  55 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.372.838851707';
set newname for datafile  56 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.380.838851707';
set newname for datafile  57 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.381.838851707';
set newname for datafile  58 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.386.838851707';
set newname for datafile  59 to '/u01/app/oracle/admin/jcerpcb/datafile/arch_data.377.838851707';
set newname for datafile  60 to '/u01/app/oracle/admin/jcerpcb/datafile/arch_data.374.838851707';
set newname for datafile  61 to '/u01/app/oracle/admin/jcerpcb/datafile/arch_data.353.838851707';
set newname for datafile  62 to '/u01/app/oracle/admin/jcerpcb/datafile/arch_index.371.838851707';
set newname for datafile  63 to '/u01/app/oracle/admin/jcerpcb/datafile/arch_index.406.838851711';
set newname for datafile  64 to '/u01/app/oracle/admin/jcerpcb/datafile/arch_index.394.838851711';
set newname for datafile  65 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data_his.392.838851709';
set newname for datafile  66 to '/u01/app/oracle/admin/jcerpcb/datafile/plan_tablespace.388.838851709';
set newname for datafile  67 to '/u01/app/oracle/admin/jcerpcb/datafile/report.397.838851711';
set newname for datafile  68 to '/u01/app/oracle/admin/jcerpcb/datafile/report.398.838851711';
set newname for datafile  69 to '/u01/app/oracle/admin/jcerpcb/datafile/tbs_streams.433.838851717';
set newname for datafile  77 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.389.838851709';
set newname for datafile  78 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.390.838851709';
set newname for datafile  79 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.419.838851713';
set newname for datafile  80 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.413.838851713';
set newname for datafile  81 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.411.838851713';
set newname for datafile  82 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.408.838851713';
set newname for datafile  83 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.414.838851713';
set newname for datafile  84 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.418.838851713';
set newname for datafile  85 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.415.838851713';
set newname for datafile  86 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.410.838851713';
set newname for datafile  87 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.424.838851713';
set newname for datafile  88 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.420.838851713';
set newname for datafile  89 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.417.838851713';
set newname for datafile  90 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.416.838851713';
set newname for datafile  91 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.412.838851713';
set newname for datafile  92 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.409.838851713';
set newname for datafile  93 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.407.838851713';
set newname for datafile  94 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.428.838851715';
set newname for datafile  95 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.427.838851715';
set newname for datafile  96 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.425.838851715';
set newname for datafile  97 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.430.838851717';
set newname for datafile  98 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.431.838851717';
set newname for datafile  99 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.429.838851717';
set newname for datafile  167 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data01.dbf';
set newname for datafile  100 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.1465.841699023';
set newname for datafile  101 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.1460.841699029';
set newname for datafile  102 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1426.843300053';
set newname for datafile  103 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1421.843300059';
set newname for datafile  104 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1424.843300063';
set newname for datafile  105 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1423.843300083';
set newname for datafile  106 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1419.843300089';
set newname for datafile  107 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1416.843300093';
set newname for datafile  108 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.1420.843300121';
set newname for datafile  109 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.1415.843300127';
set newname for datafile  110 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.1418.843300131';
set newname for datafile  111 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.1417.843300157';
set newname for datafile  112 to '/u01/app/oracle/admin/jcerpcb/datafile/arch_index.1413.843300209';
set newname for datafile  113 to '/u01/app/oracle/admin/jcerpcb/datafile/patrol_data.1397.848140865';
set newname for datafile  114 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.1363.849339971';
set newname for datafile  115 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.1367.849339977';
set newname for datafile  116 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.1362.849340001';
set newname for datafile  117 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.1365.849340007';
set newname for datafile  118 to '/u01/app/oracle/admin/jcerpcb/datafile/arch_index.1364.849340041';
set newname for datafile  119 to '/u01/app/oracle/admin/jcerpcb/datafile/arch_index.1360.849340045';
set newname for datafile  120 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1357.849340099';
set newname for datafile  121 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1361.849340105';
set newname for datafile  122 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1356.849340113';
set newname for datafile  123 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1359.849340117';
set newname for datafile  124 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1358.849340133';
set newname for datafile  125 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1354.849340137';
set newname for datafile  126 to '/u01/app/oracle/admin/jcerpcb/datafile/tbs_streams.1297.853599689';
set newname for datafile  127 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.1301.853600653';
set newname for datafile  128 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.1296.853600659';
set newname for datafile  129 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1299.853600717';
set newname for datafile  130 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1298.853600721';
set newname for datafile  131 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1294.853600745';
set newname for datafile  132 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.1291.855646889';
set newname for datafile  133 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.1295.855646893';
set newname for datafile  134 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.1290.855646909';
set newname for datafile  135 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.1293.855646915';
set newname for datafile  136 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1292.855646923';
set newname for datafile  137 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1288.855646927';
set newname for datafile  138 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1285.855646949';
set newname for datafile  139 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1180.857201793';
set newname for datafile  140 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1176.857201799';
set newname for datafile  141 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.1156.858682617';
set newname for datafile  142 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.1152.858682621';
set newname for datafile  143 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1151.858682625';
set newname for datafile  144 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1155.858682631';
set newname for datafile  145 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1154.858682645';
set newname for datafile  146 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1153.858682649';
set newname for datafile  147 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.1086.861884359';
set newname for datafile  148 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.1084.861884367';
set newname for datafile  149 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.1089.861884373';
set newname for datafile  150 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.1091.861884381';
set newname for datafile  151 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1092.861884425';
set newname for datafile  152 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1087.861884433';
set newname for datafile  153 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1088.861884439';
set newname for datafile  154 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1095.861884445';
set newname for datafile  155 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1099.861884451';
set newname for datafile  156 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.1777.865332953';
set newname for datafile  157 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.1771.865332959';
set newname for datafile  158 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1768.865333025';
set newname for datafile  159 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.2787.869569233';
set newname for datafile  160 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.2763.869569239';
set newname for datafile  161 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.2723.869569273';
set newname for datafile  162 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.2835.869569315';
set newname for datafile  163 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.2732.869569321';
set newname for datafile  164 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.2754.869569325';
set newname for datafile  165 to '/u01/app/oracle/admin/jcerpcb/datafile/report.2827.873297365';
set newname for datafile  166 to '/u01/app/oracle/admin/jcerpcb/datafile/report.2744.873297371';
set newname for datafile  168 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data02.dbf';
set newname for datafile  169 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data03.dbf';
set newname for datafile  170 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data04.dbf';
set newname for datafile  171 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data05.dbf';
set newname for datafile  172 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data06.dbf';
set newname for datafile  173 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data07.dbf';
set newname for datafile  174 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data08.dbf';
set newname for datafile  175 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data09.dbf';
set newname for datafile  176 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data10.dbf';
set newname for datafile  177 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index01.dbf';
set newname for datafile  178 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index02.dbf';
set newname for datafile  179 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index03.dbf';
set newname for datafile  180 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index04.dbf';
set newname for datafile  181 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index05.dbf';
set newname for datafile  182 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index06.dbf';
set newname for datafile  183 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index07.dbf';
set newname for datafile  184 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index08.dbf';
set newname for datafile  185 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data11.dbf';
set newname for datafile  186 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data12.dbf';
set newname for datafile  187 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data13.dbf';
set newname for datafile  188 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data14.dbf';
set newname for datafile  189 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index09.dbf';
set newname for datafile  190 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index10.dbf';
set newname for datafile  191 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index11.dbf';
set newname for datafile  192 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index12.dbf';
set newname for datafile  193 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index13.dbf';
set newname for datafile  194 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index14.dbf';
set newname for datafile  195 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index15.dbf';
set newname for datafile  196 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data15.dbf';
set newname for datafile  197 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data16.dbf';
set newname for datafile  198 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data17.dbf';
set newname for datafile  199 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data18.dbf';
set newname for datafile  200 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data19.dbf';
set newname for datafile  201 to '/u01/app/oracle/admin/jcerpcb/datafile/system02.dbf';
set newname for datafile  202 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data20.dbf';
set newname for datafile  203 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data21.dbf';
set newname for datafile  204 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data22.dbf';
set newname for datafile  205 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data23.dbf';
set newname for datafile  206 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data24.dbf';
set newname for datafile  207 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index16.dbf';
set newname for datafile  208 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index17.dbf';
set newname for datafile  209 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index18.dbf';
set newname for datafile  210 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index19.dbf';
set newname for datafile  211 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index20.dbf';
set newname for datafile  212 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data25.dbf';
set newname for datafile  213 to '/u01/app/oracle/admin/jcerpcb/datafile/report.1286.911482317';
set newname for datafile  214 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data26.dbf';
set newname for datafile  215 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data27.dbf';
set newname for datafile  216 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data28.dbf';
set newname for datafile  217 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data29.dbf';
set newname for datafile  218 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data30.dbf';
set newname for datafile  219 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data31.dbf';
set newname for datafile  220 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data32.dbf';
set newname for datafile  221 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data33.dbf';
set newname for datafile  222 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data34.dbf';
set newname for datafile  223 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data35.dbf';
set newname for datafile  224 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data36.dbf';
set newname for datafile  225 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data37.dbf';
set newname for datafile  226 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data38.dbf';
set newname for datafile  227 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data39.dbf';
set newname for datafile  228 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data40.dbf';
set newname for datafile  229 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data41.dbf';
set newname for datafile  230 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index21.dbf';
set newname for datafile  231 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index22.dbf';
set newname for datafile  232 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index23.dbf';
set newname for datafile  233 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index24.dbf';
set newname for datafile  234 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index25.dbf';
set newname for datafile  235 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.3268.928078451';
set newname for datafile  236 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.3265.928078475';
set newname for datafile  237 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.3226.928078489';
set newname for datafile  238 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.3221.928078495';
set newname for datafile  239 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.3232.928078503';
set newname for datafile  240 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.1321.928078507';
set newname for datafile  241 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.1317.928078519';
set newname for datafile  242 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.3247.928078527';
set newname for datafile  243 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.1319.928078533';
set newname for datafile  244 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.3253.928078539';
set newname for datafile  245 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.3380.928078549';
set newname for datafile  246 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.3399.928078555';
set newname for datafile  247 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.3407.928078561';
set newname for datafile  248 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.3403.928078567';
set newname for datafile  249 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.3402.928078575';
set newname for datafile  250 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.3408.928078581';
set newname for datafile  251 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.3406.928078591';
set newname for datafile  252 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.3401.928078595';
set newname for datafile  253 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.3404.928078603';
set newname for datafile  254 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.3410.928078609';
set newname for datafile  255 to '/u01/app/oracle/admin/jcerpcb/datafile/system.2745.928492359';
set newname for datafile  256 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.3328.931948969';
set newname for datafile  257 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.3306.931949013';
set newname for datafile  258 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.3302.931949019';
set newname for datafile  259 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.3296.933412471';
set newname for datafile  260 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.3271.934193043';
set newname for datafile  261 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.3278.934193077';
set newname for datafile  262 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.3275.934193083';
set newname for datafile  263 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.3325.934193089';
set newname for datafile  264 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.3322.934193095';
set newname for datafile  265 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.3326.934193123';
set newname for datafile  266 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_data.3359.934193129';
set newname for datafile  267 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.3347.934193161';
set newname for datafile  268 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.3354.934193183';
set newname for datafile  269 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.2958.934193189';
set newname for datafile  270 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.2963.934193195';
set newname for datafile  271 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.2974.934193201';
set newname for datafile  272 to '/u01/app/oracle/admin/jcerpcb/datafile/erp_index.3270.934193207';
restore database until time "TO_DATE('2017-01-26 12:00:00','YYYY-MM-DD HH24:MI:SS')"; 
switch datafile all;
release channel ch00;
release channel ch01;
release channel ch02;
release channel ch03;
release channel ch04;
release channel ch05;
release channel ch06;
release channel ch07;
release channel ch08;
release channel ch09;
release channel ch10;
release channel ch11;
release channel ch12;
release channel ch13;
}



3.recover 数据库

run
{
allocate channel ch00 type 'SBT_TAPE';
allocate channel ch01 type 'SBT_TAPE';
allocate channel ch02 type 'SBT_TAPE';
allocate channel ch03 type 'SBT_TAPE';
allocate channel ch04 type 'SBT_TAPE';
allocate channel ch05 type 'SBT_TAPE';
allocate channel ch06 type 'SBT_TAPE';
allocate channel ch07 type 'SBT_TAPE';
allocate channel ch08 type 'SBT_TAPE';
allocate channel ch09 type 'SBT_TAPE';
allocate channel ch10 type 'SBT_TAPE';
allocate channel ch11 type 'SBT_TAPE';
allocate channel ch12 type 'SBT_TAPE';
allocate channel ch13 type 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=xxx,NB_ORA_SERV=nbumaster,NB_ORA_POLICY=xx,NB_ORA_SCHED=default-ERP';    
recover database until time "TO_DATE('2017-01-26 12:00:00','YYYY-MM-DD HH24:MI:SS')"; 
release channel ch00;
release channel ch01;
release channel ch02;
release channel ch03;
release channel ch04;
release channel ch05;
release channel ch06;
release channel ch07;
release channel ch08;
release channel ch09;
release channel ch10;
release channel ch11;
release channel ch12;
release channel ch13;
}




4.rename    redo,standby log
略

5.open resetlogs