log_archive_format
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: log_archive_format

  1. #1
    Join Date
    Jun 2000
    Posts
    26
    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


  2. #2
    Join Date
    Nov 2000
    Posts
    344
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width