Re: log_archive_min_succeed_dest param

Dave Hau <davehau_nospam_123_at_nospam_netscape.net> wrote in message news:<3F39557C.5020107_at_nospam_netscape.net>...
> m_j127_at_hotmail.com wrote:
> > I am currently studying for the Fundamentals 2 exam and need some
> > clarification on the following:
> >
> > This is the scenario:
> > ARCn processes are writing online redo log files to one local
> > mandatory destination, one local optional destination and one remote
> > mandatory destination.
> >
> > LOG_ARCHIVE_MIN_SUCCEED_DEST=2
> >
> > What would happen if I had the same scenario above but the
> > LOG_ARCHIVE_MIN_SUCCEED_DEST was set to 3 or any value greater than
> > the mandatory and optional LOCAL destinations
> >
> > Thanks in advance
>
> If it's set to 3, then your optional destination is treated as mandatory
> as well. If it's set to > 3, then you get ORA-19555 "invalid
> LOG_ARCHIVE_MIN_SUCCEED_DEST parameter value".
>
> Cheers,
> Dave

Thanks for that that Dave. Some of this stuff just is not covered enough in the books.

M Received on Thu Aug 14 2003 - 15:03:22 CDT