Use this dialog box to specify additional archive mode parameters, other than the default parameters.
You can configure your Oracle Database instance to archive filled redo log files automatically, or you can archive manually. For convenience and efficiency, automatic archiving is usually best. Click Automatic Archive to have an additional background process, 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 the archived log files or accept the default entry. This value is assigned to the initialization file parameter LOG_ARCHIVE_FORMAT.
You set the arch, using
%t
to
include the thread number as part of the file name,
%s
to include the log sequence number, and
%r
to include the resetlogs ID (incarnation number
for database). Use capital letters
(
%T
,
%S
,
and
%R
) to pad the file name
to the left
with zeroes.
These formats are summarized in the following table. For examples of various archive log formats, see Log Archive Format Examples.
| 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.
|
Use this section of the page to identify the destination for your archive log files.
If you have specified a Fast Recovery Area, your archive log files will be stored in the Fast Recovery location by default. However, you can mulitplex the files by specifying additional locations in the Archive Log Destinations area of this dialog box. Oracle recommends that you save your archive log files to multiple locations across different disks.
Enter an additional directory (or directories) in which to store your archive log files. This value is assigned to the initialization file parameter LOG_ARCHIVE_DEST.
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.