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

启动数据库遭遇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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10271187/viewspace-1163500/