Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Mandatory destination omitted
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
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
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
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