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-----
[EMAIL PROTECTED]
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"
<[EMAIL PROTECTED] To: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>
racle.com> cc:
Sent by: Subject: RE: RAC and Standby
Dr
[EMAIL PROTECTED]
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-----
[EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
