16.8.4 Backup operation example (using ShadowImage) : Hitachi Advanced Database Setup and Operation Guide

(1) System configuration examples

In the multi-node configuration consisting of three nodes (hadb01, hadb02, and hadb03), the master node is set as hadb01. The DB directory, the archive directory, the directory for storing synonym dictionary files, and the audit trail directory have the following directory structures:

■ Directory structure of hadb01

DB directory configuration

/HADB/db
 ADBDIC ... Block special file (using LU002)
 ADBMST ... Block special file (using LU001)
 ADBSTBL ... Block special file (using LU003)
 ADBWORK ... Directory on the local file system (in /dev/sdb1)
 ADBWRK ... Block special file (using /dev/mapper/WRK001)
 ADBUTBL01 ... Block special file (using LU004)
 ADBUIDX01 ... Block special file (using LU005)
 SPOOL ... Directory on the local file system (in /dev/sdb1)
 ADBSYS ... System directory (file system on FS001)

Archive directory structure
```
/HADB/archive
```
The archive directory is created when defining an archivable multi-chunk table.
Synonym dictionary file storage directory structure (file system on FS002)
```
/mnt/syndict
```
The synonym dictionary file storage directory is created in environments where synonym searches will be performed.
Audit trail directory structure
```
/HADB/audit
```
The audit trail directory is created in environments where the audit trail facility is used.

■ Directory structure of hadb02

DB directory configuration

/HADB/db
 ADBDIC ... Block special file (using LU002)
 ADBMST ... Block special file (using LU001)
 ADBSTBL ... Block special file (using LU003)
 ADBWORK ... Directory on the local file system (in /dev/sdb1)
 ADBWRK ... Block special file (using /dev/mapper/WRK002)
 ADBUTBL01 ... Block special file (using LU004)
 ADBUIDX01 ... Block special file (using LU005)
 SPOOL ... Directory on the local file system (in /dev/sdb1)
 ADBSYS... Mount point to the system directory

Archive directory structure
```
/HADB/archive
```
The archive directory is created when defining an archivable multi-chunk table.
File system mount point for synonym dictionary file storage directory
```
/mnt/syndict
```
The synonym dictionary file storage directory is created in environments where synonym searches will be performed.
Audit trail directory structure
```
/HADB/audit
```
The audit trail directory is created in environments where the audit trail facility is used.

■ Directory structure of hadb03

DB directory configuration

/HADB/db
 ADBDIC ... Block special file (using LU002)
 ADBMST ... Block special file (using LU001)
 ADBSTBL ... Block special file (using LU003)
 ADBWORK ... Directory on the local file system (in /dev/sdb1)
 ADBWRK ... Block special file (using /dev/mapper/WRK003)
 ADBUTBL01 ... Block special file (using LU004)
 ADBUIDX01 ... Block special file (using LU005)
 SPOOL ... Directory on the local file system (in /dev/sdb1)
 ADBSYS... Mount point to the system directory

Archive directory structure
```
/HADB/archive
```
The archive directory is created when defining an archivable multi-chunk table.
File system mount point for synonym dictionary file storage directory
```
/mnt/syndict
```
The synonym dictionary file storage directory is created in environments where synonym searches will be performed.
Audit trail directory structure
```
/HADB/audit
```
The audit trail directory is created in environments where the audit trail facility is used.

■ Logical unit configuration

The following figure shows an example of storage configuration in the multi-node configuration:

[Figure]

Explanation

The file system for the system directory is created on FS001.
The file system for storing synonym dictionary files is created on FS002.
LU001 to LU005 are used for DB area files.
The sub-volumes that correspond to the primary volumes FS00X and LU00X are FS10X and LU10X.

To Page Top

(2) Making a backup

Back up FS001, FS002, and all logical units LU001 to LU005 by following the procedure described in (3) Making a backup under 10.3.4 Backup operation example (using ShadowImage).

To Page Top

(3) Recovering the database from a backup

Recover FS001, FS002, and all logical units LU001 to LU005 by following the procedure described in (4) Recovering a database from a backup under 10.3.4 Backup operation example (using ShadowImage).

If you are using synonym searches, after recovering the database, execute the adbsyndict command on the master node hadb01 to synchronize the synonym dictionary files. For details about how to synchronize the synonym dictionary files, see 16.24.5 Synchronizing synonym dictionary files.

To Page Top