Re: turn on auto archivelog mode

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 - 05:36:24 CDT