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 -> Mandatory destination omitted

Mandatory destination omitted

From: Tomas Vehovsky <easy_at_atlas.cz>
Date: 13 May 2002 06:31:44 -0700
Message-ID: <810be338.0205130531.45e9aaf0@posting.google.com>


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 Received on Mon May 13 2002 - 08:31:44 CDT

Original text of this message

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