Archive_log_format
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Archive_log_format

  1. #1
    Join Date
    Oct 2001
    Location
    Hornchurch, Essex UK
    Posts
    132
    We've got two instances on the same server so I've set the archive log format to contain the name of the sid to avoid confusion, but the archive log file does not have the right format. - %opcflivo%67_1.ARC.

    Parameter in init.ora
    log_archive_format = %%opcflivo%%%s_%t.arc

    Do I have too many % ?

    Thanks.


  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Oct 2001
    Location
    Hornchurch, Essex UK
    Posts
    132
    Can't open this link.

  4. #4
    Join Date
    May 2002
    Location
    California, USA
    Posts
    175

    Cool

    joyce_ank,

    Use only:
    log_archive_format = opcflivo_%s_%t.arc

    You can not have % in the file names.

    Check the latest Oracle DBA forums:
    http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi


    Hope that helps,

    --clio_usa
    Senior Oracle DBA



  5. #5
    Join Date
    May 2002
    Location
    California, USA
    Posts
    175

    Cool

    To access the OTN link you need valid account and password there.

    It is free so go and create one. A bunch of goodies could be found there.

    Cheers,

    --clio_usa
    Senior Oracle DBA

  6. #6
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    If you want to create the filenames along with the sid then give like this:

    log_archive_format=%%ORACLE_SID%%S.ARC.

    Vijay.
    Say No To Plastics

  7. #7
    Join Date
    Oct 2001
    Location
    Hornchurch, Essex UK
    Posts
    132
    Thanks all for your help.

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