Oracle: LOG_ARCHIVE_FORMAT

[Claudio Cilloni]

Hi!

I know you know the LOG_ARCHIVE_FORMAT parameter. It supports the symbol %t, that includes in filename the 'thread number'. Now... what is exactly this number? why this number should be interesting for me? Do you think it's a good idea put this thread number in the archived log filename?

Thanks!

[Volker Borowski · Accepted solution]

Hi,

http://www-rohan.sdsu.edu/doc/oracle/server803/A54641_01/ch23.htm

extract:
The %T and %t are useful only when the Oracle Parallel Server is used.

Hope this helps
Volker

[Yogeeraj_1]

hi,

below an extract from metalink:


Parameter type: String
Syntax: LOG_ARCHIVE_FORMAT = filename
Default value: Operating system-dependent
Parameter class: Static
Range of values: Any string that resolves to a valid filename
Oracle9i Real Application Clusters: Multiple instances can have different values, but identical values are recommended.

LOG_ARCHIVE_FORMAT is applicable only if you are using the redo log in ARCHIVELOG mode. Use a text string and variables to specify the default filename format when archiving redo log files. The string generated from this format is appended to the string specified in the LOG_ARCHIVE_DEST parameter.

The following variables can be used in the format:

%s log sequence number

%S log sequence number, zero filled

%t thread number

%T thread number, zero filled

Using uppercase letters for the variables (for example, %S) causes the value to be fixed length and padded to the left with zeros. An example of specifying the archive redo log filename format follows:

LOG_ARCHIVE_FORMAT = "LOG%s_%t.ARC"

Neither LOG_ARCHIVE_DEST nor LOG_ARCHIVE_FORMAT have to be complete file or directory specifiers themselves; they only need to form a valid file path after the variables are substituted into LOG_ARCHIVE_FORMAT and the two parameters are concatenated together.


In brief, you can use it if it helps you feel at ease with your system. With RMAN backups, you really don't need to care about the name of the archive log files.

regards
Yogeeraj

[Claudio Cilloni]

Thanks Volker. Now I know I don't need it.

Ciao!
Claudio