Rajib,



How do you bounce the Secondary?



Whenever I do the restore (i.e. using the same backup), I get the
same problem.



Pls advise.



Thanks.



Originally posted by Rajib Sarkar

> No .. don't do that ... I would suggest bouncing the SECONDARY
> and seeing

> if both servers sync up or not ... otherwise you'll have to do the
> physical

> restore to re-establish HDR again from scratch ...

>

> Thanx much,

>

> Rajib Sarkar

> Advisory Software Engineer (RAS)

> IBM Data Management Group

> Ph : (602)-217-2100

> Fax: (602)-217-2100

> T/L : 667-2100

>

> As long as you derive inner help and comfort from anything, keep it --

> Mahatma Gandhi

>

>

>


> antzz

> <member37779@dbfo To: informix-
> list@iiug.org

> rums.com> cc:

> Sent by: Subject: Re: Re: CKPT
> REQ - Blocked:CKPT

> owner-informix-li

> st@iiug.org

>


>


> 09/08/2003 11:42

> AM

> Please respond to

> antzz

>


>

>

>

>

>

> Rajib,

>

>

>

> I have the same problem when I restored my latest backup to the
> Primary.

> Can I just kill this user session that has the flag -X?

>

>

>

> Thanks fo your help.

>

>

>

> P.S. I can ping my secondary so my network connection seems to be
> good.

>

>

>

> Originally posted by Rajib Sarkar

>

> > This means that the instance is waiting on a CHECKPOINT to

> > complete. From

>

> > the info..it looks like an HDR pair where the Primary is

> > waiting for the

>

> > Checkpoint to complete.

>

>

> > check the onstat -u output and look for flags -X- on any of
> the

> > sessions,

>

> > which means this session is in a critical section of the code
> and the

>

> > engine is waiting on that session to finish its work and
> then

> > complete the

>

> > checkpoint ...

>

>

> > Since, its HDR another scenario could be that the primary
> is

> > waiting on the

>

> > secondary to finish its checkpoint as with checkpoints the

>

> > primary-secondary pair sync up. In this situation, I think
> u

> > better check

>

> > up your network status as well ...

>

>

> > HTH

>

>

>

> > Thanx much,

>

> > Rajib Sarkar

>

> > Advisory Support Engineer (RAS)

>

> > IBM Data Management Solutions

>

> > Ph: 602-217-2100

>

>

> > As long as you derive inner help and comfort from anything, keep
> it --

>

> > Mahatma Gandhi

>

>

>

>

>

> > Monday, June 23, 2003 10:44 AM

>

> > To: informix-list@iiug.org

>

> > cc:

>

> > Wrom: DDJBLVLMHAALPTCXLYRWTQTIP

>

> > Subject: CKPT REQ - Blocked:CKPT

>

>

>

>

> > hello,

>

> > When i run (onstat -) the return i get looks like this:

>

> > Informix Dynamic Server 2000 Version 9.21.HC5 -- On-Line
> (Prim)

>

> > (CKPT REQ) -- Up 3 days 00:31:02 -- 1102976 Kbytes

>

> > Blocked:CKPT

>

>

> > could someone enlighten me what this means when i see (CKPT REQ)
> and

>

> > Blocked:CKPT ?

>

>

> > this gets returned when the log says a checkpoint is not
> even

>

> > happening....

>

>

> > Thanks in advance!

>

> > Tom

>

>

> sending to informix-list

>

>

> --

> Posted via http://dbforums.com/http://dbforums.com

>

>

sending to informix-list


--
Posted via http://dbforums.com