ITPub博客

首页 > 数据库 > Oracle > ORA-16038: log 3 sequence# 510 cannot be archived

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

原创 Oracle 作者:raysuen 时间:2019-05-21 17:59:56 0 删除 编辑

#问题描述:启动报错
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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
擅长oracle,Linux。精通shell,python。

注册时间:2016-08-23

  • 博文量
    118
  • 访问量
    107240