Unsolved
This post is more than 5 years old
1 Message
0
2477
August 21st, 2009 07:00
Oracle and SRDF/A replication
Hello, We are planning to use SRDF/A as a DR solution for an oracle database, Until now we are using SRDF/S as DR solution for oracle databases , We never has any issues with oracle database consistency but in case of SRDF/A Since Replication is asynchronous i am suspecting oracle is going to complain about data inconsistency is their any white paper or something explaining on how to implement the oracle on SRDF/A ?? Also we are not using any oracle features like flashback or ASM ... most of our databases run on Sun Solaris.
Any help is greatly appreciated.
-raj
Any help is greatly appreciated.
-raj
No Events found!
Allen Ward
4 Operator
•
2.1K Posts
0
August 21st, 2009 09:00
There are lot's of whitepapers on Powerlink relating to implementation of Oracle on Symmetrix. Just do a search and it should come up with a list that will include references to SRDF/A.
Now, that being said I have several Oracle databases that we replicate over SRDF/A. We have not had any problems as long as we make sure all the devices for the server are in a single group and that consistency is turned on for that group. Honestly, we didn't have problems before we turned consistency on, but that might have been luck.
Just remember that when you are running SRDF/A there is a possibility that you will drop out of consistency on a link recovery. You need to account for that with some kind of Gold Copy of the R2 devices at a known good consistent point in time. Otherwise you run the risk of having a problem with the R1s while you are in a link recovery. If the link failure caused you to drop out of SRDF/A mode then you will not be consistant on the R2s until SRDF/A catches up completely.
SKT2
2 Intern
•
1.3K Posts
0
August 29th, 2009 06:00
Also it is better to watch the cycle time( symstat -sid xxxx -RepType rdfa -type CYCLE -i 10) and get you notified if it goes beyond a limit(upto what you agree)
SreeHari_Karana
36 Posts
0
January 17th, 2012 23:00
Raj,
As pointed above, do make sure that you have all the devices being accessed by the server on the same group, and dependant write consistency is turned ON so that your actual record and the transaction log do not lose the sync at any point in time. And also a "business continuance" gold copy on the R2 while still at consistency is advised to better your DR possibilities and ease of recovering the data with out any datastructure integrity issues
HTH :-)
-SreeHari