Re: switching between primary and standby

On Tue, 13 Jun 2006 08:20:34 -0700, joeoracle wrote:

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

The steps for switching are
1) You switch the primary to standby (involves a restart). When this

   is done, you will have two standby databases on your network. 2) You switch standby to primary (also involves a restart and re-creation

   of log files, if standby log files are not there. You have now switched    the database roles.
The problem is that during that switchover, both your databases are down. If you want to use one node for batch, you could use RAC instead of standby.

-- 
http://www.mgogala.com