If selected, places the database in ARCHIVELOG mode and enables filled redo log files to be archived before being re-used. This enables the database to be completely recovered from both instance and disk failure. If selected, you must enable Automatic Archiving and provide information for the fields described below.
An instance can be configured to have an additional background process, the archiver (ARC0), automatically archive groups of online redo log files after they become inactive. Automatic archiving frees the database administrator from having to keep track of, and archive, filled groups manually.
Enter the format for an archived log file or accept the default entry. This value is assigned to the initialization file parameter LOG_ARCHIVE_FORMAT. Four format types are available:
| Format | Description |
|---|---|
| %T |
Specifies the thread number padded to the left by zeroes. The default value is one with a range of up to three characters. |
| %t |
Specifies the thread number. The number is not padded. The default value is one with no range limit on characters. |
| %S |
Specifies the log sequence number padded to the left by zeroes. The default value is one with a range of up to three characters. Oracle recommends using the %S format. |
| %s |
Specifies the log sequence number.
The number is not padded. The default value is one with no range limit
on characters. |
For examples refer to Log Archive Format Examples.
Enter the directory in which to store offline redo log files or accept the default entry. This value is assigned to the initialization file parameter LOG_ARCHIVE_DEST.
All Initialization Parameters Button
File Location Variables Button
Copyright © 1996, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.