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

Oracle RAC + ODG or VCS HA/DR + ODG

Created: 14 Oct 2013 • Updated: 30 Oct 2013 | 4 comments
Faisal Saleem's picture
This issue has been solved. See solution.

Dear All

I have a scenrio to deal with, I need reference/comments on which solution will be better for Oracle Database.

Option 1

Front End Core App will be VCS HA/DR + VVR

Back End Oracle DB = RAC + ODG

or

Option 2

Front End Core App will be VCS HA/DR + VVR

Back End Oracle DB = HA/DR + ODG

or

Option 3

Front End Core App will be VCS HA/DR + VVR

Back End Oracle DB = HA/DR + VVR

NOTE: Already have purchased Oracle Enterprise Pack which includes ODG as a free component

Major Queries:

1. Which Option is Cost Affective 

2. if Option 2 is selected, will everything work seemless or there are some special considerations

3. if Option 3 is selected, will need some very solid reasons to drop ODG

I need to convence my client therefore a detail research is required.

Thanks.

Operating Systems:

Comments 4 CommentsJump to latest comment

mikebounds's picture

See http://www.symantec.com/connect/forums/does-oracle-uses-data-guard-and-rac-must-vcs-and-vvr

 

Mike

UK Symantec Consultant in VCS, GCO, SF, VVR, VxAT on Solaris, AIX, HP-ux, Linux & Windows

If this post has answered your question then please click on "Mark as solution" link below

Faisal Saleem's picture

Thanks mike

I have read that but my query is a bit different. I have to pitch a best suitable solution with reference to cost and efforts. In my case only Data Guard is available

Daniel Matheus's picture

Hello Faisal,

 

that depends a lot on your requirements.

The options above are quite different.

For example normal SFHA vs SFRAC.

SFRAC is used for simultaneous I/O to the database from different cluster nodes whereas in normal SFHA the Oracle database would only run on one node at a time.

So first you need to clarify whether you need Oracle running on more than one node for performance, then the answer would be that you need SFRAC.

 

Same with VVR vs ODG, ODG "simply" replicates the redo log, whereas VVR replicates a lot more (redo, archive logs and also the data files)

So VVR has higher bandwidth requirement than ODG, but in case of a failover VVR is more robust.

 

What I want to say is there is no simple option A is better answer.

You need to clarify the exact requirements.

 

regards,

Dan

 

If this post has helped you, please vote or mark as solution

SOLUTION
mikebounds's picture

RAC is more expensive so, Option 1 is the most expensive.  

VVR is licensed per node, so if "Back End Oracle DB" already has VVR installed (i.e. if  "Back End Oracle DB" is on the same node as "Front End Core App") then it costs no more money to use VVR than ODG, else you will need to buy VVR so option 2 would be more expensive.  

Reasons to drop ODG in favour of VVR are in the link I mentioned in the last post as is the disadvantage which is VVR will replicate a lot more data than Data Guard, because VVR replicates Oracle redo logs + archive logs + redo segments + Oracle Datafiles, where as Data Guard just replicates redo logs.

Mike

UK Symantec Consultant in VCS, GCO, SF, VVR, VxAT on Solaris, AIX, HP-ux, Linux & Windows

If this post has answered your question then please click on "Mark as solution" link below

SOLUTION