oracle挂了

 ERROR at line 1:
ORA-16014: log 3 sequence# 3976 not archived, no available destinations
ORA-00312: online log 3 thread 1: '/App/oracle/oradata/orcl/redo03.log'

 

http://www.eygle.com/archives/2008/01/rman_cant_open_target.html

 

su oracle

 

rman target /

 

RMAN> delete noprompt obsolete;

 

RMAN> crosscheck backupset;

 

RMAN> delete expired backupset;

 

刚重启机器又出问题了

 

 

sqlplus "/ as sysdba"

 

SQL> select * from v$log;

 

alter database clear unarchived logfile group 2;