Blocked:CKPT problem
Posted in 2010
Topics: Server Administration, Logging & Checkpoints
Hi All,
My instance needs checkpoint, although i executed "onmode -c" to force
checkpoint, I still have a problem.
Blocked:CKPT ARCHIVE
$onmode -c;
Warning: checkpoint appears to be stalled and is not complete.
Is there any way to resolve this without the option of "onmode -ky"?
I've seen lots of process with "C--P---" status. How do i find which process
is causing the blocking. I did try to do "onmode -c unblock" but it didn't fix
the problem..
thanks a lot.
Hi,
did you check if logical logs are backupped ?
Jacques
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of JACK PAPA
Sent: Thursday, June 03, 2010 12:32 PM
To: ids@iiug.org
Subject: Blocked:CKPT problem [20289]
Hi All,
My instance needs checkpoint, although i executed "onmode -c" to force
checkpoint, I still have a problem.
Blocked:CKPT ARCHIVE
$onmode -c;
Warning: checkpoint appears to be stalled and is not complete.
Is there any way to resolve this without the option of "onmode -ky"?
I've seen lots of process with "C--P---" status. How do i find which process
is causing the blocking. I did try to do "onmode -c unblock" but it didn't fix
the problem..
thanks a lot.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Yes!, i've checkd and all seems backed up.