ORA-16038 错误处理

现象：

 

SQL> shutdown
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 2147483648 bytes
Fixed Size                  2022144 bytes
Variable Size            1560282368 bytes
Database Buffers          570425344 bytes
Redo Buffers               14753792 bytes
Database mounted.
ORA-16038: log 2 sequence# 391 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1: '/data1/oracle/oradata/xxdbse/redo02.log'

 

 

 

解决：

 

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

    GROUP#  SEQUENCE# ARC STATUS
---------- ---------- --- ----------------
         1        394 NO  CURRENT
         3        393 NO  INACTIVE
         2        391 NO  INACTIVE

SQL> alter database clear unarchived logfile group 3;

Database altered.

SQL> alter database open;

Database altered.

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

    GROUP#  SEQUENCE# ARC STATUS
---------- ---------- --- ----------------
         1        394 NO  INACTIVE
         2        391 NO  INACTIVE
         3        395 NO  CURRENT