Recovery history file

This file is created at database creation time. It is updated automatically when backup or restore operations occur on the database, or on a table space. Table space operations, such as, creation, quiesce, rename, or drop, among others, also will have an impact on this file.

In our recipe, we will deliberately corrupt a history file and recover using an existing backup.

Getting ready

Please use a sandbox environment to duplicate this experience. Allow for the downtime to restart the instance.

We will corrupt the recovery history file by copying something else into this file. We already made a backup, so we're fine. Perhaps you would like to make a precautionary copy of this file first.

How to do it...

1. Make a precautionary copy of the recovery history file:

   [db2inst1@nodedb21 ~]$ pwd
   /home/db2inst1
   [db2inst1@nodedb21 ~]$ cd /data/db2/db2inst1/NODE0000/SQL00001
   [db2inst1@nodedb21 SQL00001]$ ls -l db2rhist.asc
   -rw-r----- 1 db2inst1 dba 15362 2011-08-05 20:08 db2rhist.asc
   [db2inst1...