Performing Logical Restore for a Partial-System Wa (SAP Library - SAP Database Guide: Informix (BC-DB-INF-DBA))

Performing Logical Restore for a Partial-System Warm Restore (ON-Archive)

Use

This is the final stage in a partial-system warm restore of the Informix database if you use ON-Archive as your data recovery tool (that is, for your archives and backups). There are two phases to this stage:

Backing up the "current" logical-log file

Restoring all available logical-log files to bring the database completely up to date.

Prerequisites

You have completed Performing Physical Restore for Partial-System Warm Restore (ON-Archive).

You are logged on as user informix or root .

The database server is online.

You have the following logical-log files available:

Logical-log files(s) covering the checkpoint for the database backup that was restored during the warm physical restore. If the checkpoint spans multiple logs, you need all of them.
Logical-log file(s) covering the checkpoint for the warm physical restore. If the checkpoint spans multiple logs, you need all of them.
All the logs between these two points in time.

Procedure

Phase 1: Back up Current Logical-Log File

In this phase you back up the logical-log file current when the physical restore started so that you can apply it in phase two to bring the database completely up to date.

How you proceed now depends on your normal backup procedure:

If you use continuous backup

Copy the logical-log files out to tape (vset LOGTAP ) as normal. If you use a temporary storage area on disk for the logical-log files, make sure the copy to tape has finished. You probably need to interrupt the continuous backup request to close the disk save set so you can copy it. Remember to restart the continuous backup request later.

If you use automatic backup

Start an automatic backup to tape (vset LOGTAP ), as in the following example:

$ onarchive 'backup/automatic/logfile/vset=LOGTAP/current'

ON-Archive prompts you to mount the appropriate volume:

Request 204 registered in the catalog.

Executing...

DEVICE $DEVICE NAME

1 /dev/rmt/3m

Enter the device number (1) or (C)ancel : 1

Please mount volume LOGT1 of LOGTAP and press <RETURN> **WRITE**

Logfile LF00000026 being processed.

Logfile LF00000027 being processed.

Logfile LF00000028 being processed.

Logfile LF00000029 being processed.

Logfile LF00000030 being processed.

Logfile LF00000031 being processed.

Logfile LF00000032 being processed.

Logfile LF00000033 being processed.

Logfile LF00000034 being processed.

Logfile LF00000035 being processed.

Logfile LF00000036 being processed.

Phase 2: Restore Available Logical-Log Files

After backing up the current logical-log file, you must perform a logical restore using all available logical-log files to bring the restored dbspaces online.

Enter the following command to perform the logical restore:

$ onarchive 'retrieve/logfile'

ON-Archive prompts you to mount the appropriate volumes.

Request 205 registered in the catalog.

Executing...

File LF00000022 being retrieved.

Devices available for ONARCHIVE

DEVICE $DEVICE NAME

1 /dev/rmt/3m

Enter the device number (1) or (C)ancel : 1

Please mount volume LOGT1 of LOGTAP and press <RETURN> **READ**

File LF00000023 being retrieved.

File LF00000024 being retrieved.

File LF00000025 being retrieved.

File LF00000026 being retrieved.

Devices available for ONARCHIVE

DEVICE $DEVICE NAME

1 /dev/rmt/3m

Enter the device number (1) or (C)ancel: 1

Please mount volume LOGT2 of LOGTAP and press <RETURN> **READ**

File LF00000027 being retrieved.

File LF00000028 being retrieved.

File LF00000029 being retrieved.

File LF00000030 being retrieved.

File LF00000031 being retrieved.

File LF00000032 being retrieved.

File LF00000033 being retrieved.

File LF00000034 being retrieved.

File LF00000035 being retrieved.

File LF00000036 being retrieved.

Check the results of the logical restore

You can check the results of the logical restore in the archive.log file.

Result

The restored dbspaces are now available and the database server is ready for use. You can use the R/3 System productively again.

See also:

Informix documentation