Recovery from the loss of UNARCHIVED Inactive redo log file
db storage full and redo logs archive process hang
Alert Logs
ARC1: Closing local archive destination LOG_ARCHIVE_DEST_1: ‘/orcl/oraarch/arch_1_2562_755697044.arc’ (error 354)
(scott)
Committing creation of archivelog ‘/orcl/oraarch/arch_1_2562_755697044.arc’ (error 354)
ARCH: Archival stopped, error occurred. Will continue retrying
Mon Oct 28 13:28:07 2013
ORACLE Instance scott – Archival Error
Mon Oct 28 13:28:07 2013
ORA-16038: log 3 sequence# 2562 cannot be archived
ORA-00354: corrupt redo log block header
ORA-00312: online log 3 thread 1: ‘/u01/app/oracle/oradata/orcl/redo03.log’
Resolution
free space from /u01
most of the space were occupied by listener log file
cd $ORACLE_HOME/network/admin
cat /dev/null > listener.log
database is mounted successfully
then failed with ORA-16038: log 3 sequence# 2562 cannot be archived
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;
ALTER DATABASE OPEN;
http://boomslaang.wordpress.com/2008/11/04/recovery-from-the-loss-of-inactive-redo-log-file/
http://itsiti.com/ora-16014-log-sequence-not-archived-no-available-destinations
http://www.shaiksameer.com/2011/04/ora-01567-dropping-log.html
