我使用rman做异机恢复的时候,使用批量语句,但是每次都只能恢复4-6个datafile,是什么原因呢?脚本如下:
run
{
startup force mount;
set newname for datafile5 to"xxx";
set newname for datafile6 to"xxxf";
set newname for datafile7 to"xxx";
set newname for datafile8 to"xxx";
set newname for datafile9 to"xxx";
set newname for datafile12 to"xxx";
set newname for datafile14 to"xxx";
set newname for datafile16 to"xxx";
set newname for datafile17 to"xxx";
set newname for datafile20 to"xxx";
set newname for datafile21 to"xxx";
set newname for datafile22 to"xxx";
set newname for datafile23 to"xx";
set newname for datafile24 to"xxx";
set newname for datafile27 to"xxx";
set newname for datafile28 to"xxx";
set newname for datafile29 to"xxx";
restore datafile 5,6,7,9,12,15,16,17,18,19,22,23,24,25,26,27,28,29;
switch datafile all;
recover datafile 5,6,7,9,12,15,16,17,18,19,22,23,24,25,26,27,28,29;
}
说明:
xxx,是恢复到新的datafile的目录
|