Re: Oracle 9.2 Standard Edition - Standby switchover issues

On 12/7/05, Luc Demanche <lucdemanche_at_gmail.com> wrote:
> Paul,
>
> By doing "alter database activate standby database;", Oracle does a
> resetlogs.
> It means that I have to recreate a fresh standby database.
>
> There is no Graceful switch ?

I believe that Lawrence To wrote a paper back in the days of 7.3 on "graceful switchover".
I found this copy:

http://www.oracle.com/technology//deploy/availability/pdf/stby8i_twp.pdf search string "oracle lawrence to standby database graceful switchover"

IF you have the current controlfile of the primary (meaning, the primary database was shutdown cleanly AND IF you have the current online redo log of the primary (meaning, the primary database was shutdown cleanly)
THEN you can have a graceful switchover to your standby database - but its not really a standby as you're mounting it with the current controlfile and applying the online redo log (and all previously archived redo logs) as if it was THE real primary database - which it is now. If you didn't mount it with a standby controlfile, its not a standby database. You're left without a standby database.

Whether or not its your real primary or just an exact copy is up to you at that point.

I'd say that its not truly a graceful switchover to a standby database, as its not a standby database at that time ... even though it was a standby database the last time you mounted it as such and possibly applied archived redo logs to it, but that's just terminology.

Paul

> I found docs for Oracle8.1.7, create new
> controlfile file, send redo log files, ...
>
> My question is :
> With Oracle 9.2, Standard Edition, we managing the standby database the same
> way then the standby with Oracle 8.1.7
>
> Thanks
> Luc
>
>
>
> On 12/7/05, Paul Drake <bdbafh_at_gmail.com> wrote:
> > On 12/7/05, Luc Demanche <lucdemanche_at_gmail.com> wrote:
> > > Hi,
> > >
> > > Oracle 9.2.0.6 Standard Edition
> > > I have issues when I want to switch between my standby and primary
> database.
> > >
> > > I got this error
> > > ARCH: Archiving not possible: No standby destinations
> > > ARCH: Failed to archive log 1 thread 1 sequence 61
> > > ORA-16014 signalled during: alter database commit to switchover to
> standby
> > > wi
> > >
> > > We are running the Standard Edition so I can't use "log_archive_dest_n
> ...."
> > >
> > > I copy my archive log file with a script and apply them using "recover
> > > automatic standby database".
> > >
> > > For another system with Enterprise Edition, I'm using these commands
> without
> > > any problems:
> > > To switch from Primary to Standby
> > > alter database commit to switchover to physical standby with session
> > > shutdown;
> > > shutdown immediate;
> > > startup nomount;
> > > alter database mount standby database;
> > > alter system set log_archive_dest_state_2=defer scope=both;
> > > alter database recover managed standby database disconnect;
> > >
> > > To switch from Standby to Primary
> > > alter database recover managed standby database finish skip standby
> logfile;
> > > alter database commit to switchover to primary;
> > > shutdown immediate
> > > startup
> > > alter system set log_archive_dest_state_2=enable scope=both;
> > >
> > > Question:
> > > What do I need to make it work with the Standard Edition ?
> > >
> > > Thanks
> > > Luc
> > > --
> > > Luc Demanche
> > > Oracle DBA
> > > (514) 867-9977
> >
> > Luc,
> >
> > > alter database recover managed standby database finish skip standby
> logfile;
> > > alter database commit to switchover to primary;
> >
> > Both of these statements are for DataGuard.
> >
> > For a user-managed standby database you will want to use the 8.1.7
> > behavior, along the lines of:
> >
> > SQL> recover standby database;
> > SQL> alter database activate standby database;
> > SQL> shutdown immediate
> > SQL> startup
> >
> > ... and you now have a new primary database (back it up :) )
> > I don't have my docs on this in front of me at the moment, but I will
> > in about an hour.
> >
> > Paul
> >
>
>
>
> --
>
> Luc Demanche
> Oracle DBA
> (514) 867-9977

--
#/etc/init.d/init.cssd stop
-- play a Sony CD, install a rootkit today
--
http://www.freelists.org/webpage/oracle-l