DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    May 2000
    Greenbelt, MD, USA

    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,
    God Bless

  2. #2
    Join Date
    Feb 2000
    Washington DC
    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

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.