ORA-16014: log 3 sequence# 117 not archived, no available destinations

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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s