Re: Oracle 9.2 Standard Edition - Standby switchover issues
- From: Luc Demanche <lucdemanche@xxxxxxxxx>
- To: Paul Drake <bdbafh@xxxxxxxxx>
- Date: Wed, 7 Dec 2005 11:09:45 -0500
Thank you very much ....
On 12/7/05, Paul Drake <bdbafh@xxxxxxxxx> wrote:
>
> On 12/7/05, Paul Drake <bdbafh@xxxxxxxxx> wrote:
> > On 12/7/05, Luc Demanche <lucdemanche@xxxxxxxxx> 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"
>
> Graceful Switchover and Switchback of Oracle Standby Databases
>
> https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=76450.1
>
> Graceful Switchover and Switchback
> Oracle Standby Database
> Versions 7.3, 8.0, 8.1
> Revised November 11, 1999
>
> > 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@xxxxxxxxx> wrote:
> > > > On 12/7/05, Luc Demanche <lucdemanche@xxxxxxxxx> 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
> >
>
>
> --
> #/etc/init.d/init.cssd stop
> -- play a Sony CD, install a rootkit today
>
--
Luc Demanche
Oracle DBA
(514) 867-9977
Other related posts:
