Books for you

LOG_ARCHIVE_MIN_SUCCEED_DEST
Indicates whether the redo log must be successfully written to one or all of the
locations. Valid values are 1 through 10 if multiplexing and 1 or 2 if duplexing.
See your Oracle documentation for the additional parameters and views that enable
and control this functionality.
Instance Memory and Processes
An Oracle instance can be defined as an area of shared memory and a collection of
background processes. The area of shared memory for an instance is called the System
Global Area, or SGA. The SGA is not really one large undifferentiated section of
memory??”it??™s made up of various components that we??™ll examine in the next section.
All the processes of an instance??”system processes and user processes??”share
the SGA.
Figure 2-7. Cycling redo logs with archiving
Logs are archived as they fill and Oracle switches to a new log
redog1m1.log redog1m2.log
Group 1
redog2m1.log redog2m2.log
Seq#=1
Seq#=2
Seq#=3
redog3m1.log redog3m2.log
Seq#=4
Group 2
Group 3
Archived Redo Logs
ORCL0000000001.


Pages:
108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132