Which are the two best location options for archivelogsso that they can be accessed during recovery without DBA intervention?

You need to set up a three-Instance RAC database. The data files and fast recovery area will be
stored in ASM diskgroups called +data and +fra, respectively. The ASM disk groups will be
mounted on all ASM Instances.
Which are the two best location options for archivelogsso that they can be accessed during
recovery without DBA intervention?

You need to set up a three-Instance RAC database. The data files and fast recovery area will be
stored in ASM diskgroups called +data and +fra, respectively. The ASM disk groups will be
mounted on all ASM Instances.
Which are the two best location options for archivelogsso that they can be accessed during
recovery without DBA intervention?

A.
Cluster File System with each instance writing to a shared location

B.
Cluster File System with each instance writing to a separate location as long as all the locations
are in directories under the same mount point

C.
the ASM diskgroup +fra with the db_recovery_file_dest parameter set to the same value on all
instances

D.
a raw or block device

Explanation:
The primary consideration when configuring archiving is to ensure that all archived
redo logs can be read from every node during recovery, and if possible during backups. During
recovery, because the archived log destinations are visible from the node that performs the
recovery, Oracle RAC can successfully recover the archived redo log data.
The fast recovery area for an Oracle RAC database must be placed on an Oracle ASM disk group,
a cluster file system, or on a shared directory that is configured through a network file system file
for each Oracle RAC instance. In other words, the fast recovery area must be shared among all of
the instances of an Oracle RAC database. The preferred configuration for Oracle RAC is to use
Oracle Automatic Storage Management (Oracle ASM) for storing the fast recovery area, using a
different disk group for your recovery set than for your data files.
The location and disk quota must be the same on all instances. Oracle recommends that you
place the fast recovery area on the shared Oracle ASM disks. In addition, you must set the
DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE parameters to the same
values on all instances.
Oracle Database 2 Day + Real Application Clusters Guide



Leave a Reply 1

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

A is right. cluster file system on the shared location
B is wrong. not separate location
C is right. ASM + DB_RECOVERY_FILE_DEST to the same on all instances
D is wrong. no raw device

So A.C. are correct