RE: RAC and Standby Dr

A couple of comments on this. First, if you did go the route of using SRDF, the only supported mode for Oracle databases is synchronous. That can be a real performance hit depending on your configuration. Second, since you mentioned RAC I assume you're on 9i and in that release you can switch over and switch back for planned failovers. IIRC, you still need to recreate the primary if you have a unplanned failure of the primary which leads to a period of risk where you have no site failover capability while you rebuild the primary. Having 2 or more standby's can help to address that problem.

Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA  

-----Original Message-----
Rajesh.Rao_at_jpmchase.com
Sent: Monday, October 13, 2003 3:29 PM
To: Multiple recipients of list ORACLE-L

Thanks for the reply, Pete.

We recommended EMC SRDF to keep the production and DR in sync, but the budget cannot provide for it. Now, with a standby DR, what I am scared of is, it would take me say 15 minutes tops, to activate the standby in case of a production site failure. But then, making the production back to real production, and DR back to standby, will take much more testing and time.

Regards
Raj  

                    "Pete Sharman"

                    <peter.sharman_at_o       To:     Multiple recipients of
list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    racle.com>             cc:

                    Sent by:               Subject:     RE: RAC and Standby
Dr                                       
                    ml-errors_at_fatcit

                    y.com

 

 

                    10/12/2003 02:59

                    AM

                    Please respond

                    to ORACLE-L

 

 

If I understand you correctly and you want to use DataGuard for site failover and RAC for machine failover, that should work without any problems. It is indeed what I would recommend for a full HA configuration, since RAC only answers the machine failover part, not site failover.

Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA

-----Original Message-----
Rajesh.Rao_at_jpmchase.com
Sent: Sunday, October 12, 2003 4:39 AM
To: Multiple recipients of list ORACLE-L

Folks,

A project team here is flirting with the idea of having standby databases for the two production RAC nodes. The two standy nodes will be at a DR site. Any gotchas with this configuration?

Regards
Raj

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Rajesh.Rao_at_jpmchase.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Sharman
  INET: peter.sharman_at_oracle.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).