HPlogo ALLBASE/SQL Database Administration Guide: HP 9000 Computer Systems > Appendix F SQLUtil

RESTORE PARTIAL

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

Copies a subset of a DBEnvironment to disk from tape or from disk files that were created using the SQLUtil STORE, STOREONLINE, STORE PARTIAL, or STOREONLINE PARTIAL commands.

Scope

SQLUtil Only

SQLUtil Syntax - RESTORE PARTIAL

>> RESTORE PARTIAL [Position Option] DBEnvironment Name: DBEnvironmentName From File Name: StoreFileName Enter File to Restore or Carriage Return to Finish: SystemFileName Enter File to Restore or Carriage Return to Finish:

Parameters

PositionOption

indicates the position on the backup device from which to begin the restore operation. Valid only when the backup option has been set to OMNIBACK.

DBEnvironmentName

is the name of the DBEnvironment to be restored. The DBEnvironment name may be entered either as an absolute pathname or as a pathname relative to your current working directory.

StoreFileName

is the name of the file or tape device where the stored DBEnvironment files reside. This filename may be either an absolute pathname or a pathname relative to your current working directory.

SystemFileName

is the physical name of the DBEFile to be restored. You may enter a list of file names, one name per line, with a null line to terminate the list. Use the STOREINFO command to get the names of the files stored.

Description

  • This command allows you to restore all, or a subset of, the DBEFiles previously stored with the SQLUtil STORE, STOREONLINE, STORE PARTIAL or STOREONLINE PARTIAL command.

  • DBEFiles must be restored individually, on a file by file basis; you cannot specify a DBEFileSET name to be restored.

  • When using RESTORE PARTIAL, if a DBEFile with the same name already exists in the same directory, use the PURGEFILE command to purge it before restoring it.

    When using RESTORE PARTIAL you must be in the same directory from which the DBEFiles were stored. This is usually the directory containing the DBECon file and the SYSTEM DBEFileSet.

  • The directory to which the files are being restored must have write permission for hpdb. This is accomplished by having the file permissions of the directory where the DBEFiles will reside set to mode 755, with hpdb as owner, and having a group id of bin.

  • The PositionOption is valid only when the backup option has been set to OMNIBACK; otherwise, it is ignored. Refer to the OMNIBACK User's Guide for the exact specification of a PositionOption.

Authorization

Anyone can execute the RESTORE PARTIAL command.

Example

   >> restore partial

   DBEnvironmentName: PartsDBE

   From File Name: /dev/rmt/0h

   Enter File to Restore or Carriage Return to Finish: OrderDF1

   Enter File to Restore or Carriage Return to Finish: OrderXF1

   Enter File to Restore or Carriage Return to Finish: 



   DBEnvironment restored.
Feedback to webmaster