Re: Standby DB Question

"M Hashim" <mhashim_at_passport.ca> wrote in message news:3B2828A2.2859AD00_at_passport.ca...
> 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.
>

Incorrect. Activate standby database puts the standby database into full production mode. READ THE DOCUMENTATION!!

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

Only when you first create it (hence the 'create standby controlfile' command). I'll only say this one more time: to turn your standby database into a fully fledged production system when the original production system has died, you issue the command 'alter database activate standby database'.

Honestly. If there's one thing worse than discovering someone hasn't read the documentation, it's being corrected or ignored when you post an answer straight *out* of that documentation!

HJR
>
>
>
> "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 Thu Jun 14 2001 - 03:06:16 CDT