log_archive_format

[JGolightly]

I'm running on NT4, and my log_archive_format is set to the default ('%%oracle_sid%%T%TS%S.arc')

My alert file is giving me the following message

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.

The default value makes the %S 5 digits with leading zeros. Can I make it 6 digits with leading zeros ?

Otherwise I will have to use %s which will not have the leading zeros.

Thanks

[jdorlon]

I have a database with NT4 and my archive logs do have leading zeros but there are only 5 digits. :-(

To fix the problem I would shut down and do a cold backup, then start up with the RESETLOGS option. Also you might want to make your redo logs bigger so this problem doesn't come up as often.