备份恢复的错误ORA-01180: can not create datafile 1
ORACLE备份成功，但是在恢复时却报不能创建DATAFILE1creating datafile fno=1 name=/oracle/oradata/XXX/system01.dbfRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============...显示全部
查看其它 7 个回答wxswxs_8029的回答
我这里有用TSM恢复的脚本你看看吧
startup nomount;
set dbid 940439594;
run {
allocate channel ch type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=D:\Tivoli\tsm\AgentOBA\tdpo.opt)';
restore controlfile ;
alter database mount;
restore database;
recover database;
}
alter database open resetlogs;
startup nomount;
set dbid 940439594;
run {
allocate channel ch type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=D:\Tivoli\tsm\AgentOBA\tdpo.opt)';
restore controlfile ;
alter database mount;
restore database;
recover database;
}
alter database open resetlogs;
浏览5010