Restoring database from a checkpoint

From: chapman@acf2.nyu.edu (chapman)
Subject: Restore old checkpoint
Date: 11 Nov 1995 15:35:17 GMT
Organization: New York University

How can one restore from a checkpoint (Ingres 6.05) earlier than the 
most recent one?  (i.e. to return a database to a known previous state)

Thanks.  - Gary Chapman, New York University

First of all i think you use ingres 6.4/05.
for the restoring of an older checkpoint you need various things:

select the checkpoint you've taken as an online or offline ckp

in case of an online, you need ../ingres/dmp/default/* 
( all files from the dmp-location )

in the second case (offline) you need only the ckp-file.

in both cases you need a file which is named aaaaaaaa.cnf
you'll find this file in your data location of the db you 
want to rollforward. (i.e. ../ingres/data/default/dbname).
this file holds the information about the seq.number of the ckp.

so look into your backup-list, and restore the ckp/dmp files
and take the aaaaaaaa.cnf file from a later time (because the seq.number
of the ckp is written to the cnf file AFTER doing the ckp).

..Peter
Ingres Q & A
To William's Home Page
Email William