I don't know the right answer but you may use this link
http://otn.oracle.com/deploy/availability/content.html
which was pointed out by Larry M. Carpenter, Principal Engineer, Dataguard Development Server Technologies, Oracle Corporation during a recent workshop in NJ. He is a guru on that project and may be of great help if you be able to contact him. Unfortunately I don't have his email or phone contact.
Regards Rafiq
Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Tue, 19 Aug 2003 07:59:25 -0800
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).
_________________________________________________________________
<b>MSN 8:</b> Get 6 months for $9.95/month. http://join.msn.com/?page=dept/dialup
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq 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).
