现象:
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