Re: Archive Logging won't start

Howard

Many thanks for your help. That has fixed the problem.

Paul

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:<a9gtds$855$1_at_lust.ihug.co.nz>...
> I forgot to mention: 1 is the default.
> Regards
> HJR
> --
> -----------------------------------------------
> Resources for Oracle : http://www.hjrdba.com
> ===============================
>
> "Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
> news:a9gsoh$6md$1_at_lust.ihug.co.nz...
> > log_archive_duplex_dest is the way to get mirrored archives. Also look at
> > log_archive_min_succeed_dest. That's set to either 1 or 2. If 1, it means
> > that whilst it would be nice to archive to the duplex_dest, if ARCH can't
> do
> > so for some reason the database won't particularly mind. If set to 2, it
> > means both the archive_dest and the duplex_dest MUST be archived, or the
> > database will hang in protest.
> >
> > Regards
> > HJR
> > --
> > -----------------------------------------------
> > Resources for Oracle : http://www.hjrdba.com
> > ===============================
> >
> > "Paul Rogers" <paul.rogers_at_mowlem.com> wrote in message
> > news:fb2c930.0204160150.25e072ab_at_posting.google.com...
> > > Dear All
> > >
> > > I am running Oracle standard edition 8.1.7 on NT 4 SP6 and am trying
> > > to enable archive logging. If I uncomment the necessary lines in the
> > > init file as follows:
> > >
> > > # Uncommenting the lines below will cause automatic archiving if
> > > archiving
> > > has
> > > # been enabled using ALTER DATABASE ARCHIVELOG.
> > > log_archive_start = true
> > > log_archive_dest_1 = "d:\oracle\archive"
> > > log_archive_dest_1 = "e:\oracle\archive"
> > > log_archive_format = log%S.arc
> > >
> > > I receive the following message.
> > >
> > > ORA-00439: Feature not enabled: Managed Standby
> > >
> > > I have trawled this list and Niall Litchfiled said:
> > >
> > > This 'feature' is in fact documented in the Oracle Docs.
> > >
> > > log_archive_dest_n is for Enterprise edition.
> > > log_archive_dest is for standard.
> > >
> > > So in fact it should only catch people trying to use the new syntax
> > > with
> > > standard edition.
> > >
> > > regards
> > >
> > >
> > > --
> > > Niall Litchfield
> > > Oracle DBA
> > > Audit Commission UK
> > >
> > >
> > > Does this mean I can only have one archive log destination? If not
> > > how do I mirror the archive logs under standard edition.
> > >
> > > Many thanks
> > >
> > >
> > > Paul
> >
> >
Received on Wed Apr 17 2002 - 02:10:05 CDT