The full log files must be archived before they can be reused. The
ALTER DATABASE ARCHIVELOG command will by default turn on automatic
archiving and the archivers are started.
Prior to Oracle Database 10g, log files marked as ready for archiving did not mean
they would be automatically archived. You also needed to set a parameter in the initialization
file with the syntax:
LOG_ARCHIVE_START = TRUE
Setting this parameter started an Oracle process to copy a full redo log to the archive
log destination.
The archive log destination and the format for the archived redo log names are
specified using two additional parameters, LOG_ARCHIVE_DEST and LOG_
ARCHIVE_FORMAT. A setting such as the following:
LOG_ARCHIVE_DEST = C:\ORANT\DATABASE\ARCHIVE
specifies the directory to which Oracle writes the archived redo log files, and:
LOG_ARCHIVE_FORMAT = ORCL%t_%s_%r.arc
defines the format Oracle will use for the archived redo log filenames. In this case,
the filenames will begin with ORCL and will end with .arc. The parameters for the format
wildcards are:
%t
Include thread number as part of the filename
%s
Include log sequence number as part of the filename
%r
Include resetlogs ID as part of the filename
If you want the archived redo log filenames to include the thread number, log
sequence number and resetlogs ID with the numbers zero-padded, capitalize the
parameters and set:
LOG_ARCHIVE_FORMAT = "ORCL%T_%S_%R.
Pages:
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130