arc"
Since the initialization file is read when an Oracle instance is started, changes to
these parameters do not take effect until an instance is stopped and restarted.
Remember, though, that turning on automatic archiving does not put the database in
ARCHIVELOG mode. Similarly, placing the database in ARCHIVELOG mode does
not enable the automatic archiving process.
You should also make sure that the archive log destination has enough room for the
logs Oracle will automatically write to it. If the archive log file destination is full,
Oracle will hang since it can??™t archive additional redo log files.
48 | Chapter 2: Oracle Architecture
Figure 2-7 illustrates redo log use with archiving enabled.
The archived redo logs are critical for database recovery. Just as you can duplex the
online redo logs, youcan also specify multiple archive log destinations. Oracle will
copy filled redo logs to specified destinations. Youcan also specify whether all copies
must succeed or not. The initialization parameters for this functionality are as
follows:
LOG_ARCHIVE_DUPLEX_DEST
Specifies an additional location for redundant redo logs.
Pages:
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131