How to remove checkpoint

How to remove checkpoint 'Quiescent (CKPT REQ)' during database startup after crash cause I've been waiting for more than 100 minutes, but the database still blocked 'checkpoint state'

Hi, What was the cause of the crash ? What is written in online.log ? Is there a af dump ? Does onstat -g act react ? Which IDS version are you using ? Sorry, could be anything ... Marcus -----Original Message----- From: Wahyu Cahyadi [mailto:wahyu@takaful.com] Sent: Monday, June 11, 2007 5:31 PM To: ids@iiug.org Subject: How to remove checkpoint [9325] How to remove checkpoint 'Quiescent (CKPT REQ)' during database startup after crash cause I've been waiting for more than 100 minutes, but the database still blocked 'checkpoint state' ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Hi, Did you check if the logical logs were full ? Same state (CKQPT REQ) in that case. Jacques -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Wahyu Cahyadi Sent: maandag 11 juni 2007 17:31 To: ids@iiug.org Subject: How to remove checkpoint [9325] How to remove checkpoint 'Quiescent (CKPT REQ)' during database startup after crash cause I've been waiting for more than 100 minutes, but the database still blocked 'checkpoint state' ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.