Configuring Archiving for Your Oracle RAC Database

For Oracle Real Application Clusters, each instance has its own thread of redo. The preferred configuration for Oracle RAC is to configure the flash recovery area using an ASM disk group that is separate from the ASM disk group used for your data files. Alternatively, you can use a cluster file system archiving scheme.

To configure archiving for your Oracle RAC database:

1. On the Enterprise Manager Database Control Home page, while logged in as a SYSDBA user, select Availability.

   The Availability subpage appears.

2. In the Backup/Recovery section, under the heading Setup, select Recovery Settings.

   The Recovery Settings page appears.

3. In the Media Recovery section, select the ARCHIVELOG mode option.

4. In the Log Archive Filename Format field, accept the default value, or enter the desired format, then click Apply.

   For clustered databases, the format for the archive log file name should contain the %t modifier, to indicate which redo log thread the archived redo log file belongs to. As a best practice, the format for the archive log file name should also include the %s (log sequence number) and %r (resetlogs identifier) modifiers.

5. If the archive log destination is the same for all instances, then in the Archive Log Destination field, change the value to the location of the archive log destination for the cluster database.

   For example, you might set it to +DATA if using ASM, or to /u01/oradata/arch if you want local archiving on each node.

   If you need to configure a different archive log destination for any instance, you must go to the Initialization Parameters page and modify the LOG_ARCHIVE_DEST_1 parameter that corresponds to the instance for which you want to configure the archive log destination. The Instance column should display the name of the instance, for example docrac1. Change the Value field to contain the location of the archive log destination for that instance.

6. If you want to configure more than one archive log destination for the database, on the Recovery Settings page, click Add Another Row under the Archive Log Destination field.

7. After you have finished configuring archiving, click Apply.

   When prompted to restart the database, click Yes.

8. Enter the host and SYSDBA user credentials, then click Continue.

9. Wait a couple of minutes, then click Refresh.

   If the database has been restarted, you are prompted to enter the login credentials.