Log Archive Format

[mike2000]

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.

[ggnanaraj]

SQL> show parameter log_archive_format

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

HTH.

[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).

Otherwise you're asking for trouble.

[DaPi]

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).

[mike2000]

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

[DaPi]

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?)

[DaPi]

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.

[mike2000]

Dapi,

sorry I mistyped.

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

Thanks