Question about SRDF DR test

Question

Question about SRDF DR test

SQLisAwe5oMe

SSChampion

Points: 14052
More actions
January 15, 2014 at 6:36 am

#303235

I have 2 node, active/active cluster with 10 instances on it.
I have to do a DR test(SRDF), however, one of the application/instance do not want to move to DR side.
Is this possible to flip 9 instances to DR and have 1 left alone at PROD side and application working as BAU? If so, how to achieve it.
I am not too experienced with SRDF, so if you can share your experience, it would be great.
Regards,
SQLisAwe5oMe.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Perry Whittle SSC Guru Points: 234013 More actions · Answer 1

SQLisAwE5OmE (1/15/2014)
I have 2 node, active/active cluster with 10 instances on it.
I have to do a DR test(SRDF), however, one of the application/instance do not want to move to DR side.

sounds like the add node wizrd has not been run on the partner node for that instance, is that your desired configuration??

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

"Ya can't make an omelette without breaking just a few eggs" 😉

Perry Whittle SSC Guru Points: 234013 More actions · Answer 2

SQLisAwE5OmE (1/15/2014)
I am not too experienced with SRDF, so if you can share your experience, it would be great.

You shouldnt need to be it's ouitside of your control as the DBA. This provides more detail

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

"Ya can't make an omelette without breaking just a few eggs" 😉

SQLisAwe5oMe SSChampion Points: 14052 More actions · Answer 3

Perry Whittle (1/15/2014)
SQLisAwE5OmE (1/15/2014)
I have 2 node, active/active cluster with 10 instances on it.
I have to do a DR test(SRDF), however, one of the application/instance do not want to move to DR side.
sounds like the add node wizrd has not been run on the partner node for that instance, is that your desired configuration??

I am not sure what exactly you are asking?

This particular app is having a lot of release and they do not want to participate in the DR test, so I was asked if we can leave that app/instance alone at PROD side.

Does my question/requirement makes sense?

Regards,
SQLisAwe5oMe.

Perry Whittle SSC Guru Points: 234013 More actions · Answer 4

SQLisAwE5OmE (1/15/2014)
Perry Whittle (1/15/2014)
SQLisAwE5OmE (1/15/2014)
I have 2 node, active/active cluster with 10 instances on it.
I have to do a DR test(SRDF), however, one of the application/instance do not want to move to DR side.
sounds like the add node wizrd has not been run on the partner node for that instance, is that your desired configuration??
I am not sure what exactly you are asking?
This particular app is having a lot of release and they do not want to participate in the DR test, so I was asked if we can leave that app/instance alone at PROD side.
Does my question/requirement makes sense?

You said that one instance will not failover to DR, is that because it hasnt been installed on the DR server?

You can leave that instance running on the same node but if the server is lost the instance won't be able to restart on a partner node so not a true DR test is it

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

"Ya can't make an omelette without breaking just a few eggs" 😉

SQLisAwe5oMe SSChampion Points: 14052 More actions · Answer 5

Perry Whittle (1/15/2014)
SQLisAwE5OmE (1/15/2014)
Perry Whittle (1/15/2014)
SQLisAwE5OmE (1/15/2014)
I have 2 node, active/active cluster with 10 instances on it.
I have to do a DR test(SRDF), however, one of the application/instance do not want to move to DR side.
sounds like the add node wizrd has not been run on the partner node for that instance, is that your desired configuration??
I am not sure what exactly you are asking?
This particular app is having a lot of release and they do not want to participate in the DR test, so I was asked if we can leave that app/instance alone at PROD side.
Does my question/requirement makes sense?
You said that one instance will not failover to DR, is that because it hasnt been installed on the DR server?
You can leave that instance running on the same node but if the server is lost the instance won't be able to restart on a partner node so not a true DR test is it

No, this instance is already installed on DR side, but this particular app is having a lot of release and they do not want to participate in the DR test, so I was asked if we can leave that app/instance alone at PROD side.

So, my real question was, if we flip the remaining 9 instances to DR side, would it affect the PROD side anyway, does the PROD server needs to be down or unavailable in order for the DR test(SRDF) to go properly?

Regards,
SQLisAwe5oMe.

Perry Whittle SSC Guru Points: 234013 More actions · Answer 6

ah i see. You'll need to speak to the storage administrator regarding the SRDF storage fail over

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

"Ya can't make an omelette without breaking just a few eggs" 😉

SQLisAwe5oMe SSChampion Points: 14052 More actions · Answer 7

Perry Whittle (1/15/2014)
ah i see. You'll need to speak to the storage administrator regarding the SRDF storage fail over

Yup, I need to speak to Windows/SAN team....thanks for your suggestions.

Regards,
SQLisAwe5oMe.

Perry Whittle SSC Guru Points: 234013 More actions · Answer 8

looking at the document i linked above its done at the array level. If all LUNs for the instances are carved from the same array (and i'm guessing they are) then the lone instance will need to move too.

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

"Ya can't make an omelette without breaking just a few eggs" 😉