RE: switchover with standby database

From: Andrey Bronfin <andreyb_at_elrontelesoft.com>
Date: Mon, 22 Oct 2001 10:51:34 -0700
Message-ID: <F001.003B19A8.20011022105719@fatcity.com>

Thanks a lot Kevin !
I thought of it , hope everything will work , i have no choice actually. Regarding bullet #3 - this is exactly what i'm asking - how can i automate the open of the standby ?
Thanks a lot !

-----Original Message-----
Sent: Monday, October 22, 2001 8:25 PM
To: Multiple recipients of list ORACLE-L

Keep a couple things in mind when you talk about automating a standby process:

1. You need to make sure your logs are completely up to date.
2. When you do change from live to the standby, you need to change your listeners.
3. You would need to automate the open of the standby as well.
4. You need to make sure this is foolproof. I would hate to have my standby come up prematurely. Remember, after it goes into live mode, you can not put it back as a standby. At that point, you re rebuilding the standby.

-----Original Message-----
Sent: Monday, October 22, 2001 12:50 PM
To: Multiple recipients of list ORACLE-L

Dear gurus !
I'm about to implement Oracle standby database using oracle 8.0.5 . I need automatic switchover in case of primary site failure , i.e. i need the standby (secondary) database to get opened automatically should the primary site fail.
Is there a way to achieve this ?
I know that there is automated failover capability in 8i managed standby , but we use 8.0.5 :-(
Thanks in advance .
Andrey

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Andrey Bronfin
  INET: andreyb_at_elrontelesoft.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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.com
--

Author: Kevin Lange
  INET: kgel_at_ppoone.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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.com
--

Author: Andrey Bronfin
  INET: andreyb_at_elrontelesoft.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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). Received on Mon Oct 22 2001 - 12:51:34 CDT