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 :--
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
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;
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
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
cd /disk1/archive
3> Check backup & delete archive files
rm -rf archive_files.arc