oracle数据库日志组成员丢失处理

 

日志组成员都丢失的处理

进入mount状态

startup force mount

 

开启另一窗口，动态监视警报日志

cd $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/trace

tailf alert_prod.log

 

开启数据库

alter database open

 

产生错误

ORA-03113: end-of-file on communication channel

警报日志：

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prod_lgwr_4994.trc:

ORA-00313: open failed for members of log group 1 of thread 1

ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/prod/redo01.log'

 

处理方法：

1.删除无用日志组

startup force mount

alter database drop logfile group 1 ;

2.重置日志成员信息

alter database clear logfile group 1;

 

启动数据库

startup