日志文件损坏的恢复

日志文件损坏的恢复

数据库处于归档状态
shutdown immediate
startup mount
alter database archivelog;
alter database open;
1)inactive日志恢复:
select group#,status from v$log;
GROUP# STATUS
------------- ------------
1 INACTIVE
2 INACTIVE
3 CURRENT
select member from v$logfile;
$rm /u01/oradata/orcl/redo04.log

alter database clear logfile group 4;
//注意：这一步使刚才os里删掉的那两个group4的文件又建立上了。

2）Active 日志损坏的恢复：

alter system switch logfile;
alter system checkpoint;
alter database clear logfile group2;

alter system switch logfile;
alter system checkpoint;
alter database clear logfile group2;

3)current 状态下 日志文件损坏的恢复：
select group#,status from v$log;
数据库不挂
alter system checkpoint;
alter database clear unarchived logfile group2;
shutdown abort;
startup mount;
recover database until cancel;
alter database open resetlogs;

数据库挂了：
startup mount;
recover database until cancel;
alter database open resetlogs;
若是数据库无法正常打开
alter system set "_allow_resetlogs_corruption"=true scope=spfile;