RE: switchover with standby database

From: Kevin Lange <kgel_at_ppoone.com>
Date: Mon, 22 Oct 2001 12:28:44 -0700
Message-ID: <F001.003B1B2B.20011022124018@fatcity.com>

A broad process overview:

Process:
1. Notification comes in of a down production. -- This needs to be very reliable.
2. Make sure production is completely down. --> Look for pmon and smon processes and see if connections are possible. 3. Bring any remaining logs over to the standby --> Use your same process you are using now or a seperate script.
4. Perform an "alter database activate standby database" on the standby --> simple script using svrmgrl on a unix box.

5. Apply the logs  --> Recover database command
6. Shut down the listener  --> lsnrctl stop
7. Copy in the new listener configuration files so that users are now

pointing to the standby --> simple os copy command 8. Bring up the listener -- lsnrctl start

All of this could easily be done in an os script.

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

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:

You need to make sure your logs are completely up to date.
When you do change from live to the standby, you need to change your listeners.
You would need to automate the open of the standby as well.
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
--------------------------------------------------------------------

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

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