Database Reference
In-Depth Information
Figure 13-2.
Repository database configured using RAC database
Consider using the Maximum Availability Architecture
1
(MAA) Advisor in Enterprise Manager Cloud Control 12c
to configure additional HA components, including the following:
ARCHIVELOG
mode so that consistent hot backups of the database can be performed.
•
Enable
•
Enable block checksums to enable Oracle to detect corruption due to physical disks or storage
systems. Set the
DB_BLOCK_CHECKSUM
parameter to
TYPICAL
or
FULL
.
•
Configure the size of redo log files and groups appropriately. Optimize I/O throughput and
performance of the database so that log switches do not occur too frequently. Use of the Redo
Log Sizing Advisor (enabled by setting
FAST_START_MTTR_TARGET
) can help determine the
optimal sizes.
•
Use a Fast Recovery Area
2
to store recovery-related files such as redo logs and archive logs.
Oracle can then use suggested backup mechanisms that use the Fast Recovery Area.
•
Enable Flashback Database to enable faster database recovery using flashback logs.
•
Use fast-start fault recovery to control the instance-recovery time. Set the initialization
parameter
FAST_START_MTTR_TARGET
to specify the number of seconds that instance recovery
should take.
•
Enable database block checking to enable early detection and prevention of data and memory
corruption. Set
DB_BLOCK_CHECKING
to
TRUE
or
FULL
.
After configuring the components, you can monitor the status of each by using the High Availability Console,
shown in Figure
13-3
.
1
Maximum Availability Architecture (MAA) is a set of Oracle-recommended practices based on high-availability features. These
recommendations are based on product development validations and experiences of customers running Oracle products.
2
The Fast Recovery Area was previously called Flash Recovery Area in pre-11.2 Oracle databases.