[Info-ingres] Recover Database

[Paul White]

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 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20220126/27df8732/attachment-0001.html>