From oracle-l-bounce@freelists.org Thu Nov 18 15:57:03 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iAILv3G19162 for ; Thu, 18 Nov 2004 15:57:03 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id iAILv3i19150 for ; Thu, 18 Nov 2004 15:57:03 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9A56B72D9FD; Thu, 18 Nov 2004 17:03:21 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 06568-09; Thu, 18 Nov 2004 17:03:21 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8DD7C72E907; Thu, 18 Nov 2004 16:46:38 -0500 (EST) Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=CHEC++cGGJ+nedKsTVZoBqmxeMe4lz1788GYpGBZkuNvLn4KicFY+BHZmYDAguaPB0EnIcYYsoL3GPezxRM4pdf+ao/gOOqTMeczqDTce+aNXXJurxzRYUfrAlweEr5AetphOLXP6PcLFFxt3VQ1f6DlbJyFTmkgRk3xIVnx7Qo= ; Message-ID: <20041118212940.59720.qmail@web53306.mail.yahoo.com> Date: Thu, 18 Nov 2004 13:29:40 -0800 (PST) From: susan lam Subject: checkpoint incomplete issue To: oracle-l@freelists.org MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-archive-position: 12410 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: susanzlam@yahoo.com Precedence: normal Reply-To: susanzlam@yahoo.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org I'm running a batch updates on my database and I've been getting the following messages in my alert file: "cannot allocate new log check point incomplete." My job hangs waiting on log file switch (checkpoint incomplete) event. I have 8 redo log groups (300MB members). When I did a query on v$log, all of the log members' archived status ='YES' except for the current member. So it appears that the rest of the seven groups have been archived but yet the database could not advanced to the next redo log. Furthermore, the alert.log does not show frequent log switches. It switches log every 10mins and about every 5mins, the database complains about "cannot allocate new log". Does not appear to be a problem with the number or size of the redo logs. Anyone has any idea what may be a possible problem? checkpoint? thanks. susan __________________________________ Do you Yahoo!? The all-new My Yahoo! - Get yours free! http://my.yahoo.com -- http://www.freelists.org/webpage/oracle-l