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

Home -> Community -> Mailing Lists -> Oracle-L -> why MAX_FAILURE in log_archive_dest_x seems cannot be functionable (sorry)

why MAX_FAILURE in log_archive_dest_x seems cannot be functionable (sorry)

From: Leyi Zhang <kamusis_at_gmail.com>
Date: Thu, 20 Jan 2005 16:34:58 +0800
Message-Id: <20050120163322.7401.KAMUSIS@gmail.com>


Sorry for the previous mail, the database version is 9205, not 9204. Previous mail as below.

Hi, all:

My test env is oracle9204 on Solaris 8 for sparc.

I unplugged standby network and checked primary's alertlog, I found even I set MAX_FAILURE=3D2 REOPEN=3D10, primary still keep checking wheather it can post redo data to standby and this check time always last for 15 seconds (NET_TIMEOUT's value?).
But oracle online doc said, it should be check 2 times and will stopped until reset the error status in v$archive_dest_status view.

What's wrong with my test? or just the bug of Oracle.

Thu Jan 20 12:11:47 2005
ALTER SYSTEM SET log_archive_dest_3=3D'SERVICE=3DCTSDB.STANDBY LGWR ASYNC=
=3D20480 NET_TIMEOUT=3D15 MAX_FAILURE=3D2 REOPEN=3D10' SCOPE=3DBOTH;
Thu Jan 20 12:11:48 2005
Thread 1 cannot allocate new log, sequence 905 Checkpoint not complete
  Current log# 3 seq# 904 mem# 0: /oradata/ctsdb/redo03.log Creating archive destination LOG_ARCHIVE_DEST_3: 'CTSDB.STANDBY'
=2E...

Thu Jan 20 12:12:19 2005
Creating archive destination LOG_ARCHIVE_DEST_3: 'CTSDB.STANDBY' LNS2 started with pid=3D16
Thu Jan 20 12:12:35 2005
LGWR received timedout error from KSR
=2E...

Thu Jan 20 12:12:46 2005
Thread 1 cannot allocate new log, sequence 911 Checkpoint not complete
  Current log# 3 seq# 910 mem# 0: /oradata/ctsdb/redo03.log Creating archive destination LOG_ARCHIVE_DEST_3: 'CTSDB.STANDBY' LNS3 started with pid=3D20
Thu Jan 20 12:13:04 2005
LGWR received timedout error from KSR
No action necessary. ARCH will attempt to transmit log file LGWR: Error 2 creating archivelog file 'CTSDB.STANDBY'
=2E...

Thu Jan 20 12:13:15 2005
Thread 1 cannot allocate new log, sequence 914 Checkpoint not complete
  Current log# 3 seq# 913 mem# 0: /oradata/ctsdb/redo03.log Creating archive destination LOG_ARCHIVE_DEST_3: 'CTSDB.STANDBY' LNS4 started with pid=3D21
Thu Jan 20 12:13:33 2005
LGWR received timedout error from KSR
No action necessary. ARCH will attempt to transmit log file LGWR: Error 2 creating archivelog file 'CTSDB.STANDBY'
=2E...

Thu Jan 20 12:13:45 2005
Creating archive destination LOG_ARCHIVE_DEST_3: 'CTSDB.STANDBY' LNS5 started with pid=3D22
Thu Jan 20 12:14:01 2005
LGWR received timedout error from KSR
No action necessary. ARCH will attempt to transmit log file LGWR: Error 2 creating archivelog file 'CTSDB.STANDBY'
=2E...

--=20
Kamus <kamusis_at_gmail.com>

=C4=C7=C3=B4=B6=E01G=B5=C4=D3=CA=CF=E4=A3=AC=CE=D2=C4=DC=D3=C3=C0=B4=B8=C9=
=CA=B2=C3=B4:-)

A Oracle8i & 9i Certified DBA from China

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 20 2005 - 03:37:33 CST

Original text of this message

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