Example 4: Recovering specified RDAREAs

Nonstop Database, HiRDB Version 9 System Operation Guide

21.6.4 Example 4: Recovering specified RDAREAs

This example recovers user RDAREAs (rdarea01 and rdarea02) to the most recent synchronization point before an error occurred. The system log is being unloaded.

In addition to these RDAREAs, you must also recover all related RDAREAs at the same time. For details about the related RDAREAs, see 6.3 RDAREAs to be backed up together.

Organization of this subsection: (1) Identify the RDAREAs related to the RDAREAs to be recovered; (2) Use the pdclose command to close RDAREAs in error shutdown status; (3) Use the pdlogls command to check for the current system log file; (4) Use the pdlogswap command to swap system log files; (5) Use the pdlogunld command to unload what was the current system log file; (6) Recover RDAREAs to the backup point; (7) Use pdrstr command to recover RDAREAs to most recent synchronization point; (8) Back up recovered RDAREAs; (9) Use the pdrels command to open recovered RDAREAs by releasing them from error shutdown status

(1) Identify the RDAREAs related to the RDAREAs to be recovered

Perform this operation only on user RDAREAs and user LOB RDAREAs (the original RDAREAs of user RDAREAs and the original RDAREAs of user LOB RDAREAs if the inner replica facility is used). If a row-partitioned table is defined, execute the pdrdrefls command with the -t option to identify the RDAREAs comprising the row-partitioned table.

If you need to recover more RDAREAs than the following example shows, add their names following the -r option.

 
pdrdrefls -k chk -e org -c ref
-r rdarea01,rdarea02

(2) Use the pdclose command to close RDAREAs in error shutdown status

 
pdclose -r rdarea01,rdarea02

(3) Use the pdlogls command to check for the current system log file

In the case of a HiRDB parallel server configuration, check the system log files at the dictionary and back-end servers.

 
pdlogls -d sys

(4) Use the pdlogswap command to swap system log files

To unload the current file, swap system log files. In the case of a HiRDB parallel server configuration, swap system log files at the back-end servers where rdarea01 and rdarea02 are located.

 
pdlogswap -d sys

(5) Use the pdlogunld command to unload what was the current system log file

Unload the current system log file identified in step (3).

 
pdlogunld -d sys -g log01 -o /unld/unldlog02

(6) Recover RDAREAs to the backup point

Use another product's restore facility to recover rdarea01 and rdarea02 to a backup acquisition point.

(7) Use pdrstr command to recover RDAREAs to most recent synchronization point

 
pdrstr -m /rdarea/mast/mast01 -l /unld/unldlog01,/unld/unldlog02
-w /tmp/sortwork -r rdarea01,rdarea02

Explanation: -m: Specifies the name of the first HiRDB file in the master directory RDAREA.; -l: Specifies the names of the unload log files.; -w: Specifies the name of the work directory for sorting.; -r: Specifies the names of the RDAREAs (rdarea01 and rdarea02) to be recovered.

(8) Back up recovered RDAREAs

Use another product's backup facility to back up rdarea01 and rdarea02.

(9) Use the pdrels command to open recovered RDAREAs by releasing them from error shutdown status

 
pdrels -r rdarea01,rdarea02 -o