oracle不同版本恢复

原创

yuanbonet 2013-03-01 16:55:27 ©著作权

文章标签 oracle 文章分类 Oracle 数据库

©著作权归作者所有：来自51CTO博客作者yuanbonet的原创作品，请联系作者获取转载授权，否则将追究法律责任

mv /oracle/R3P/backup/backup/bekpmoue/sr3.data1 /oracle/R3P/sapdata2/sr3_1/sr3.data1
mv /oracle/R3P/backup/backup/bekpmoue/sr3.data10 /oracle/R3P/sapdata2/sr3_10/sr3.data10
mv /oracle/R3P/backup/backup/bekpmoue/sr3.data11 /oracle/R3P/sapdata2/sr3_11/sr3.data11
mv /oracle/R3P/backup/backup/bekpmoue/sr3.data12 /oracle/R3P/sapdata2/sr3_12/sr3.data12
mv /oracle/R3P/backup/backup/bekpmoue/sr3.data13 /oracle/R3P/sapdata2/sr3_13/sr3.data13
mv /oracle/R3P/backup/backup/bekpmoue/sr3.data14 /oracle/R3P/sapdata2/sr3_14/sr3.data14
mv /oracle/R3P/backup/backup/bekpmoue/sr3.data15 /oracle/R3P/sapdata2/sr3_15/sr3.data15
mv /oracle/R3P/backup/backup/bekpmoue/sr3.data16 /oracle/R3P/sapdata2/sr3_16/sr3.data16
mv /oracle/R3P/backup/backup/bekpmoue/sr3.data2 /oracle/R3P/sapdata2/sr3_2/sr3.data2
mv /oracle/R3P/backup/backup/bekpmoue/sr3.data3 /oracle/R3P/sapdata2/sr3_3/sr3.data3
mv /oracle/R3P/backup/backup/bekpmoue/sr3.data4 /oracle/R3P/sapdata2/sr3_4/sr3.data4
mv /oracle/R3P/backup/backup/bekpmoue/sr3.data5 /oracle/R3P/sapdata2/sr3_5/sr3.data5
mv /oracle/R3P/backup/backup/bekpmoue/sr3.data6 /oracle/R3P/sapdata2/sr3_6/sr3.data6
mv /oracle/R3P/backup/backup/bekpmoue/sr3.data7 /oracle/R3P/sapdata2/sr3_7/sr3.data7
mv /oracle/R3P/backup/backup/bekpmoue/sr3.data8 /oracle/R3P/sapdata2/sr3_8/sr3.data8
mv /oracle/R3P/backup/backup/bekpmoue/sr3.data9 /oracle/R3P/sapdata2/sr3_9/sr3.data9

mv /oracle/R3P/backup/backup/bekpmoue/sr3702.data1 /oracle/R3P/sapdata3/sr3702_1/sr3702.data1
mv /oracle/R3P/backup/backup/bekpmoue/sr3702.data10 /oracle/R3P/sapdata3/sr3702_10/sr3702.data10
mv /oracle/R3P/backup/backup/bekpmoue/sr3702.data11 /oracle/R3P/sapdata3/sr3702_11/sr3702.data11
mv /oracle/R3P/backup/backup/bekpmoue/sr3702.data12 /oracle/R3P/sapdata3/sr3702_12/sr3702.data12
mv /oracle/R3P/backup/backup/bekpmoue/sr3702.data13 /oracle/R3P/sapdata3/sr3702_13/sr3702.data13
mv /oracle/R3P/backup/backup/bekpmoue/sr3702.data14 /oracle/R3P/sapdata3/sr3702_14/sr3702.data14
mv /oracle/R3P/backup/backup/bekpmoue/sr3702.data2 /oracle/R3P/sapdata3/sr3702_2/sr3702.data2
mv /oracle/R3P/backup/backup/bekpmoue/sr3702.data3 /oracle/R3P/sapdata3/sr3702_3/sr3702.data3
mv /oracle/R3P/backup/backup/bekpmoue/sr3702.data4 /oracle/R3P/sapdata3/sr3702_4/sr3702.data4
mv /oracle/R3P/backup/backup/bekpmoue/sr3702.data5 /oracle/R3P/sapdata3/sr3702_5/sr3702.data5
mv /oracle/R3P/backup/backup/bekpmoue/sr3702.data6 /oracle/R3P/sapdata3/sr3702_6/sr3702.data6
mv /oracle/R3P/backup/backup/bekpmoue/sr3702.data7 /oracle/R3P/sapdata3/sr3702_7/sr3702.data7
mv /oracle/R3P/backup/backup/bekpmoue/sr3702.data8 /oracle/R3P/sapdata3/sr3702_8/sr3702.data8
mv /oracle/R3P/backup/backup/bekpmoue/sr3702.data9 /oracle/R3P/sapdata3/sr3702_9/sr3702.data9

mv /oracle/R3P/backup/backup/bekpmoue/sr3usr.data1 /oracle/R3P/sapdata4/sr3usr_1/sr3usr.data1
mv /oracle/R3P/backup/backup/bekpmoue/undo.data1 /oracle/R3P/sapdata1/undo_1/undo.data1
mv /oracle/R3P/backup/backup/bekpmoue/sysaux.data1 /oracle/R3P/sapdata1/sysaux_1/sysaux.data1
mv /oracle/R3P/backup/backup/bekpmoue/system.data1 /oracle/R3P/sapdata1/system_1/system.data1
mv /oracle/R3P/backup/backup/bekpmoue/cntrlR3P.dbf /oracle/R3P/sapbackup/cntrlR3P.dbf

cp /oracle/R3P/sapbackup/cntrlR3P.dbf /oracle/R3P/origlogA/cntrl/cntrlR3P.dbf
cp /oracle/R3P/sapbackup/cntrlR3P.dbf /oracle/R3P/origlogB/cntrl/cntrlR3P.dbf
cp /oracle/R3P/sapbackup/cntrlR3P.dbf /oracle/R3P/sapdata1/cntrl/cntrlR3P.dbf

sql>
startup force nomount pfile='/oracle/R3P/backup/pfile.ora';

create spfile from pfile='/oracle/R3P/backup/pfile.ora';

startup mount

recover database using backup controlfile until cancel;

alter database open resetlogs;

startup update

startup migrate