ORA-19905 Error

Today a  coworker ask me about the next error;

ORA-19905: log_archive_format must contain %s, %t and %r

In this case, He was installing a new database, version 11g, the error has been raised when he has started the database with the new parameters for archive. I told him, “please use RTFM”, after a fast look to the doc he has can see the mandatory sets for log_archive_format in 11g. From Oracle Documentation;

Archive log file names must contain each of the elements %s (sequence), %t (thread), and %r (resetlogs ID) to ensure that all archive log file names are unique. If the LOG_ARCHIVE_FORMAT initialization parameter is set in the parameter file, then make sure the parameter value contains the %s, %t, and %r elements.

HTH – Antonio NAVARRO

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s