How are the archived redo log files' names determined when automatic archiving is enabled?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

How are the archived redo log files' names determined when automatic archiving is enabled?

Rating:

When a database is running in ARCHIVELOG mode, and automatic archiving is enabled, the archiver process (ARCn) automatically archives the filled online redo log files at specified archive destinations. ARCn automatically decides the names of the archived redo log files by looking at the LOG_ARCHIVE_FORMAT parameter in the initialization parameter file. The LOG_ARCHIVE_FORMAT initialization parameter specifies a default filename format for the archived redo log files. It uses a text string and certain variables to specify the default filename format. This helps Oracle keep the archived redo log files' names sequential, unique, and easily identifiable from other files.

The following variables can be used in the filename format:

%s: It specifies the current log sequence number.

%t: It specifies the thread number.

Example:

LOG_ARCHIVE_FORMAT = "Log%s_%t.arc"

If the current log sequence number is 5, and the thread number is 1, the corresponding archived redo log file's name will be Log5_1.arc (according to the Log%s_%t.arc filename format).

Using the uppercase letters for the above variables (e.g., %S and %T) causes the value to be of a fixed length and padded to the left with zeros.

Rating: