19.3.2 Restoring in units of RDAREAs

Organization of this subsection
(1) Restoring in units of RDAREAs
(2) Restoring RDAREAs during operation without unloading the system log

(1) Restoring in units of RDAREAs

This example restores two user RDAREAs (RDAREA01 and RDAREA02) to the most recent status:

pdrstr -m /hirdb/rdarea/mast/mast01 -b /usr/hirdb/pdcopy/backup/backup01
-l /usr/hirdb/pdlogunld/unld01 -p /usr/hirdb/pdrstr/list/list01 -w /tmp/sortwork
-r RDAREA01,RDAREA02

Explanation
-m: Specifies the name of the first HiRDB file in the master directory RDAREA.
-b: Specifies the name of the backup file.
-l: Specifies the name of the unload log file. This is the name of the unload log file that was created after the backup was made.
-p: Specifies the output file name for the database recovery utility process results listing.
-w: Specifies the work directory for sorting.
-r: Specifies that RDAREAs to be restored.

When data is to be recovered in units of RDAREAs, the utility performs an internal check to determine whether all related RDAREAs are specified together (the pdrdrefls command is executed). If any related RDAREA is not specified, the KFPR26289-W message is issued and the pdrdrefls command's message is output to the database recovery utility's process results output file as the processing results. To determine which RDAREAs are missing, check the KFPT02028-W message in the process results output file. You can ignore the KFPT02004-W message. The following describes the RDAREAs and the conditions that are checked.

RDAREAs to be checked:
  • Table storage RDAREAs and index storage RDAREAs
  • Table storage RDAREAs and LOB column storage RDAREAs
  • RDAREAs storing referencing tables or referenced tables
Note that system RDAREAs and replica RDAREAs are not checked. When the -q option is specified, the checking is on the RDAREAs as specified by their original RDAREA names.
Conditions to be checked:
The RDAREAs are checked to see if all the following conditions are satisfied:
  • HiRDB was started using an option other than -r in the pdstart command
  • The -R option is omitted.
  • The RDAREAs are specified in the -r option of the pdrstr command.
  • No dictionary RDAREAs are subject to recovery.

(2) Restoring RDAREAs during operation without unloading the system log

This example restores two user RDAREAs (RDAREA01 and RDAREA02) to the most recent status. It assumes that the HiRDB system is running without unloading the system log:

pdrstr -m /hirdb/rdarea/mast/mast01 -b /usr/hirdb/pdcopy/backup/backup01
-L -p /usr/hirdb/pdrstr/list/list01 -w /tmp/sortwork -r RDAREA01,RDAREA02

Explanation
-m: Specifies the name of the first HiRDB file in the master directory RDAREA.
-b: Specifies the name of the backup file.
-L: Specifies that the system log file is to be read.
-p: Specifies the output file name for the database recovery utility process results listing.
-w: Specifies the work directory for sorting.
-r: Specifies that all RDAREAs are to be restored.