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

Thread: Log Archive Format

  1. #1
    Join Date
    Sep 2002
    Posts
    411

    Log Archive Format

    beside this format below:

    log_archive_format = %%ORACLE_SID%%T%TS%S.ARC


    what is other good and short format can someone suggest me to use???

    the above format make the archive log file too long.

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    SQL> show parameter log_archive_format

    NAME TYPE VALUE
    ------------------------------------ ------- ------------------------------
    log_archive_format string ARC%S.%T
    SQL>
    HTH.

  3. #3
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    If you are running more than 1 DB PLEASE make sure you uniquely identify the log files (ie by using the SID somewhere in the filename).

    Otherwise you're asking for trouble.

  4. #4
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by JMac
    If you are running more than 1 DB PLEASE make sure you uniquely identify the log files (ie by using the SID somewhere in the filename).
    Or use different directories (log_archive_dest).
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  5. #5
    Join Date
    Sep 2002
    Posts
    411
    Thanks all for yoru info and I guess you all misnderstand my question:

    the question I have is beside the above format, do you have any other format which made my archive log file shorter???

    thanks

  6. #6
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    If you insist, something like:

    log_archive_dest = X:\%ORACLE_SID% <--- check this, never used a substitution myself here
    log_archive_format = A%S.%T

    is about as short as possible, while remaining generally unique.
    Could be shorter still if you can abandon the thread number.

    (Never seen %TS in this context - can't find it in the doc - what is it?)
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  7. #7
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by mike2000
    do you have any other format which made my archive log file shorter???
    Whoaaaaa! are you talking about the length of the file name (as we all assumed - 'coz that's what this param does) or the SIZE of the file (in Kb)?

    The SIZE is determined by the size of the redologs. Archivelogs zip/compress quite nicely to save space.
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  8. #8
    Join Date
    Sep 2002
    Posts
    411
    Dapi,

    sorry I mistyped.

    I mean the name of the archived log file NAME not the SIZE.

    Thanks

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