Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> switching between primary and standby
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.
Received on Tue Jun 13 2006 - 10:20:34 CDT