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..
- 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..