archive log format error....
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: archive log format error....

  1. #1
    Join Date
    May 2000
    Location
    Greenbelt, MD, USA
    Posts
    22

    Red face

    Hello All,
    I am having an error that I am unable to get around.. It is:
    ORA-00249 : Invalid archivelog format specifier '0'

    The parameter value for that is the default one which is :
    log_archive_format : %ORACLE_SID%%S.%T

    Any help will be grately appreciated..

    Thanks in advance,
    Dee.
    God Bless
    Share on Google+

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    What version and OS ? Try following format:

    Edit the LOG_ARCHIVE_FORMAT parameter, using %s to include the log sequence number as part of the filename and %t to include the thread number. Use capital letters (%S and %T) to pad the filename to the left with zeros. For example, enter:

    LOG_ARCHIVE_FORMAT = arch%t_%s.arc



    Share on Google+

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