因为操作人员非正常关闭数据库后导致数据库不能启动,日志文件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.

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.

Database opened.

SQL>

完成后做一次数据库群备份