redo log全部刪除後，啟動資料庫

startup nomount
alter system set "_allow_resetlogs_corruption" = true scope=spfile;
shutdown immediate;

startup mount

alter database clear logfile group 1;
alter database clear logfile group 2;
alter database clear logfile group 3;

alter database clear logfile group 4;
alter database clear logfile group 5;
alter database clear logfile group 6;
alter database clear logfile group 7;

recover database until cancel;
alter database open resetlogs;

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

 

說明：執行recover database until cancel和alter database open resetlogs時，都可能會報錯。

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/720091/viewspace-1074993/，如需轉載，請註明出處，否則將追究法律責任。