ITPub博客

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

ORA-16038: log 2 sequence# 30 cannot be archived

原创 Oracle 作者:parknkjun 时间:2014-05-18 00:00:42 0 删除 编辑
启动数据库遭遇ORA-16038: log 2 sequence# 30 cannot be archived错误

SYS@ORCL>startup
ORACLE instance started.
Total System Global Area 1224736768 bytes
Fixed Size                  2020384 bytes
Variable Size             318770144 bytes
Database Buffers          889192448 bytes
Redo Buffers               14753792 bytes
Database mounted.
ORA-16038: log 2 sequence# 30 cannot be archived
ORA-19502: write error on file "", blockno  (blocksize=)
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/ORCL/redo02.log'

关闭数据库

SYS@ORCL>shu immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.

启动数据到mount状态下

SYS@ORCL>startup mount
ORACLE instance started.
Total System Global Area 1224736768 bytes
Fixed Size                  2020384 bytes
Variable Size             318770144 bytes
Database Buffers          889192448 bytes
Redo Buffers               14753792 bytes
Database mounted.

清除未归档的redo logfile

SYS@ORCL>alter database clear unarchived logfile '/u01/app/oracle/oradata/ORCL/redo02.log';
Database altered.

打开数据库

SYS@ORCL>alter database open;
Database altered

故障解决了。。。。。。

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

下一篇: 11g ADG环境搭建
请登录后发表评论 登录
全部评论

注册时间:2008-02-11

  • 博文量
    113
  • 访问量
    514264