<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're on virtual machines backed up on an NFS and assuming the nfs hasn'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 <specially@processed.almost.meat> 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> > 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> 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>