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.

Quote:

---

SQL> show parameter log_archive_format

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

---

HTH.

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.

Quote:

---

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

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

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

Quote:

---

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.

Dapi,

sorry I mistyped.

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

Thanks