損失日志的恢複

測試資料庫shutdown abort，再startup報了一個redo log錯誤

首先

startup mount;

select * from v$log;  檢視報錯的redo log發現是目前的活動日志

嘗試Oracle的隐含參數來試試

alter system set "_allow_resetlogs_corruption"=true scope=spfile;

shutdown immediate;

recover database using backup controlfile until cancel;

alter database open resetlogs;

startup;順利開啟，運氣不錯