windows还原oracle,NBU 还原windows ORACLE数据库(BW)

alter database mount;

run{

allocate channel ch00 type‘SBT_TAPE‘;

allocate channel ch01 type‘SBT_TAPE‘;

send‘nb_ora_serv=nbumaster01‘;

send‘nb_ora_client=bw-prd01‘;

set newnamefor datafile 1 to ‘E:\ERPORACLE\DATAFILE\SYSTEM.DATA1‘;

set newnamefor datafile 2 to ‘E:\ERPORACLE\DATAFILE\SYSAUX.DATA1‘;

set newnamefor datafile 3 to ‘E:\ERPORACLE\DATAFILE\UNDO.DATA1‘;

set newnamefor datafile 4 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA1‘;

set newnamefor datafile 5 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA2‘;

set newnamefor datafile 6 to ‘E:\ERPORACLE\DATAFILE\SR3740.DATA1‘;

set newnamefor datafile 7 to ‘E:\ERPORACLE\DATAFILE\SR3USR.DATA1‘;

set newnamefor datafile 8 to ‘E:\ERPORACLE\DATAFILE\SR740.DATA1‘;

set newnamefor datafile 9 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA3‘;

set newnamefor datafile 10 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA4‘;

set newnamefor datafile 11 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA5‘;

set newnamefor datafile 12 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA6‘;

set newnamefor datafile 13 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA7‘;

set newnamefor datafile 14 to ‘E:\ERPORACLE\DATAFILE\SR3740.DATA2‘;

set newnamefor datafile 15 to ‘E:\ERPORACLE\DATAFILE\SR3740.DATA3‘;

set newnamefor datafile 16 to ‘E:\ERPORACLE\DATAFILE\SR3740.DATA4‘;

set newnamefor datafile 17 to ‘E:\ERPORACLE\DATAFILE\SR3740.DATA5‘;

set newnamefor datafile 18 to ‘E:\ERPORACLE\DATAFILE\SR3740.DATA6‘;

set newnamefor datafile 19 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA8‘;

set newnamefor datafile 20 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA9‘;

set newnamefor datafile 21 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA10‘;

set newnamefor datafile 22 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA11‘;

set newnamefor datafile 23 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA12‘;

set newnamefor datafile 24 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA13‘;

set newnamefor datafile 25 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA14‘;

set newnamefor datafile 26 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA15‘;

set newnamefor datafile 27 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA16‘;

set newnamefor datafile 28 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA17‘;

set newnamefor datafile 29 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA18‘;

set newnamefor datafile 30 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA19‘;

set newnamefor datafile 31 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA20‘;

set newnamefor datafile 32 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA21‘;

set newnamefor datafile 33 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA22‘;

set newnamefor datafile 34 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA23‘;

set newnamefor datafile 35 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA24‘;

set newnamefor datafile 36 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA25‘;

set newnamefor datafile 37 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA26‘;

set newnamefor datafile 38 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA27‘;

set newnamefor datafile 39 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA28‘;

set newnamefor datafile 40 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA29‘;

set newnamefor datafile 41 to ‘E:\ERPORACLE\DATAFILE\SR3.DATA30‘;

set newnamefor tempfile 1 to ‘E:\ERPORACLE\DATAFILE\TEMP.DATA1‘;

set newnamefor tempfile 2 to ‘E:\ERPORACLE\DATAFILE\TEMP.DATA2‘;

restore databaseuntil time "to_date(‘2017/07/13‘,‘yyyy/mm/dd‘)";

SWITCH DATAFILE ALL;

SWITCH TEMPFILE ALL;

release channel ch00;

release channel ch01;

}