RE: LGWR Error

From: Simon Waibale <waibals_at_mtn.co.ug>
Date: Thu, 04 Apr 2002 02:13:25 -0800
Message-ID: <F001.0043AC9B.20020404021325@fatcity.com>

Mike,
DB restarted with some delay in shut down immediate(due to tx recovery). I've gone through oerr 7211 and subsequent workarounds from metalink which point to a bug -failure of bg processes to withstand OS errors. Trouble is that my traces/alert are very quiet about the possible system error:

------alertSID.log
Thu Apr 4 10:52:47 2002

ARC5: Completed archiving log# 9 seq# 246986
ARC5: Beginning to archive log# 6 seq# 102424
ARC5: Completed archiving log# 6 seq# 102424

Thu Apr 4 11:00:17 2002
Thread 1 advanced to log sequence 246988   Current log# 1 seq# 246988 mem# 0: /data1/oradata/flag/redo1_40.log Thu Apr 4 11:00:17 2002
ARC7: Beginning to archive log# 2 seq# 246987 Thu Apr 4 11:00:17 2002
  Current log# 1 seq# 246988 mem# 1: /data3/oradata/flag/redo2_40.log LGWR: terminating instance due to error 7211 Instance terminated by LGWR, pid = 525828 Thu Apr 4 11:10:35 2002
Starting ORACLE instance (normal)
Thu Apr 4 11:10:35 2002

--------LGWR Trace
/opsdump/flag/bdump/lgwr_525828.trc
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning and Parallel Server options JServer Release 8.1.7.0.0 - Production
ORACLE_HOME = /ops/product/817
System name: OSF1
Node name: sauga01.mtn.co.ug

Release:    V5.1
Version:    732
Machine:    alpha

Instance name: flag1
Redo thread mounted by this instance: 1
Oracle process number: 6
Unix process pid: 525828, image: oracle_at_sauga01.mtn.co.ug (LGWR) *** 2002-04-04 11:00:49.206
*** SESSION ID:(5.1) 2002-04-04 11:00:49.152 error 7211 detected in background process

-----EOFs

My ORACLE RDBMS is Version: 8.1.7.0.0. on Tru64 Digital Unix

-----Original Message-----
Sent: Thursday, April 04, 2002 12:38 PM
To: Multiple recipients of list ORACLE-L

Simon,

My 8.1.7.3 system returns this description from oerr :

07211, 00000, "slgcs: gettimeofday error, unable to get wall clock."

// *Cause:  Gettimeofday system call returned an error. Possible OS error.
// *Action: Check additional information returned in OS reference manual.
//          Contact customer support.

Sounds like yoiu need to send your trace files to Oracle support.

Has your database restarted OK?

Regards,
Mike Hately

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Simon Waibale
  INET: waibals_at_mtn.co.ug

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Apr 04 2002 - 04:13:25 CST