<div dir="auto">This work ok for replication.<div dir="auto"><br></div><div dir="auto">I drop a production database, which removes ckp jnl dmp tmp data. (Non x100 db).</div><div dir="auto"><br></div><div dir="auto">Then:</div><div dir="auto">Createdb</div><div dir="auto">Ckpdb +j</div><div dir="auto">Rsync from DR server:ckp dmp jnl</div><div dir="auto">Copy aaaaaaaa.* from dmp to data</div><div dir="auto">Infodb to make sure</div><div dir="auto">Rollforwarddb to point in time</div><div dir="auto">Ckpdb +j</div><div dir="auto"><br></div><div dir="auto">No editing configs or iidbdb required.</div><div dir="auto"><br></div><div dir="auto">Am i missing something?</div><div dir="auto"><br></div><div dir="auto"><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, 26 Jan 2022, 2:25 am Roy Hann, <specially@processed.almost.meat> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Rich Ford wrote:<br>
<br>
> Is it possible to save a checkpoint file in a backup directory<br>
> then destroy the database, create the database and then use this<br>
> checkpoint file to recover the database the state prior to the<br>
> 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>
<a href="mailto:Info-ingres@lists.planetingres.org" target="_blank" rel="noreferrer">Info-ingres@lists.planetingres.org</a><br>
<a href="https://lists.planetingres.org/mailman/listinfo/info-ingres" rel="noreferrer noreferrer" target="_blank">https://lists.planetingres.org/mailman/listinfo/info-ingres</a><br>
</blockquote></div>