Start of Content Area

Procedure documentation Performing Physical Restore for a Partial-System Warm Restore (ON-Archive)  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-Archive as your data recovery tool (that is, for your archives and backups).

Prerequisites

Procedure

  1. Enter the retrieve command in ON-Archive , such as in the following example:
  2. $ onarchive 'retrieve/dbspaceset=SET0000011
    /dbspaces=(psapstab, psapprot)'

    You see a response like the following:

    Request 203 registered in the catalog.

    Executing...

    Any online dbspaces being retrieved will first be taken offline.

    Do you want to Proceed or Cancel this request? (P/C)p

    File psappool being retrieved.

    Devices available for ONARCHIVE

    DEVICE $ DEVICE NAME

    1 /dev/rmt/0m

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

    Please mount volume DBT2 of DBTAP and press <RETURN> *READ*

    ...

    ON-Archive prompts you for additional level-1 and level-2 volumes if required.

  3. Check the results of the physical restore.

You can check the results of the physical restore by looking in the archive.log file. The following is an example from the file:

May 14 1996 09:05:07 #00000000# <25504> ondatartr (informix) Begin retrieve dbspaces

09:07:03 #00000000# <25504> Retrieve psapstab #00000016# from DBTAP:DBT4:/dev/rmt/0m

09:08:12 #00000000# <25504> Retrieve psapprot #00000016# from DBTAP:DBT4:/dev/rmt/0m

May 14 1996 10:02:41 #00000000# <25504> ondatartr (informix) End retrieve dbspaces: SUCCESS

Result

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

 

See also:

Informix documentation