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
<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 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:<
> 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>
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't, your next step is to become a hero by writing it.<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>
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)