Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Mandatory destination omitted

Re: Mandatory destination omitted

From: Svend Jensen <Svend_at_OracleCare.Com>
Date: Mon, 13 May 2002 22:23:56 +0200
Message-ID: <3CE020DC.80800@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.

/Svend Jensen Received on Mon May 13 2002 - 15:23:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US