Re: switching between primary and standby

On 13 Jun 2006 08:20:34 -0700, "joeoracle" <joe.powell_at_lmco.com> wrote:

>Our specs are SUSE 9, x86-64, Oracle Enterprise 9.2.0.1 (planning to up
>to 10g). We have two identical servers at our primary site we are
>planning to put into a RAC. We have one identical server at our
>disaster recovery site which we believe we should make a standby
>database for this RAC. We have batch processing between 01:00-05:00 and
>13:00-17:00 each weekday. We are designing an application to switch our
>standby server into production mode at 00:30 (12:30) if it cannot ping
>the production server and to remain fixed in that mode until 05:30
>(17:30) when it will resume standby mode if it can ping the production
>server. With this design, how should I automate switching primary
>operations between the standby and production databases (but not from
>00:30-05:30 or 12:30-17:30)? Any other comments are welcome. Thank you.

A standby server should be up during the same times the primary server is up. Shutting down the standby server will likely cause the primary server to hang and/or to result into an archive gap at the standby server.
This approach is not going to work.

--
Sybrand Bakker, Senior Oracle DBA