| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: automatic switchover??
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)
reginald.w.bailey_at_jpmorgan.com
baileyre_at_us.ibm.com
jtesta_at_dmc-it.
com To: ORACLE-L_at_fatcity.com
Sent by: cc:
ml-errors_at_fatc 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: jtesta_at_dmc-it.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: 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).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: Reginald.W.Bailey_at_jpmorgan.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: 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). Received on Tue Aug 19 2003 - 12:34:24 CDT
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |