rac2fs脚本

来源：互联网发布：tensorflow fcn 微调编辑：程序博客网时间：2024/06/10 12:11

run{
restore controlfile from '/eisoo/con_07pcg2pu_1_1';
alter database mount;
catalog backuppiece '/eisoo/archive_08pcg2s3_1_1';
SET NEWNAME FOR DATAFILE 1 to '/u01/app/oracle/oradata/rac/system.dbf';
SET NEWNAME FOR DATAFILE 2 to '/u01/app/oracle/oradata/rac/undotbs1.dbf';
SET NEWNAME FOR DATAFILE 3 to '/u01/app/oracle/oradata/rac/sysaux.dbf';
SET NEWNAME FOR DATAFILE 4 to '/u01/app/oracle/oradata/rac/users.dbf';
SET NEWNAME FOR DATAFILE 5 to '/u01/app/oracle/oradata/rac/example.dbf';
SET NEWNAME FOR DATAFILE 6 to '/u01/app/oracle/oradata/rac/undotbs2.dbf';

sql "alter database rename file ''+DATA/rac/onlinelog/group_2.262.813607859'' to ''/u01/app/oracle/oradata/rac/redo21.log''";
sql "alter database rename file ''+RECOVERYDEST/rac/onlinelog/group_2.258.813607881'' to ''/u01/app/oracle/oradata/rac/redo22.log''";
sql "alter database rename file ''+DATA/rac/onlinelog/group_1.261.813607825'' to ''/u01/app/oracle/oradata/rac/redo11.log''";
sql "alter database rename file ''+RECOVERYDEST/rac/onlinelog/group_1.257.813607847'' to ''/u01/app/oracle/oradata/rac/redo12.log''";
sql "alter database rename file ''+DATA/rac/onlinelog/group_3.266.813610061'' to ''/u01/app/oracle/oradata/rac/redo31.log''";
sql "alter database rename file ''+RECOVERYDEST/rac/onlinelog/group_3.259.813610101'' to ''/u01/app/oracle/oradata/rac/redo32.log''";
sql "alter database rename file ''+DATA/rac/onlinelog/group_4.267.813610113'' to ''/u01/app/oracle/oradata/rac/redo41.log''";
sql "alter database rename file ''+RECOVERYDEST/rac/onlinelog/group_4.260.813610143'' to ''/u01/app/oracle/oradata/rac/redo42.log''";

restore database;
switch datafile all;
recover database;
alter database open resetlogs;
}

0 0