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…

Question

Options

• ASet the LOG_ARCHIVE_DEST_1 parameter to a single location on the Cluster File System for
• BSet only the LOG_ARCHIVE_DEST_1 parameter to a single location on the Cluster File System
• CSet the LOG_ARCHIVE_DEST_1 parameter to a single location on the Cluster File System for
• DSet the LOG_ARCHIVE_DEST_1 parameter to a single location on the Cluster File System, and

• A
  80% (20)
• B
  8% (2)
• D
  12% (3)

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)

No community discussion yet for this question.