Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> why MAX_FAILURE in log_archive_dest_x seems cannot be functionable (sorry)
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-lReceived on Thu Jan 20 2005 - 03:37:33 CST
![]() |
![]() |