Running a RAC configuration on the standby server

[Mike Donovan]

Question:
How do we set up a RAC environment on the standby server with Dbvisit Standby?

Solution:
First see the attached image which provides a visual overview of this type of configuration and outlines the elements involved.

1. It is best to setup the RAC standby environment like one would a primary environment, and then let Dbvisit Standby create the standby database.

2. The standby database that Dbvisit Standby creates is a single instance standby database, which then has to be converted to RAC by the end user.

The steps to achieve this are as follows:
a. Once the standby database is created, edit the spfile and set: alter system set cluster_database = true scope = spfile;
b. and: SQL> alter system set cluster_database_instances = 2 scope = spfile;
c. restart standby database.

3. To Run Dbvisit Standby just run apply on only 1 standby server node

Please note: if one of the RAC standby nodes goes down there is no automatic Dbvisit Standby take over processing on the standby database. This will have to scripted manually.