Re: Oracle 9.2 Standard Edition - Standby switchover issues

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

--
http://www.freelists.org/webpage/oracle-l