From Newsgroup: comp.databases.ingres

Is it possible to save a checkpoint file in a backup directory then destroy
the database, create the database and then use this checkpoint file to recover the database the state prior to the destroy?

Rich
--- Synchronet 3.21b-Linux NewsLink 1.2

From Newsgroup: comp.databases.ingres

Hi Rich,
Short answer: Don't.
This is not the right way to do it as there are huge problems in getting the database to believe the checkpoint file is cool. You could end up with a very scrambled database configuration file
This is not what a checkpoint file is for. A checkpoint file is created so that you can do time based recoveries using th edatabsse journals.
What you want is a static backup created with either unloaddb or copydb. Those are designed for exactly this sort of task.
Marty
-----Original Message-----
From: Rich Ford <richford990@gmail.com>
Sent: 25 January 2022 14:02
To: info-ingres@lists.planetingres.org
Subject: [Info-ingres] Recover Database
Is it possible to save a checkpoint file in a backup directory then destroy the database, create the database and then use this checkpoint file to recover the database the state prior to the destroy?
Rich
_______________________________________________
Info-ingres mailing list
Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres
--- Synchronet 3.21b-Linux NewsLink 1.2

From Newsgroup: comp.databases.ingres

On Tuesday, 25 January 2022 at 06:12:09 UTC-8, Martin Bowes wrote:

Hi Rich,

Short answer: Don't.

This is not the right way to do it as there are huge problems in getting the database to believe the checkpoint file is cool. You could end up with a very scrambled database configuration file

This is not what a checkpoint file is for. A checkpoint file is created so that you can do time based recoveries using th edatabsse journals.

What you want is a static backup created with either unloaddb or copydb. Those are designed for exactly this sort of task.

Marty
-----Original Message-----
From: Rich Ford <richf...@gmail.com>
Sent: 25 January 2022 14:02
To: info-...@lists.planetingres.org
Subject: [Info-ingres] Recover Database

Is it possible to save a checkpoint file in a backup directory then destroy the database, create the database and then use this checkpoint file to recover the database the state prior to the destroy?

Rich
_______________________________________________
Info-ingres mailing list
Info-...@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres

Thanks for the quick reply.

Rich
--- Synchronet 3.21b-Linux NewsLink 1.2

From Newsgroup: comp.databases.ingres

On Jan 25, 2022, at 9:01 AM, Rich Ford <richford990@gmail.com> wrote:

Is it possible to save a checkpoint file in a backup directory then destroy the database, create the database and then use this checkpoint file to recover the database the state prior to the destroy?

Possible, yes. It's not the simplest thing in the world to get right,
and you can't just rollforwarddb the checkpoint. I don't advise it
unless there is no other way to recover, and then I'd want to get
Tech Support involved.
Karl
--- Synchronet 3.21b-Linux NewsLink 1.2

From Newsgroup: comp.databases.ingres


Ah yes, the dreaded database identifier and binary editing of database
(CNF?) files....keep you all night long that will.


-----Original Message-----
From: info-ingres-bounces@lists.planetingres.org <info-ingres-bounces@lists.planetingres.org> On Behalf Of Karl Schendel
Sent: 25 January 2022 14:50
To: Ingres and related product discussion forum <info-ingres@lists.planetingres.org>
Subject: Re: [Info-ingres] Recover Database

On Jan 25, 2022, at 9:01 AM, Rich Ford <richford990@gmail.com> wrote:

Is it possible to save a checkpoint file in a backup directory then
destroy the database, create the database and then use this checkpoint

file to recover the database the state prior to the destroy?


Possible, yes. It's not the simplest thing in the world to get right, and
you can't just rollforwarddb the checkpoint. I don't advise it unless there
is no other way to recover, and then I'd want to get Tech Support involved.

Karl

_______________________________________________
Info-ingres mailing list
Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres

--- Synchronet 3.21b-Linux NewsLink 1.2

From Newsgroup: comp.databases.ingres

Rich Ford wrote:

Is it possible to save a checkpoint file in a backup directory
then destroy the database, create the database and then use this
checkpoint file to recover the database the state prior to the
destroy?

Like everyone else has said, I would discourage that approach.
The preferred tool for that situation is unloaddb.

That said, your disaster recovery plan should include all the steps
required to do just what you suggest. In the event of a total loss of
the facility (fire, flood, carpet moths) you need to be able to
reinstate your database on a new machine using the checkpoint.

I get the impression you are new to the site. You should ask if
anyone else there knows where the disaster plan is.

If they don't, your next step is to become a hero by writing it.

Roy
--- Synchronet 3.21b-Linux NewsLink 1.2

From Newsgroup: comp.databases.ingres


<html>
<head>
<meta name="viewport" content="width=device-width">
<meta http-equiv="Content-Type" content="text/vnd.ui.insecure+html;charset=utf-8">
</head>
<body style="overflow-wrap:break-word; word-break: break-word;"><div class="mail_android_message" style="line-height: 1; padding: 0.5em">Rich, <br/><br/>If you&#39;re on virtual machines backed up on an NFS and assuming the nfs hasn&#39;t suffered as Roy postulates. There are possible ways of rolling back the virtual machine itself and recovering from there. <br/><br/>Allan <br/><br/>--<br/>Sent from my Android phone with <a href="http://mail.com">mail.com</a> Mail. Please excuse my brevity.</div><div class="mail_android_quote" style="line-height: 1; padding: 0.3em"><html><body>On 25/01/2022, 16:25 Roy Hann &lt;specially@processed.almost.meat&gt; wrote:</body></html><blockquote class="gmail_quote" style="margin: 0.8ex 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Rich Ford wrote:
<br>
<br> &gt; Is it possible to save a checkpoint file in a backup directory
<br> &gt; then destroy the database, create the database and then use this
<br> &gt; checkpoint file to recover the database the state prior to the
<br> &gt; destroy?
<br>
<br> Like everyone else has said, I would discourage that approach.
<br> The preferred tool for that situation is unloaddb.
<br>
<br> That said, your disaster recovery plan should include all the steps
<br> required to do just what you suggest. In the event of a total loss of
<br> the facility (fire, flood, carpet moths) you need to be able to
<br> reinstate your database on a new machine using the checkpoint.
<br>
<br> I get the impression you are new to the site. You should ask if
<br> anyone else there knows where the disaster plan is.
<br>
<br> If they don't, your next step is to become a hero by writing it.
<br>
<br> Roy
<br> _______________________________________________
<br> Info-ingres mailing list
<br> Info-ingres@lists.planetingres.org
<br> <a href="https://lists.planetingres.org/mailman/listinfo/info-ingres">https://lists.planetingres.org/mailman/listinfo/info-ingres</a>
<br>
</blockquote></div></body>
</html>
--- Synchronet 3.21b-Linux NewsLink 1.2

From Newsgroup: comp.databases.ingres

--000000000000575cab05d6729042
Content-Type: text/plain; charset="UTF-8"

This work ok for replication.

I drop a production database, which removes ckp jnl dmp tmp data. (Non x100 db).

Then:
Createdb
Ckpdb +j
Rsync from DR server:ckp dmp jnl
Copy aaaaaaaa.* from dmp to data
Infodb to make sure
Rollforwarddb to point in time
Ckpdb +j

No editing configs or iidbdb required.

Am i missing something?



On Wed, 26 Jan 2022, 2:25 am Roy Hann, <specially@processed.almost.meat>
wrote:

Rich Ford wrote:

Is it possible to save a checkpoint file in a backup directory
then destroy the database, create the database and then use this
checkpoint file to recover the database the state prior to the
destroy?

Like everyone else has said, I would discourage that approach.
The preferred tool for that situation is unloaddb.

That said, your disaster recovery plan should include all the steps
required to do just what you suggest. In the event of a total loss of
the facility (fire, flood, carpet moths) you need to be able to
reinstate your database on a new machine using the checkpoint.

I get the impression you are new to the site. You should ask if
anyone else there knows where the disaster plan is.

If they don't, your next step is to become a hero by writing it.

Roy
_______________________________________________
Info-ingres mailing list
Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres

--000000000000575cab05d6729042
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">This work ok for replication.<div dir=3D"auto"><br></div>= <div dir=3D"auto">I drop a production database, which removes ckp jnl dmp t=
mp data. (Non x100 db).</div><div dir=3D"auto"><br></div><div dir=3D"auto">= Then:</div><div dir=3D"auto">Createdb</div><div dir=3D"auto">Ckpdb +j</div>= <div dir=3D"auto">Rsync from DR server:ckp dmp jnl</div><div dir=3D"auto">C= opy aaaaaaaa.* from dmp to data</div><div dir=3D"auto">Infodb to make sure<= /div><div dir=3D"auto">Rollforwarddb to point in time</div><div dir=3D"auto= ">Ckpdb +j</div><div dir=3D"auto"><br></div><div dir=3D"auto">No editing co= nfigs or iidbdb required.</div><div dir=3D"auto"><br></div><div dir=3D"auto= ">Am i=C2=A0missing something?</div><div dir=3D"auto"><br></div><div dir=3D= "auto"><br></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" clas= s=3D"gmail_attr">On Wed, 26 Jan 2022, 2:25 am Roy Hann, &lt;specially@proce= ssed.almost.meat&gt; wrote:<br></div><blockquote class=3D"gmail_quote" styl= e=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Rich Fo=
rd wrote:<br>

&gt; Is it possible to save a checkpoint file in a backup directory<br>
&gt; then destroy the database, create the database and then use this<br>
&gt; checkpoint file to recover the database the state prior to the<br>
&gt; destroy?<br>

Like everyone else has said, I would discourage that approach.<br>
The preferred tool for that situation is unloaddb.<br>

That said, your disaster recovery plan should include all the steps<br> required to do just what you suggest. In the event of a total loss of<br>
the facility (fire, flood, carpet moths) you need to be able to<br>
reinstate your database on a new machine using the checkpoint. <br>

I get the impression you are new to the site. You should ask if<br>
anyone else there knows where the disaster plan is. <br>

If they don&#39;t, your next step is to become a hero by writing it.<br>

Roy<br>
_______________________________________________<br>
Info-ingres mailing list<br>
<a href=3D"mailto:Info-ingres@lists.planetingres.org" target=3D"_blank" rel= =3D"noreferrer">Info-ingres@lists.planetingres.org</a><br>
<a href=3D"https://lists.planetingres.org/mailman/listinfo/info-ingres" rel= =3D"noreferrer noreferrer" target=3D"_blank">https://lists.planetingres.org= /mailman/listinfo/info-ingres</a><br>
</blockquote></div>

--000000000000575cab05d6729042--
--- Synchronet 3.21b-Linux NewsLink 1.2

From Newsgroup: comp.databases.ingres

Wednesday, January 26, 2022, 2:00:06 AM, you wrote:

This work ok for replication.
I drop a production database, which removes ckp jnl dmp tmp data. (Non x100 db).
Then:
Createdb
Ckpdb +j
Rsync from DR server:ckp dmp jnl
Copy aaaaaaaa.* from dmp to data
Infodb to make sure
Rollforwarddb to point in time
Ckpdb +j
No editing configs or iidbdb required.
Am i-amissing something?

I would update iidatatabase.db_id in iidbdb to make it the database ID
of the old database. It's not a big deal but it means IPM will show
the correct database name.
And for DR purposes I'd make sure I was keeping all my Ingres user IDs
from iidbdb, and also my area and location definitions so they could
be recreated after the smoke clears.
Roy

On Wed, 26 Jan 2022, 2:25 am Roy Hann,
<specially@processed.almost.meat> wrote:
Rich Ford wrote:

Is it possible to save a checkpoint file in a backup directory
then destroy the database, create the database and then use this
checkpoint file to recover the database the state prior to the
destroy?

Like everyone else has said, I would discourage that approach.
The preferred tool for that situation is unloaddb.

That said, your disaster recovery plan should include all the steps
required to do just what you suggest. In the event of a total loss of
the facility (fire, flood, carpet moths) you need to be able to
reinstate your database on a new machine using the checkpoint.

I get the impression you are new to the site. You should ask if
anyone else there knows where the disaster plan is.

If they don't, your next step is to become a hero by writing it.

Roy
_______________________________________________
Info-ingres mailing list
Info-ingres@lists.planetingres.org
https://lists.planetingres.org/mailman/listinfo/info-ingres

--- Synchronet 3.21b-Linux NewsLink 1.2