Friday 14 March 2014

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

Error :--

ORA-16038: log 1 sequence# 93878 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 1 thread 1: '+DG_RED01/testprd/onlinelog/group_1.259.810739125'
ORA-00312: online log 1 thread 1: '+DG_RED02/testprd/onlinelog/group_1.259.810739127'
Fri Mar 14 10:55:10 2014
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance TESTPRD - Archival Error
ORA-16014: log 1 sequence# 93878 not archived, no available destinations
ORA-00312: online log 1 thread 1: '+DG_RED01/testprd/onlinelog/group_1.259.810739125'
ORA-00312: online log 1 thread 1: '+DG_RED02/testprd/onlinelog/group_1.259.810739127'
Fri Mar 14 11:00:10 2014

Solution :--

Remove you old archive logs first. Reduce your mount point usage to below 90%, then check

Clean Archive from RMAN :-

1> check current sequence number:-

SQL> select max(sequence#),thread# from v$backup_redolog group by thread#;

MAX(SEQUENCE#)    THREAD#
-------------- ----------
         93875          1

2>Connect with RMAN
oracle@testprd$rman TARGET /
Recovery Manager: Release 11.2.0.2.0 - Production on Fri Mar 14 11:06:53 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
connected to target database:TESTPRD

3> Check backup & Delete archive sequence (less then 100 from current sequence no). 
RMAN> delete archivelog until sequence 93675;


Clean Archive from System Disk :-

1>check archive location

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /disk1/archive
Oldest online log sequence     93885
Next log sequence to archive   93890
Current log sequence           93890

2> go to archive path
cd  /disk1/archive

3> Check backup & delete archive files

rm -rf archive_files.arc