why MAX_FAILURE in log_archive_dest_x seems cannot be functionable
- From: Leyi Zhang <kamusis@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 20 Jan 2005 16:17:41 +0800
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@xxxxxxxxx>
=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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » why MAX_FAILURE in log_archive_dest_x seems cannot be functionable
