Re: Mandatory destination omitted

"Svend Jensen" <Svend_at_OracleCare.Com> wrote in message news:3CE020DC.80800_at_OracleCare.Com...
> Tomas Vehovsky wrote:
>
> > Hello everybody,
> > I'm trying to setup managed standby environment with mandatory
> > archiving to standby site. Unfortunely, the behaviour is not
> > what I was expecting. I supposed the primary DB would stop when
> > archiving to standby site is impossible (e.g. standby DB is down).
> > However, the primary DB continues working and so some logs are
> > not sent to standby DB.
> >
> > I use Oracle 8.1.7 on NT, I have 8 redo log groups and
> > my parameters are:
> > LOG_ARCHIVE_DEST_1 = "location=G:\latest MANDATORY"
> > LOG_ARCHIVE_DEST_2 = "service=LATESTBETA MANDATORY REOPEN=60"
> > LOG_ARCHIVE_DEST_STATE_2 = ENABLE
> >
> > Detailed info about my system state follows:
> >
> > V$LOG
> > -----
> > GROUP# SEQUENCE# ARCHIVED STATUS
> > 4 2105 NO INACTIVE
> > 7 2106 NO INACTIVE
> > 8 2107 NO INACTIVE
> > 1 2108 NO INACTIVE
> > 3 2109 NO INACTIVE
> > 5 2110 NO INACTIVE
> > 2 2111 NO ACTIVE
> > 6 2112 NO CURRENT
> > ... standby site is down so Oracle marks online logs
> > as unarchived. However, they are overwritten anyway.
> >
> >
> > V$ARCHIVED_LOG
> > --------------
> > RECID NAME SEQUENCE# ARCHIVED
> > 1314 G:\LATEST\001001S02104.ARC 2104 YES
> > 1315 LATESTBETA 2104 YES
> >
> > # here the standby DB was shut down
> > 1316 G:\LATEST\001001S02105.ARC 2105 YES
> > 1317 G:\LATEST\001001S02106.ARC 2106 YES
> > 1318 G:\LATEST\001001S02107.ARC 2107 YES
> > 1319 G:\LATEST\001001S02108.ARC 2108 YES
> > 1320 G:\LATEST\001001S02109.ARC 2109 YES
> > 1321 G:\LATEST\001001S02110.ARC 2110 YES
> > 1322 G:\LATEST\001001S02111.ARC 2111 YES
> > 1323 G:\LATEST\001001S02112.ARC 2112 YES
> > 1324 G:\LATEST\001001S02113.ARC 2113 YES
> >
> > # here the standby DB was started up again, the very first
> > # failed log is sent but not the others failed logs
> > 1325 LATESTBETA 2105 YES <<<< failed seq#
> > 1326 G:\LATEST\001001S02114.ARC 2114 YES
> > 1327 LATESTBETA 2114 YES
> > 1328 G:\LATEST\001001S02115.ARC 2115 YES
> > 1329 LATESTBETA 2115 YES
> >
> >
> > V$ARCHIVE_DEST
> > --------------
> > DEST_ID STATUS BINDING TARGET REOPEN DESTINATION FAIL_SEQ
> > 1 VALID MANDATORY PRIMARY 0 G:\latest 0
> > 2 ERROR MANDATORY STANDBY 60 LATESTBETA 2105
> > 3 INACTIVE OPTIONAL PRIMARY 0 0
> > 4 INACTIVE OPTIONAL PRIMARY 0 0
> > 5 INACTIVE OPTIONAL PRIMARY 0 0
> >
> > Can anyone help me to explain why primary DB didn't stall
> > when archiving to MANDATORY destination fails? Thank you very much.
> >
> > Tomas Vehovsky
> >
>
> Hi
>
> Could be because parameter LOG_ARCHIVE_MIN_SUCCEED_DEST is default 1,
> try: show parameter LOG_ARCHIVE_MIN_SUCCEED_DEST.
> If more are to be mandatory, add this parameter to initSID.ora.
>

No, it probably isn't because of that. MIN_SUCCEED_DEST can make an optional destination effectively mandatory, but not a mandatory one optional. It's also the case that the MIN_SUCCEED parameter is an optional hang-over from Oracle 8.0, so there's no requirement to set it when using the dest_n parameters available in 8i enterprise edition.

I think the real reason may be to do with the fact that using double-quotation marks around the dest_n parameters is not a good idea (they should be single).

Regards
HJR
> /Svend Jensen
>
Received on Sat May 18 2002 - 18:17:04 CDT