Nonstop Database, HiRDB Version 9 System Operation Guide

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

15.5.3 Recovering an RDAREA that was not backed up during RDAREA name modification

This subsection explains how to restore to their most recent state the following RDAREAs after name modification, if they were not backed up during the name modification:

In this case, the database must be restored in two stages.

  1. Restore the database to the state it was in immediately before the RDAREA name was modified (before the pdmod command was executed).
  2. Modify the RDAREA name and manually reflect the subsequent updates.

Each of these steps is explained in more detail below.

Organization of this subsection
(1) Restore the database to the state it was in immediately before the RDAREA name was modified (before the pdmod command was executed)
(2) Modify the RDAREA name and manually reflect the subsequent updates

(1) Restore the database to the state it was in immediately before the RDAREA name was modified (before the pdmod command was executed)

Using the backup files and unload files that were acquired, restore the master directory RDAREA, the data dictionary RDAREA, and the RDAREA whose name was modified, in that order, to the state they were in immediately before the name modification. If you try to restore the RDAREA whose name was modified without first restoring the data dictionary RDAREA, you cannot shut down the RDAREA.

To restore the database:

  1. Use the pdstop command to terminate HiRDB normally.
  2. Use the pdstart -r command to start HiRDB.
  3. Restore the master directory RDAREA to the state it was in immediately before the name modification.
    Execute the database recovery utility (pdrstr) with the -T option specified. In the -T option, specify the time that was 1 second prior to the RDAREA name modification.
  4. Use the pdstop command to terminate HiRDB normally.
  5. Use the pdstart command to start HiRDB normally.
  6. Use the pdhold and pdclose commands to place the data dictionary RDAREA in shutdown and closed status.
  7. Restore the data dictionary RDAREA to the state it was in immediately before the name modification.
    Execute the database recovery utility (pdrstr) with the -T option specified. In the -T option, specify the time that was 1 second prior to the RDAREA name modification.
  8. Use the pdhold and pdclose commands to place the RDAREA whose name was modified in shutdown and closed status.
  9. Restore the RDAREA whose name was modified to the state it was in immediately before the name modification.
    Execute the database recovery utility (pdrstr) with the -T option specified. In the -T option, specify the time that was 1 second prior to the RDAREA name modification.
  10. Use the pdrels and pdopen commands to release the RDAREAs from shutdown status and place it in open status.

(2) Modify the RDAREA name and manually reflect the subsequent updates

Use the pdmod command to change the RDAREA name and manually reflect the updates that had been made up until the point when the error occurred.