损失日志的恢复

测试数据库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;顺利开启，运气不错