invalid archivelog format specifier
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: invalid archivelog format specifier

  1. #1
    Join Date
    Sep 2000
    Posts
    362

    Unhappy

    Hi,
    When I am trying to open my database it is giving me the following error.


    SVRMGR> alter database open;
    alter database open
    *
    ORA-00255: error archiving log 4 of thread 1, sequence # 4
    ORA-00312: online log 4 thread 1: 'C:\ORA805\DATABASE\LOG1ORCL.ORA'
    ORA-00294: invalid archivelog format specifier 'O'
    SVRMGR>

    Initialization Parameters
    ---------------------------
    log_archive_dest = %ORACLE_HOME%\database\archive
    log_archive_format = %ORACLE_SID%%S.%T
    log_archive_start = TRUE

    Please suggest

    Thanks
    Anurag

  2. #2
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    as it suggests it does not recognise the %ORACLE_HOME% in the log_Archive_format

    I think % expects only following characters that have a special meaning --

    s,S,t,T

    So Change your parameter to --

    log_archive_format = Arch%S.%T

    or if you must add the SID_Name then hard code it --

    log_archive_format = MySid%S.%T

    - Rajeev

    Rajeev Suri

  3. #3
    Join Date
    Sep 2000
    Posts
    362
    Hi Rajeev,
    I changed the initialization parameter so that it looks like

    log_archive_format = Arch%S.%T

    and it worked.

    But my question is why did it not recognize the
    %oracle_sid%. Moreover that format was created by oracle database configuration assistant as default when i said that enable archiving while creating the database.

    Thanks
    Anurag

  4. #4
    This is a Bug: 723315 and it is fixed in 8.0.6.
    It only appears in 8.0.5, 8.0.4 doesn't have this problem
    Ramon Caballero, DBA, rcaballe@yahoo.com

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