Quote:>Hi,
> We are trying to simulate a disaster situation where we recover from a
>full system backup say for a friday night and then recover from checkpoint
>tapes up to the day of the disaster, say the Wednesday of the next week. We
>are having problems rollforwarding the checkpoint from what seems is that
>the checkpoint sequence number is higher than what is in the .cnf database
>file from the full system backup. We are using the rollforward +c option
>and restoring from mag tape.
> This seems a little crazy not being able to rollforward from a
>checkpoint where the checkpoint number is greater than what is in the .cnf
>file. Is there anything we can do?
>Kyle Hanson
Kyle,
The proper backup procedure for an Ingres database is not explicitly explained
in the manuals. You can gleen it by reading every word of every manual ;-}
The proper backup procedure is:
1. run "ckpdb yourdb" and put the output to safe media
2. backup the dmp and jnl directories for yourdb to safe media
3. backup the output of "infodb yourdb" to safe media
Without all this information, you cannot recover from a disaster (where more than
one device fails). Simply put, rollforwarddb REQUIRES the checkpoint information
to recover a checkpoint. This information is written to the aaaaaaaa.cnf file
in both the default data locate and the dmp file directory, but it is written
AFTER ckpdb completes its backup operations. So the information on your checkpoint
tape is not sufficient.
Even with this information, you need to regularly backup your journal files
should you wish to recover to a specific period in time.
Lastly, if you haven't safely configured your installation accoring to CA
guidelines, you cannot recover "up to the minute" if a single device fails.
Years ago, I presented papers at CA World about backup and recovery. Would
anyone be interested in attending such a session this year? I could redo
my paper and add some new information for OpenIngres, etc. and present it
again this year.
Caribou Lake Software http://www.cariboulake.com Java, Oracle, Ingres
Minneapolis, Minnesota (612) 323-9713
Java: It's better than cool.
by