-
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.
-
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.
-
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
-
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?)
"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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|