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

#问题描述：启动报错

SQL> startup

ORACLE instance started.

Total System Global Area 1787138048 bytes

Fixed Size                  2254104 bytes

Variable Size             956304104 bytes

Database Buffers          822083584 bytes

Redo Buffers                6496256 bytes

Database mounted.

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

Process ID: 32429

Session ID: 1137 Serial number: 5

#查看告警日志

[oracle@ora2 ~]$ tail -f /u01/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log

......

Errors in file /u01/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_32429.trc:

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

ORA-19502: write error on file "", block number  (block size=)

ORA-00312: online log 3 thread 1: '/u01/oracle/oradata/orcl/redo03.log'

USER (ospid: 32429): terminating the instance due to error 16038

......

#查看trace文件

more /u01/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_32429.trc

......

Executing ASYNC actions

----- END DDE Actions Dump (total 0 csec) -----

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

ORA-19502: write error on file "", block number  (block size=)

ORA-00312: online log 3 thread 1: '/u01/oracle/oradata/orcl/redo03.log'

kjzduptcctx: Notifying DIAG for crash event

......

#解决方案

SQL> conn / as sysdba

Connected to an idle instance.

SQL> startup mount

ORACLE instance started.

Total System Global Area 1787138048 bytes

Fixed Size                  2254104 bytes

Variable Size             956304104 bytes

Database Buffers          822083584 bytes

Redo Buffers                6496256 bytes

Database mounted.

SQL> alter database clear unarchived logfile group 3;

Database altered.

SQL> alter database open;

Database altered.

SQL>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28572479/viewspace-2645113/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28572479/viewspace-2645113/