Log Sequence in Archive Filename Wrapped

Log Sequence in Archive Filename Wrapped

Your database is running in archivelog mode and you notice the following  error sequence in the Alert file:

ARC1: Warning.  Log sequence in archive filename wrapped
to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
Old log archive with same name might be overwritten.
Sat Oct 27 13:39:51 2012

Reason behind  log_archive_format parameter value '%S'.
Explanation:

• %S Specifies the log sequence number. This number is padded to the left by zeroes. The default value is one with a range of up to five characters.

• %s Specifies the log sequence number. The number is not padded. The defaultvalue is one with no range limit on characters.  

Solution:

Modify the LOG_ARCHIVE_FORMAT parameter value in your init.ora file
to replace the uppercase %S with a lowercase %s.

Example:

Change this line in your init.ora file:
FROM:
log_archive_format = ARC_%S_%R_%T.ARC
TO:
log_archive_format = ARC_%s_%R_%T.ARC


MOS Note: 125146.1