 |
» |
|
|
|
Copies an entire DBEnvironment to disk from tape
or from disk
files created by using the SQLUtil STORE or STOREONLINE command. Scope | |
SQLUtil Only SQLUtil Syntax | |
>> RESTORE DBEnvironment Name: DBEnvironmentName From File Name: StoreFileName New DBECreator Name: NewDBECreatorName Restore DBEnvironment (y/n)? { Y[es] N[o] } Parameters | |
- DBEnvironmentName
is the name of the DBEnvironment to be restored.
The DBEnvironment
name may be either an absolute pathname or a pathname relative to
your current working directory; however, the pathname must be
entered exactly as it was entered when the DBEnvironment was
stored.
- StoreFileName
is the name of the file or tape device where the stored DBEnvironment
resides. This filename may be either an absolute pathname or a
pathname relative to your current working directory.
- NewDBECreatorName
is the name of the user assigned as the DBECreator of the
DBEnvironment being restored. This prompt appears only if the
user performing the RESTORE is the superuser, and it continues
to appear until the superuser enters either a valid DBECreatorName
or // to quit.
Description | |
This command allows you to restore the DBECon file and
all DBEFiles of a DBEnvironment that was
saved with the SQLUtil STOREONLINE or STORE command.
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.
If the user restoring the
DBEnvironment is the superuser, the user is prompted for
a new DBECreator name for the DBEnvironment. The entered name
is checked against the password file on the system for validity.
If the entered name is not valid, an error message appears and
the prompt for a new DBECreator name will reappear until either
a valid user name or // is entered. If the user restoring the
DBEnvironment is not the superuser,
no prompt appears for a new DBECreator name. The current
DBECreator of the DBEnvironment being restored will remain
the DBECreator in the new DBECon file.
If a DBEnvironment with the same name
already exists
in the same directory,
the user must use the
PURGEDBE command to purge it before RESTORE will successfully
execute.
If the HP-UX directory structure of the DBEnvironment
does not exist on the system to which the DBEnvironment is being
restored, it will be created. If the directory structure does
already exist, the user hpdb must have write permission to the
directory. This is accomplished by having the file permissions
of the directory where the DBEnvironment will reside set to
mode 755, having hpdb as owner, and having a group id of bin.
Authorization | |
Anyone can restore a DBEnvironment.
But only the superuser can change the DBECreator name. Example | |
>> restore
DBEnvironment Name: PartsDBE
From File Name: /dev/rmt1
Restore DBEnvironment (y/n)? y
DBEnvironment restored.
|
|
