[Info-ingres] Recover Database

[Roy Hann]

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 missing 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 at 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 at lists.planetingres.org
>  https://lists.planetingres.org/mailman/listinfo/info-ingres