---A方案
run{
shutdown abort;
startup mount;
restore datafile 5;
recover database;
alter database open;
}
---B方案
run{ --- 实例未停止的情况
sql 'alter database datafile 5 offline';
restore datafile 5;
recover datafile 5;
sql 'alter database datafile 5 online';
run{
shutdown abort;
startup mount;
restore datafile 5;
recover database;
alter database open;
}
---B方案
run{ --- 实例未停止的情况
sql 'alter database datafile 5 offline';
restore datafile 5;
recover datafile 5;
sql 'alter database datafile 5 online';
}
区别:
一个是对全库做recover,一个是对单个数据文件做recover
recover database对全库应用redo(介质恢复),再undo(事务恢复),
recover datafile读取redo,然后应用到单个数据文件,再undo