因为操作人员非正常关闭数据库后导致数据库不能启动,日志文件3不能归档

SQL> conn /as sysdba

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1677721600 bytes

Fixed Size 1219760 bytes

Variable Size 402654032 bytes

Database Buffers 1258291200 bytes

Redo Buffers 15556608 bytes

Database mounted.

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

ORA-19809: limit exceeded for recovery files

ORA-00312: online log 3 thread 1: '/opt/oracle/oradata/tmorcl/redo03.log'

解决方法:

SQL> select group#,sequence#,archived,status from v$log;

GROUP# SEQUENCE# ARC STATUS

---------- ---------- --- ----------------

1 280 NO INACTIVE

3 279 NO INACTIVE

2 281 NO CURRENT

SQL> alter database clear unarchived logfile group 3;

Database altered.

SQL> alter database open;

Database altered.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.