Video Screencast Help
Symantec Appoints Michael A. Brown CEO. Learn more.

Oracle Dataguard on VCS

Created: 27 Sep 2010 • Updated: 02 Nov 2010 | 3 comments
This issue has been solved. See solution.

when delpoying oracle (11g) dataguard on VCS (red hat linux 5), I have read you can only have 1 standby per agent. Does anyone know if you can have multiple agents (multiple standbys) from the 1 primary cluster ?

Thanks all

Comments 3 CommentsJump to latest comment

rregunta's picture

I am not sure, if you are discussing about the VCS bundled agents/ enterpise agents... request you to explain a bit more about the query.

 

Regards

Rajesh

 

Regards

Rajesh Regunta

---------------------------------------------------------------------------------------------------------------------

PS: Please mark this note as solution, if this helps.

damienpage's picture

yes , I am referring to the VCS bundled agents for managing dataguard during a failover to another node in the VCS cluster. According to the documentation VCS can manage failover for 1 dataguard standby, my query is , can VCS manage multiple standbys ?

Rick Stallcop's picture

From page 12 of “Veritas Cluster Server Agent for Oracle Data Guard Installation and Configuration Guide”

Typical Oracle data Guard setup in a VCS cluster.

                Clustering in a Data Guard environment typically consists of the following
                 hardware infrastructure:

          ■ The primary database instance (db1) sends redo data across a TCP/IP link to
                      a standby database instance (db2). A local cluster protects the primary database
                      and makes it highly available.

          ■ The standby database instance applies the redo information to a physical copy
                    of the primary database.

          ■ The primary and standby sites must be connected through a single TCP/IP
                    network connection. This link can be shared with VCS global clusters for
                    heartbeat communication.

          ■ Network heartbeating between the two data centers to determine their health;
                   this network heartbeating could be LLT or TCP/IP.

Based on the above definition, with VCS one primary database can have only one dataguard resource setup.

If there are multiple primary databases in the same VCS, you can have multiple associated dataguard resources if your hardware can handle the work load.

SOLUTION