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/