ORA-16038: log 3 sequence# 4 cannot be archived

db：oracle11.2.0.1

os：redhat5.3

 

数据库在启动的时候报如下错误：

 

SQL> startup

ORACLE instance started.

 

Total System Global Area  167772160 bytes

Fixed Size                  1218316 bytes

Variable Size              71305460 bytes

Database Buffers           92274688 bytes

Redo Buffers                2973696 bytes

Database mounted.

ORA-16038: log 3 sequence# 4 cannot be archived

ORA-19504: failed to create file ""

ORA-00312: online log 3 thread 1:

'/opt/oracle/product/11.2.0/oradata/primary/redo03.log'

从报错信息上可以看出来是归档的日志出错。 查看日志的信息: SQL> select group#,sequence# from v$log;     GROUP#  SEQUENCE# ---------- ----------          1          5          3          4          2          6 清除出错的日志文件： SQL> alter database clear unarchived logfile group 3; Database altered. 启动数据库 SQL> alter database open; Database altered. 重新启用归档： SQL> alter system archive log start; System altered.