Friday, December 3, 2010

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

The general solution for this error is
- check the Disk space
- check where the archive location exists
- Try Clearing the Unarchived log group through the SQL :
   alter database clear unarchived logfile group <<No>>;
- Bounce the Db
- Bounce the Server

but if you have done all these and still you get the error !!!!!


Like below,

Errors in file <<diag>>/trace/<<Dbname>>_arc2_1XXXX.trc:
ORA-16038: log 2 sequence# 11 cannot be archived
ORA-00312: online log 2 thread 1: '<<Log_PATH>>/redo2a.log'
ORA-00312: online log 2 thread 1: '<<Log_PATH>>/redo2b.log'
ORA-07217: sltln: environment variable cannot be evaluated.
Thu <<MON>> <<DD>> 07:19:17 <<YYYY>>
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance envrtl - Archival Error
ORA-16014: log 2 sequence# 11 not archived, no available destinations
ORA-00312: online log 2 thread 1: '<<Log_PATH>>/redo2a.log'
ORA-00312: online log 2 thread 1: '<<Log_PATH>>/redo2b.log'

Then Try checking your pfile for the below archive log parameters and correct it.

log_archive_dest_1
log_archive_format

Bounce DB  as required..