ORA-00294: invalid archivelog format specifier

ORA-00294: invalid archivelog format specifier

Cause: An invalid format specifier was found in the LOG_ARCHIVE_FORMAT initialization parameter.   The only characters permitted following the % symbol are s, S, t, and T.

Action: Correct the initialization file and re-start the instance

This parameter controls the format of the archive log file name. This parameter can’t be changed on the fly, it needs a restart of the instance.


If the format defined in the parameter log_archive_format is invalid the database will startup but archiver will fail to archive logs which will cause database to hang and in the alert log you will get ora-00294 following some ARCH statements.


Solution:

If database is opened with spfile then:

First alter the log_archive_format parameter and then bounce the database once to get change the same.

Sql>ALTER SYSTEM SET log_archive_format=’arch_%t_%s.arc’ SCOPE=spfile;

Sql>shutdown immediate


Sql>Startup

If database is opened with pfile:

Shutdown the database and make required changes in log_archive_format parameter in pfile and then startup the database with the pfile.

Format options available on 9i:

%s – log sequence number
%S – log sequence number, zero filled
%t – thread number, needed when running RAC as each node creates it’s own archivelog
%T thread number, zero filled, needed when running RAC as each node creates it’s own archivelog


Format options available on 10g
%s – log sequence number
%S – log sequence number, zero filled
%t – thread number, needed when running RAC as each node creates it’s own archivelog
%T – thread number, zero filled, needed when running RAC as each node creates it’s own archivelog
%a – activation ID
%d – database ID
%r – resetlogs ID that ensures unique names are constructed for the archived log files across multiple incarnations of the database.

NOTE: In 10g, %s, %t, %r are required to be present in the parameter, if it doesn’t the database fail to start with the error ORA-19905: log_archive_format must contain %s, %t and %r. Using this format makes it the archive log filename unique for that instance.

You can skip to the end and leave a response. Pinging is currently not allowed.

Leave a Reply