Re: turn on auto archivelog mode

Thank you Sybrand, Niall and Martin,

As you suggested, the problem is solved. Have a nice weekend!
Regards,
Phillip Guan

"Martin Haltmayer" <Martin.Haltmayer_at_0800-einwahl.de> wrote in message news:3B29E528.89EE5C3B_at_0800-einwahl.de...
> 1. Shutdown your instance.
>
> 2. Comment out the log_archive_dest_<n>.
>
> 3. Enter a line log_archive_dest = <some valid location for your archived
> redologs>.
>
> 4. Startup your instance.
>
> 5. Test with "alter system switch logfile;".
>
> Martin
>
>
>
> phil wrote:
> >
> > Hi Sybrand,
> >
> > You are correct. But how do I solve this? Thank you very much.
> >
> > Regards,
> > Phillip
> > "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> > news:tihvbgongimg37_at_beta-news.demon.nl...
> > >
> > > "phil" <pguan_at_sansia.net> wrote in message
> > > news:QW5W6.110830$qv3.35559520_at_nnrp5-w.sbc.net...
> > > > Hi all,
> > > >
> > > > I uncomment the archivelog statement in init.ora file, turned on the
> > > > archivelog and started the instance but got:
> > > >
> > > > ORA-00439: feature not enabled: Managed Standby
> > > >
> > > > Any idea? Thanks.
> > > >
> > > > OS: AIX 4.3.3
> > > > Oracle: 8.1.6
> > > >
> > > > Regards,
> > > > Phillip
> > > >
> > > >
> > > >
> > > Sure
> > > You are using log_archive_dest_<n> parameters and/or the location=
 syntax
 in
> > > log_archive_dest (which seems to be the default now).
> > > This syntax is particular for the managed standby option, which you
 don't
> > > have because you are running Oracle Standard.
> > > Issue a select * from v$option to verify whether you have managed
 standby.
> > >
> > > Am I clairvoyant or not, lol :)
> > >
> > > Hth,
> > >
> > > Sybrand Bakker, Oracle DBA
> > >
> > >
> > >
> > >
>
>
Received on Fri Jun 15 2001 - 11:28:49 CDT