Forum Discussion

actitud's avatar
actitud
Level 3
11 years ago

Oracle Data Guard over VCS 6.0

Hello experts. It's being almost a month testing and digging on the VCS documentation regarding "Data Guard and Oracle agents supported by Veritas". The first I can say, documentation is incomple...
  • mikebounds's avatar
    11 years ago

    I configured the Oracle DG agent about 3 years ago and it worked fine, but I agree the documentation is not great.  I don't know that much about Oracle, but my understanding from the "About the agent for Oracle Data Guard" is that:

    • Data Guard agent is used for single instance Oracle for all versions and this uses SQL *Plus to control Oracle DG.
    • Data Guard Broker agent is used for RAC but can also be used for single instance Oracle since 11gR2
     
    So if this understanding is correct, as you are using single instance 11gR2, then you have choice of using EITHER Data Guard agent or Data Guard Broker agent, but you should not use both, as you have done.
    As to which agent you should use, I guess this is an Oracle question, but it would be useful if the agent guide gave some direction on this.
     
    When you had your listener resource configured, did you make Oracle resource depends on the Listener resource as in the agent guide.
     
    Have you tested Oracle DG outside of VCS control - it it doesn't work outside of VCS control, then VCS won't be able to get it to work either.  If it works outside of VCS control, but not in VCS, then look at engine_A.log and OraDG_A.log and post any errors.
     
    As an aside, I would not set EnvFile = "/home/oracle/.profile" - this is bad HA practice as if someone changed the .profile this could break VCS (so for instance I have seen a DBA add a menu to .profile to choose what dabase they wanted to log into and this change would break VCS if they had used .profile in VCS).
     
    Mike