Re: Standby DB Question

From: Howard J. Rogers <howardjr_at_www.com>
Date: Thu, 14 Jun 2001 08:05:43 +1000
Message-ID: <3b27e3e1$1@news.iprimus.com.au>

Yes, there is a standard sql command to activate the standby so that it becomes your new production database (off the top of my head, it's 'alter database activate standby database') -all generously documented in the various manuals.

Your old production database now gets repaired in your own time, and is then made your new standby database
HJR

--
=============================!!=============================
The views expressed are my own only, and definitely NOT those of Oracle
Corporation
=============================!!=============================


"M Hashim" <mhashim_at_passport.ca> wrote in message
news:3B26E38D.22381BBE_at_passport.ca...


> I have a Standby DB running in a managed recovery mode - everything

> works well, except.

>

> What I would like to know;

> Is there a way to turn on the standby in full read/write as production -

> I know you need the control files, how? I'm assuming the production is

> down, and there is no access to the production control files.

>

> I could create a mirrored copy on a separate (or on the standby server)

> server, and have access to those.

>

> I am hoping there is another way in recreating production level control

> files using the standby. Any suggestion?

>

> This, by the way, is a means to automate the turn over of the standby

> into full production with little or no manual involvement.

>

Received on Wed Jun 13 2001 - 17:05:43 CDT