启动数据库报联机日志文件错误:ORA-00322

郑全

类似如下:


Errors in file /oracle/admin/yscz/bdump/yscz_lgwr_5281.trc:
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: online log 2 thread 1: '/oracle/oradata/yscz/redo02.log'
Fri Oct 24 12:41:14 2008
Errors in file /oracle/admin/yscz/bdump/yscz_lgwr_5281.trc:
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: online log 2 thread 1: '/oracle/oradata/yscz/redo02.log'
ORA-322 signalled during: ALTER DATABASE OPEN...

这个时候,检查联机日志文件状态都为inactive,可以通过clear logfile 方式解决.

解决办法如下：
1. shutdown  immediate;
2. startup mount;
3. alter database clear logfile '/oracle/oradata/yscz/redo02.log';
4. alter database open;
5. select status from v$instance;

如果一组有多个文件,需要把该组的所有文件都带上.
如果是rac环境,如果还有其他节点数据库打开,这个时候执行clear logfile,还会报ora-01138的错误,解决办法是把其他节点的实例也停了,再来操作即可.