Nonstop Database, HiRDB Version 9 System Operation Guide

[Contents][Index][Back][Next]

21.5 Using a backup from another HiRDB system to recover a database

Executor: HiRDB administrator

If the HiRDB system that acquired a backup has the same configuration# as the HiRDB system that needs to be recovered, you can use the backup acquired using the pdcopy command and execute the pdrstr command at the other HiRDB system to recover the database. In this way, even when a hardware error has occurred on a server machine, another server machine can be used to recover the system.

#: The configuration is considered the same when the following items are the same:
  • Path (or symbolic link) for the HiRDB file comprising the RDAREA
  • HiRDB system definition
    (Note that the host name, port number, and HiRDB directory might differ between the HiRDB system that acquired the backup and the HiRDB that needs to be recovered.)
  • HiRDB version
  • HiRDB model name
 
Note
  • The backup file to be used for the recovery operation must contain all RDAREAs, including the master directory RDAREA, at a static point at which database integrity can be assured. When you recover the database, you must also recover all RDAREAs, including the master directory RDAREA.
  • This method can recover the database only to a backup acquisition point (recovery using the system log file cannot be executed).
  • If the HiRDB system that was backed up includes any list or temporary table RDAREAs, you must re-initialize those RDAREAs after you have restored all other RDAREAs.
  • If the HiRDB system to be recovered already stores data, that data is lost during the recovery process. Therefore, back up the data as needed before the recovery process.
  • Recovering a database from a backup file also recovers schemas and various access privileges of connected users. Therefore, to extract data or search for data in the database, execute a post-recovery schema.
  • Care must be exercised when using this method to recover a database, because a processing mistake will damage the database. For example, when the RDAREA to be recovered has insufficient capacity, the database recovery utility (pdrstr) will terminate normally, but the integrity of the database will be lost.
Organization of this section
21.5.1 Example (migrating a backup acquired in HiRDB system A in a test environment to HiRDB system B in an actual operating environment)