Nonstop Database, HiRDB Version 9 System Operation Guide

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

6.4.8 Example 8 (backing up specified RDAREAs)

Specified RDAREAs (rdarea01 and rdarea02) are backed up during HiRDB operation. You must also back up all RDAREAs that are related to the RDAREAs that have been processed. For details about the RDAREAs that must be backed up, see 6.3 RDAREAs to be backed up together.

Organization of this subsection
(1) Identifying RDAREAs related to the RDAREAs to be backed up
(2) Using the pdhold -c command to place the RDAREAs to be backed up in shutdown and closed status
(3) Using the pdlogswap command to swap the system log files at the server that contains the RDAREAs to be backed up
(4) Using the pdcopy command to back up specified RDAREAs
(5) Using the pdrels -o command to release shutdown and open RDAREAs

(1) Identifying RDAREAs related to the RDAREAs to be backed up

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

If you need to back up more RDAREAs than the following example shows, add their names following the -r option, as needed.

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

(2) Using the pdhold -c command to place the RDAREAs to be backed up in shutdown and closed status

This operation is necessary when x (referencing/updating-impossible) is specified as the backup acquisition mode; it is not necessary when r (referencing-permitted mode) or s (updatable mode) is specified as the backup acquisition mode.

 
pdhold -r rdarea01,rdarea02 -c
 

(3) Using the pdlogswap command to swap the system log files at the server that contains the RDAREAs to be backed up

System log files are swapped in order to physically separate the system logs needed for database restoration. To restore the RDAREAs from the backup copy to be created in step (4), the system log information collected subsequently (the system log information in the file to be used as the current file after swapping) will be used as input information.

 
pdlogswap -d sys -s bes1 -w
 

(4) Using the pdcopy command to back up specified RDAREAs

 
pdcopy -m /rdarea/mast/mast01 -M x -r rdarea01,rdarea02
-b /pdcopy/backup01 -p /pdcopy01
 

Explanation
-m: Specifies the name of the first HiRDB file in the master directory RDAREA.
-M: Specifies the referencing/updating-impossible mode as the backup acquisition mode.
-r: Specifies the RDAREAs (rdarea01 and rdarea02) that are to be backed up.
-b: Specifies the name of the backup file.
-p: Specifies the output file name for the pdcopy command's processing results listing.

Remarks
When the automatic log unloading facility is being used, execute the pdlogatul command to record the unload log file name that corresponds to the current system log file when backup is being made.

(5) Using the pdrels -o command to release shutdown and open RDAREAs

This operation is necessary when x (referencing/updating-impossible) is specified as the backup acquisition mode; it is not necessary when r (referencing-permitted mode) or s (updatable mode) is specified as the backup acquisition mode.

 
pdrels -r rdarea01,rdarea02 -o
 

We recommend that after the command has executed you check whether the execution results are correct. For details on how to check command execution results, see the manual HiRDB Version 9 Command Reference.