Resources that must be configured or modified for replication:
RVGSharedPri
resource
CVMVolDg
resource from the existing Oracle database service group.
A log owner group including the RVGLogowner
resources must be created. The RVGLogowner
resources are used by the RLINKs for the RVG, and the RVGLogowner
resource, for which the RVG and its associated disk group are defined as attributes. The RVG log owner service group has an online local firm dependency on the service group containing the RVG.
An RVG group including the RVGShared
resource replication objects must be created. Define the RVGShared
resource and CVMVolDg
resource together within a parallel service group. The group is defined as parallel because it may be online at the same time on all cluster nodes. The CVMVolDg resource does not have volumes specified for the CVMVolume
attribute; the volumes are contained in the RVG resource. The CVMVolume
attribute for the CVMVolDg
resource is empty because all volumes in the RVG are defined by the RVG
attribute of the RVGShared
resource. The RVG
service group has an online local firm dependency on the CVM
service group.
For a detailed description of the RVGLogowner agent, which VCS uses to control the RVGLogowner
resource, and the RVGShared agent, which VCS uses to control the RVGShared resource:
See the Veritas Cluster Server Agents for Veritas Volume Replicator Configuration Guide.
The RVGSharedPri
resource must be added to the existing Oracle database service group. The CVMVolDg
resource must be removed from the existing Oracle database service group.
The existing Oracle database service group is a parallel group consisting of the Oracle database resource, CVMVolDg
resource, and CFSMount
resource (if the database resides in a cluster file system). Define the Oracle service group as a global group by specifying the clusters on the primary and secondary sites as values for the ClusterList
group attribute
For a detailed description of the CVMVolDg agent in this guide:
See CVMVolDg and CFSMount resources
For more information on replication resources:
See the Veritas Cluster Server Agents for Veritas Volume Replicator Configuration Guide.
Review the illustrations that show the changes to the VCS configuration when you set up the existing Oracle database for replication.
Note that all of the dependencies between parent and child groups are online local firm. The CVM service group is the same in all illustrations because its definition requires no changes. For Oracle9i, the CVM service group may be different on your configuration, depending on the type of IP you set up for the Listener.
Illustration of Dependencies: Configuration Before Modification for Replication (Oracle9i)
Click the thumbnail above to view full-sized image.
Illustration of Dependencies: Configuration Before Modification for Replication (Oracle 10g)
.Click the thumbnail above to view full-sized image.
Illustration of Dependencies: Configuration After Modification for Replication (Oracle9i)
Click the thumbnail above to view full-sized image.
Illustration of Dependencies: Configuration After Modification for Replication (Oracle 10g)
Click the thumbnail above to view full-sized image.
Highlights of the procedure to modify the existing VCS configuration on the primary site include:
RVGSharedPri
resource to the existing Oracle database service group and define this group as a global group by setting the ClusterList
and ClusterFailOverPolicy
attributes.
CVMVolDg
resource from the existing Oracle database service group to the newly created RVGShared
service group.
To modify VCS on the primary site
main.cf
by stopping the VCS engine on all nodes and leave the resources available:
main.cf
file:
vi
or another text editor to edit the main.cf
file.
SystemList = { galaxy = 0, nebula = 1 }
AutoStartList = { galaxy, nebula }
requires group RVGgroup online local firm
SystemList = { galaxy = 0, nebula = 1 }
AutoStartList = { galaxy, nebula }
requires group cvm online local firm
racdata_rvg requires racdata_voldg
ClusterList
group attribute (see the bolded attribute in the example that follows).
ClusterFailOverPolicy
cluster attribute. Symantec recommends using the Manual
value. See the bolded attribute in the example.
RVGSharedPri
resource to the group configuration.
RVG
service group.
Example Oracle database service group configured for replication:
SystemList = { galaxy = 0, nebula = 1 }
ClusterList = { rac_cluster101 = 0, rac_cluster102 = 1 }
ClusterFailOverPolicy = Manual
AutoStartList = { galaxy, nebula }
BlockDevice = "/dev/vx/dsk/oradatadg/racdb_vol"
Pfile @galaxy = "/oracle/orahome/dbs/initvrts1.ora"
Pfile @nebula = "/oracle/orahome/dbs/initvrts2.ora"
MonScript = "./bin/Oracle/SqlTest.pl"
requires group RVGgroup online local firm
main.cf
file.
Highlights of the procedure to modify the existing VCS configuration on the secondary site include:
The steps are similar to what you performed on the primary site.
To modify VCS on the secondary site
root
.
main.cf
by stopping the VCS engine on all systems and leave the resources available:
main.cf
file:
vi
or another text editor to edit the main.cf
file.
See Sample VCS configuration files for SF Oracle RAC
In our example, the secondary site has rac_cluster102
consisting of the nodes mercury
and jupiter
. To modify the CVM service group on the secondary site, use the CVM group on the primary site as your guide.
SystemList = { galaxy = 0, nebula = 1 }
AutoStartList = { galaxy, nebula }
requires group RVGgroup online local firm
SystemList = { mercury = 0, jupiter = 1 }
AutoStartList = { mercury, jupiter }
requires group cvm online local firm
racdata_rvg requires racdata_voldg
ClusterList
group attribute.
oradb1_grp
.
ClusterList
and ClusterFailOverPolicy
cluster attributes. Symantec recommends using the Manual
value.
RVGSharedPri
resource to the group configuration.
RVG
service group.
Below is an example of the Oracle group on the secondary site:
SystemList = { mercury = 0, jupiter = 1 }
ClusterList = { rac_cluster102 = 0, rac_cluster101 = 1 }
ClusterFailOverPolicy = Manual
AutoStartList = { mercury, jupiter }
BlockDevice = "/dev/vx/dsk/oradatadg/racdb_vol"
Pfile @mercury = "/oracle/orahome/dbs/initvrts1.ora"
Pfile @jupiter = "/oracle/orahome/dbs/initvrts2.ora"
MonScript = "./bin/Oracle/SqlTest.pl"
requires group RVGgroup online local firm
main.cf
file.