STORE and TurboSTORE/iX Products Manual (B5151-90003)

178 Chapter11
Restoring Files
RESTORE Command Options
resulting in a horizontal cut in the directory structure.
Restoring Part of a Database (PARTIALDB)
By default, RESTORE does not allow you to restore only part of a TurboIMAGE or
ALLBASE/SQL database. The root file or DBE file and all dataset files must be specified,
either by specifying just the root or DBE file, or by specifying a wildcard that includes all
files in a database. However, if you need to restore only certain files from a database, then
you can specify the PARTIALDB option to override the default behavior.
WARNING Database corruption may result if not all database files are stored
and restored. Be sure that you only want to store certain database
files before overriding the default behavior with the PARTIALDB
option.
Refer to the "Storing Database Files Using PARTIALDB or FULLDB" section in Chapter 6
for more information on using the PARTIALDB option.
NOTE Quiescing an ALLBASE/SQL database and storing the ALLBASE/SQL
database by TurboSTORE/iX 7x24 True-Online Backup when the
DBEnvironment is in normal use, has the same effect as using the
STOREONLINE command of SQLUtil. For a 7x24 true-online backup of
ALLBASE/SQL to be of use for rollforward recovery, use the same procedures
you would use when doing the STOREONLINE commands. (Refer to Chapter 7,
"TurboSTORE/iX 7x24 True-Online Backup," for more information on
quiescing.)
Restoring using a disk directory file (STOREDIRECTORY)
The STOREDIRECTORY option can be used to specify which store disk directory file to be
used when restoring files from a backup. The backup must have been created using the
STOREDIRECTORY option. See Chapter 6 for more information on creating backups with the
STOREDIRECTORY option.
If this option is not specified, then RESTORE will look in the default location for a disk
directory file for this backup. The default file that it will look for is:
/SYS/HPSTORE/store_dirs/store_yyymmdd_hhmmsstt_pin##_day
The date, time, and pin number used to create this name are read from the store label of
the media mounted for a backup. If the disk directory file exists on the system, RESTORE
will read the media directory information from that file instead of from the backup media.
RESTORE will then skip the media directory on the backup media and begin to restore
files.
When restoring backups created with a 7x24 true-online backup sync point at the end of
the backup, it is particularly important that a disk directory file exist on the system where
the files are being restored. When restoring sync-at-end backups, RESTORE needs to
know which files need to have after image log data applied to them, before it restores any