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

(1) System configuration examples

This example assumes the cold standby configuration shown in Figure 17‒1: Example of a system configuration using the cold standby configuration with hadb01 as the active system. The DB directory, the archive directory, and the directory storing the synonym dictionary files have the following directory structures:

■ Directory structure of hadb01

DB directory configuration

/HADB/db (Built on FS001)
 ADBDIC ... Block special file (using LU002)
 ADBMST ... Block special file (using LU001)
 ADBSTBL ... Block special file (using LU003)
 ADBWORK ... Directory on the file system
 ADBWRK ... Block special file (using WRK003)
 ADBUTBL01 ... Block special file (using LU004)
 ADBUIDX01 ... Block special file (using LU005)
 SPOOL ... Directory on the file system
 ADBSYS ... Directory on the file system

Archive directory structure
```
/HADB/archive
```
The archive directory is created when defining an archivable multi-chunk table.
Synonym dictionary file storage directory structure
```
/mnt/syndict
```
The directory storing synonym dictionary files is created in order to perform synonym searches.
Audit trail directory structure
```
/mnt/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
```
Archive directory structure
```
/HADB/archive
```
The archive directory is created when defining an archivable multi-chunk table.
Mount point for synonym dictionary file storage directory
```
/mnt/syndict
```
The directory storing synonym dictionary files is created in order to perform synonym searches.
Mount point for audit trail directory
```
/mnt/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 cold standby configuration:

[Figure]

Explanation

FS001 is a file system for the DB directory.
FS002 is a file system storing temporary work files.
FS003 is a file system storing synonym dictionary files.
FS004 is a file system to which audit trail files are output.
FS005 is the following file systems:
- File system for storing input data files that are used in data import processing
- File system for storing CSV files used by the ADB_CSVREAD function
- File system where audit trail storage directory will be created
LU001 to LU005 are used for DB area files.
WRK001 is used for work table 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

The following procedure explains the procedure for using ShadowImage to make a backup.

Procedure:

Terminate the cold standby configuration normally

For details, see 17.4.2 How to terminate the cold standby configuration.
Unmount the file system subject to backup processing.
Make the backup.

Back up FS001, FS003, 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).
Start the cold standby configuration.

For details, see 17.4.1 How to start the cold standby configuration.

To Page Top

(3) Recovering the database from a backup

The following procedure explains the procedure for recovering the database from a backup.

Procedure:

Terminate the cold standby configuration.
```
adbstop
monend
```
On hadb01 (active system), execute the adbstop command and HA Monitor's monend command to terminate the cold standby configuration.

A backup cannot be acquired in quiescence mode because the file system will be unmounted in the subsequent step.
Unmount the file system subject to backup processing.
Recover the database.

Recover FS001, FS003, 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).
Start the cold standby configuration.

For details, see 17.4.1 How to start the cold standby configuration.

To Page Top