Which two options can you use to ensure that the redo logs from all the instances are available during RMAN recovery from any instance?

You are managing a three-instance Oracle RAC database which uses a Cluster File System for
shared storage.
Which two options can you use to ensure that the redo logs from all the instances are available
during RMAN recovery from any instance?

You are managing a three-instance Oracle RAC database which uses a Cluster File System for
shared storage.
Which two options can you use to ensure that the redo logs from all the instances are available
during RMAN recovery from any instance?

A.
Set the LOG_ARCHIVE_DEST_1 parameter to a single location on the Cluster File System for
each of the three instances and leave the LOG_ARCHIVE_FORMAT parameter with the default
value.

B.
Set only the LOG_ARCHIVE_DEST_1 parameter to a single location on the Cluster File
System for any one of the three instances and leave the LOG_ARCHIVE_FORMAT parameter
with the default value.

C.
Set the LOG_ARCHIVE_DEST_1 parameter to a single location on the Cluster File System for
each of the three instances, and the LOG_ARCHIVE_FORMAT parameter for each instance, to
the same format including the thread number.

D.
Set the LOG_ARCHIVE_DEST_1 parameter to a single location on the Cluster File System,
and set LOG_ARCHIVE_FORMAT parameter on only one instance.

Explanation:
Initialization Parameter Settings for the Cluster File System Archiving Scheme
In the cluster file system scheme, each node archives to a directory that is identified with the same
name on all instances within the cluster database (/arc_dest, in the following example). To
configure this directory, set values for the LOG_ARCH_DEST_1 parameter, as shown in the
following example:
*.LOG_ARCHIVE_DEST_1=”LOCATION=/arc_dest”
Archived Redo Log File Conventions in Oracle RAC
For any archived redo log configuration, uniquely identify the archived redo logs with the
LOG_ARCHIVE_FORMAT parameter. The format of this parameter is operating system-specific
and it can include text strings, one or more variables, and a filename extension.
Use the %R or %r parameters to include the resetlogs identifier to avoid overwriting the logs from
a previous incarnation. If you do not specify a log format, then the default is operating system-specific and includes %t, % s, and %r.

Oracle Real Application Clusters Administration and Deployment Guide
11g Release 2 (11.2)



Leave a Reply 1

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


L. Zhu

L. Zhu

A is right.
B is wrong. not any one
C is right.
D is wrong. not only one

So A.C. are correct