HiRDB single server configuration

Backup acquisition units: A backup is made of the entire system (all RDAREAs). The obtained log point information file is used to release the system log files.

Backup acquisition interval: We recommend that you make a backup daily at a specified time.; The backup acquisition interval depends on the system log file size; the larger the system log file size, the longer the backup acquisition interval can be. Set the backup acquisition interval so that the system will never run out of files in swappable target status.

Number of system log files: We recommend that the total number of system log files be more than double the number of system log files needed for one day.; For example, if two system log files are used per day, provide at least four system log files.

Database recovery in the event of an error: If a database error occurs during operation without unloading the system log, the database must be recovered from its backup copy and the unload log files that contain system log information obtained since the backup was made. For details on the database recovery procedure, see 21. Database Recovery Procedures.

Example: The following figure shows the procedure for operation without unloading the system log in a HiRDB single server configuration.; Figure 3-4 Procedure for operation without unloading the system log (HiRDB single server configuration)

Note: The numbers to the left of the process boxes correspond to the paragraph numbers of the explanations on the following pages. For example, step 5 is explained in paragraph (5) below.

Organization of this subsection: (1) Swap the system log files; (2) Check the status of the system log file; (3) Make a backup; (4) Release the system log file; (5) Check the status of the system log file; (6) Check for files in swappable target status

(1) Swap the system log files

Before a backup copy is made, the pdlogswap command is used to swap the system log files.

System log files are swapped in order to physically separate the system logs needed for database restoration. The system log files storing the system log information needed for database restoration are those that become primary from this point on:

 
pdlogswap -d sys -w

(2) Check the status of the system log file

The pdlogls command is used to check the status of the system log file:

 
pdlogls -d sys

[Figure]

Explanation

Files log01 and log02 were used today, so these two files are in unload wait status.
Synchronization point dumps have been validated because the system log files were swapped by the pdlogswap -w command. In this manner, files log01 and log02 are placed in overwrite enabled status.

(3) Make a backup

The pdcopy command (database copy utility) is used to back up all RDAREAs; log point information is also obtained by specifying the -z option. For details about making backups, see 6. Backup Procedures.

 
pdcopy -m /rdarea/mast/mast01 -M r -a -b /pdcopy/backup01
-z /pdcopy/logpoint01

Explanation: -m: Specifies the name of the first HiRDB file in the master directory RDAREA.; -M: Specifies r as the backup acquisition mode.; -a: Specifies that all RDAREAs are to be backed up.; -b: Specifies the name of the backup file.; -z: Specifies the name of the log point information file.

In the event of an error in the log point information file

If an error occurs in the log point information file, it must be re-created using the backup file obtained in this step; the pdrstr -z command (database recovery utility) is used to re-create a log point information file:

 
pdrstr -b /pdcopy/backup01 -z /pdcopy/logpoint01

(4) Release the system log file

(5) Check the status of the system log file