Re: Standby DB Question

I'm still trying to locate the answer to bring the standby into production - read/write mode.
alter database activate standby database - put it in standby mode, can't update a table for example.

Basically, I would like to stop the standby - knowing that the production server is dead- and restart it in read/write mode.

I believe I have to create a new set of control files for the standby.

"Howard J. Rogers" wrote:

> 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 - 21:59:46 CDT