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-Bar)

Use

This is the final stage in a partial-system warm restore if you use ON-Bar as your data recovery tool (that is, for your database and logical-log backups).

Prerequisites

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

You are logged on as user informix or root .

The database server is online but the dbspaces for the logical restore are offline (that is, offline chunks are marked as "inconsistent").

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.

For more information about performing a logical-log backup before you start the logical restore, see Creation of a Logical-Log Backup (ON-Bar).

Procedure

Enter the following command to perform the logical restore:

$ onbar -r -l

ON-Bar and your storage manager request the media containing the required logical-log files and perform the restore.

Check the results of the logical restore.

Here is an example from the ON-Bar activity log of a logical restore with onbar -r -l :

1998-12-18 15:29:08 16605 16603 /.../bin/onbar_d -r -l

1998-12-18 15:29:10 16605 16603 Begin backup logical log 8.

1998-12-18 15:29:11 16605 16603 Successfully connected to Storage Manager.

1998-12-18 15:29:13 16605 16603 Completed backup logical log 8.

1998-12-18 15:29:14 16614 16613 /.../bin/onbar_d -l

1998-12-18 15:29:15 16605 16603 Successfully connected to Storage Manager.

1998-12-18 15:29:59 16605 16603 Begin restore logical log 3.

1998-12-18 15:30:01 16605 16603 Completed restore logical log 3.

1998-12-18 15:30:04 16605 16603 Begin restore logical log 4.

1998-12-18 15:30:08 16605 16603 Completed restore logical log 4.

1998-12-18 15:30:12 16605 16603 Begin restore logical log 5.

1998-12-18 15:30:13 16605 16603 Completed restore logical log 5.

1998-12-18 15:30:16 16605 16603 Begin restore logical log 6.

1998-12-18 15:30:17 16605 16603 Completed restore logical log 6.

1998-12-18 15:30:20 16605 16603 Begin restore logical log 7.

1998-12-18 15:30:20 16605 16603 Completed restore logical log 7.

1998-12-18 15:30:24 16605 16603 Begin restore logical log 8.

1998-12-18 15:30:24 16605 16603 Completed restore logical log 8.

Here is an example from the message log of a logical restore with onbar -r -l :

15:29:11 Logical Log 8 - Backup Started

15:29:12 Logical Log 8 Complete.

15:29:13 Logical Log 8 - Backup Completed

15:29:13 Logical Recovery Started.

15:29:14 Start Logical Recovery - Start Log 3, End Log 8

15:29:14 Starting Log Position - 3 0xfa0cc

15:29:15 Checkpoint Completed: duration was 0 seconds.

15:30:30 Logical Recovery Complete.

15:30:32 Checkpoint Completed: duration was 0 seconds.

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