[Info-Ingres] delete_oldest_ckp deletes two checkpoints

[Paul White]

Gidday Marty,

I'd argue that the checkpoint history is quite valuable and should be
available all the time. Usually I need this info to answer a question like:
which transaction in the last week changed this particular critical record?
On rare occasions I've been asked to restore a table that was accidentally
corrupted last week but "we only just found out"

I can bring the database back any point in time using my checkpoints and
journals - but not if I delete the history. I usually dont have enough room
in the ckp or jnl locations to store all the checkpoint files I need, so I
create symbolic links to a secondary storage area which has been recovered
from backup.

I prefer not to use the function

Paul White


ps.
hows the weather? I'm up here on the "Sunshine Coast" We had 95mm rain in 24
hrs earlier this week. The inlaws are looking forward to hot christmas
dinner crammed into the dining room with fans and aircon running full
throttle.  Melbourne (well Ferny Creek)
had over 80mm in 2 days. (last christmas it snowed)

-----Original Message-----
From: info-ingres-bounces at kettleriverconsulting.com
[mailto:info-ingres-bounces at kettleriverconsulting.com]On Behalf Of
Martin Bowes
Sent: Friday, 21 December 2007 6:32 PM
To: info-ingres at kettleriverconsulting.com
Subject: Re: [Info-Ingres] delete_oldest_ckp deletes two checkpoints


Hi Paul

How can an invalid checkpoint be valuable?

If there is a problem with alterdb, then I'd put my money on it trimming
the infodb list.

Martin Bowes

-----Original Message-----
From: info-ingres-bounces at kettleriverconsulting.com
[mailto:info-ingres-bounces at kettleriverconsulting.com] On Behalf Of On
Web
Sent: 20 December 2007 19:51
To: info-ingres at kettleriverconsulting.com
Subject: Re: [Info-Ingres] delete_oldest_ckp deletes two checkpoints

"On Web" <ac297 at dial.pipex.commm> wrote in message
news:l7y9j.11303$Hc3.3455 at newsfe1-gui.ntli.net...
> It would have been even better if it had said:
>
> C:\admin>alterdb mstreet -delete_oldest_ckp
> Mon Dec 17 04:00:02 2007 E_DM1405_ALT_CKP_DELETED Database 'mstreet',
> invalid checkpoint set 47 deleted.
> Mon Dec 17 04:00:02 2007 E_DM1405_ALT_CKP_DELETED Database 'mstreet',
> checkpoint set 48 deleted.
>
> Paul

Maybe there should be a failsafe here?

If I have three checkpoints and one is invalid, I may well think that I
will
be left with two checkpoints, but in reality I'm only going to have one.
Maybe the one I didn't ask to be deleted is valuable?

Paul



_______________________________________________
Info-Ingres mailing list
Info-Ingres at kettleriverconsulting.com
http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres

_______________________________________________
Info-Ingres mailing list
Info-Ingres at kettleriverconsulting.com
http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres