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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/720091/viewspace-1074993/