Start of Content Area

Procedure documentation Performing Physical Restore for a Partial-System Warm Restore (ON-Bar)  Locate the document in its SAP Library structure

Use

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

Prerequisites

Procedure

  1. Check whether dbspaces you want to restore are online by entering the following at the command line:
    2.

    $ onstat -d

    For more information about the onstat command, see the Informix documentation. If a chunk to be restored is online, ON-Bar takes it offline to perform the restore.

  2. Enter the ON-Bar retrieve command, such as in the following example:

    3. $ onbar -r -p psapbtab

    To restore dbspaces that are online (see previous step), use a command like the following example:

    $ onbar -r -p -O psapbtab

    ON-Bar and your storage manager prompts you for the necessary media to complete the physical restore, including level 0, 1, and 2 database backups.

  3. Check the results of the physical restore by looking in the ON-Bar activity log or the message log. You can view the message log with SAPDBA. Refer to Listing System Information with SAPDBA.

Here is an example from the ON-Bar activity log of a physical restore with onbar -r -p -O :

1998-12-18 15:26:56 16596 16594 /.../bin/onbar_d -r -O -p psapbtab

1998-12-18 15:26:57 16596 16594 Restore psapbtap even though it is online

1998-12-18 15:26:59 16596 16594 Successfully connected to Storage

Manager.

1998-12-18 15:27:02 16596 16594 Begin warm level 0 restore psapbtab.

1998-12-18 15:27:02 16596 16594 Completed warm level 0 restore psapbtab.

1998-12-18 15:27:06 16596 16594 WARNING: Physical restore complete.

Logical restore required before work can continue.

Here is an example from the message log of a physical restore with onbar -r -p -O :

15:26:59 WARNING! Chunk 2 is being taken OFFLINE for recovery.

15:26:59 Physical Restore of psapbtab started.

15:27:03 Checkpoint Completed: duration was 0 seconds.

15:27:05 Physical Restore of psapbtab Completed.

15:27:06 Checkpoint Completed: duration was 0 seconds.

Result

Now that you have performed the physical restore, you can go on to the next stage, Performing Logical Restore for a Partial-System Warm Restore (ON-Bar).

 

See also:

Informix documentation