Example: performing an imported restore with ON-Bar and the Informix Storage Manager

This example shows how to set up an imported restore of an instance using ON-Bar, the Informix® Storage Manager (ISM), and file devices for the archives.

There is more than one way to perform an imported restore. This example shows the ISM catalog copy method. Another method, the bootstrap recovery method, is described in the HCL Informix Storage Manager Administrator's Guide.

Prerequisites:
  • A source machine and a target machine with the same configuration. However, the server name and number can be different.
  • A ROOTPATH that is the same on both machines.
  • The target machine has the devices and links in place for the chunks and these devices and links match those on the source machine.
  • ISM is initialized on both computers.
  • The paths to the device directories, volume names, and pool names are the same on both machines.
  • User root and user informix are ISM administrators on both machines.
In this example the directories for dbspace and log backups are:
  • <directory path>/dbspaces1
  • <directory path>/logfiles1
Additional environment parameters set in the source environment are:
  • ISM_server = source computer
  • export IDS_server
Additional environment parameters set on the target machine are:
  • ISM_client = source computer
  • export IDS_client
  • SM_server = target computer
  • export ISM_server
  1. As user informix, perform level-0 backup on the source machine.
  2. As user root, stop ISM on both computers by running this command: %ism_shutdown
  3. As user root, compress the appropriate ISM directories on the source machine as follows:
    %cd /nsr
    %tar -cvf nsr.tar index mm
  4. FTP the nsr.tar file from the previous step to target machine in binary mode.
  5. As user root, unpack the nsr.tar file on the target machine as follows:
    %cd /nsr
    %tar -xvf nsr.tar
  6. As user root on the source machine, tar the backup directories (devices) as follows:
    %tar -cvf logfiles1.tar logfiles1
    %tar -cvf dbspaces1.tar dbspaces1
  7. FTP the archived directories from the previous step to the target machine in binary mode.
  8. As user root on the target machine, overwrite the existing log and archive directories with the directories from the source machine, as follows:
    %tar -xvf logfiles1.tar
    %tar -xvf dbspaces1.tar
  9. As user root on the target machine
    1. Start ISM by running this command: ism_startup
    2. Run the ism_show -devices command to show the devices as mounted.
  10. On the target machine, create a file (for example, nsr.txt) with this content:
    create type: NSR client; name: source_machine;
    remote access: root@target_machine, informix@target_machine;
  11. As user informix on the target machine, run this command:
    %nsradmin -s target_machine -i nsr.txt
    

    The command returns this output: created resource id <IP information>

  12. As user informix, FTP the following files from the $INFORMIXDIR/etc directory on the source machine to the $INFORMIXDIR/etc directory on the target machine
    • ixbar,servernum
    • oncfg_servername,servernum
  13. On the target machine change the file names for the files in the previous step to the corresponding names for the local server.
  14. Run the restore command.