Joe, you are correct. The switchover is near automatic but you have to
tell dataguard to switchover. For automatic use in case of failure of the
production database, then you are thinking about failover. I've spoken to
Oracle about this, and according to the analyst I spoke with, failover is
indeed one way. It is automatic and designed to be initiated when the
production server and database are f.u.b.a.r. There is no provision to
fail back to the original production server.
For switchover, you can automate it as much as possible using OEM and
Dataguard, but it is still going to require a little intervention , I
think. Switching over to standby is a controlled fail over and it is
conditional. A true failover is one way. To set up failover, you must put
the failover parameters in the init.ora or binary spfile of the two
databases involved.
I hope this helps.
RWB
============================================================================================================
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
[EMAIL PROTECTED]
[EMAIL PROTECTED]
============================================================================================================
[EMAIL PROTECTED]
com To: [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: automatic switchover??
ity.com
08/19/2003
10:59 AM
Please respond
to ORACLE-L
I'm heading to a data guard meeting in a couple of days, have
implemented it a few times and the DBAs have always been anal enough to
NOT want automatic switchover to standby server, they wanted to control
it. All said and good, new client(damagement) wants the switchover to
happen automagically. I've been trying to find it anywhere but it
always seems that someone must type the "alter database commit to
switchover to standby" on primary and after success, 'alter database
commit to switchover to primary' on the original standby.
I know DG broker handles the applying of logs, etc but i dont see an
option to make those commands to switchover automatically happen, i'm
thinking its that way ON PURPOSE or am i missing something here?
thanks, joe
--
Joseph S Testa
Chief Technology Officer
Data Management Consulting
p: 614-791-9000
f: 614-791-9001
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joe Testa
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:
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).
