o To use the RMU Restore Only_Root command for a database, you
must have the RMU$RESTORE privilege in the root file access
control list (ACL) for the database or the OpenVMS SYSPRV or
BYPASS privilege.
o The RMU Restore Only_Root command provides two qualifiers,
Directory, and Root, that allow you to specify the target for
the restored database root file. In addition, the Directory,
File, and Snapshot file qualifiers allow you to specify a
target for updates to the database root for the storage
area and snapshot file locations. The target can be just a
directory, just a file name, or a directory and file name.
If you use all or some of these qualifiers, apply them as
follows:
- Use the Root qualifier to indicate the target for the
restored database root file.
- Use local application of the File qualifier to specify the
current location of a storage area file if its location
has changed since the database was backed up. The storage
area is not affected by this qualifier. This qualifier
updates the location of the storage area as recorded in the
database root file.
- Use local application of the Snapshots qualifier to specify
the current location of a snapshot file if its location
has changed since the database was backed up. The snapshot
file is not affected by this qualifier. This qualifier
updates the location of the snapshot file as recorded in
the database root file.
- Use the Directory qualifier to specify a default target
directory for the root file and as a default directory
for where the storage areas and snapshot files currently
reside. The default target directory is where the database
root file is restored if a directory specification is not
specified with the Root qualifier. The default directory
for the storage area and snapshot files is the directory
specification with which the root file is updated if these
files are not qualified with the Root, File, or Snapshot
qualifier. It is also the default directory with which the
Root file is updated for files qualified with the Root,
File, or Snapshot qualifier if these qualifiers do not
include a directory specification.
Note the following when using these qualifiers:
- Global application of the File qualifier when the target
specification includes a file name causes RMU Restore Only_
Root to update the file name recorded in the database root
file for all storage areas to be the same file name.
- Global application of the Snapshot qualifier when the
target specification includes a file name causes RMU
Restore Only_Root to update the file name recorded in the
database root file for all snapshot files to be the same
file name.
- Specifying a file name or extension with the Directory
qualifier is permitted, but causes RMU Restore Only_Root to
restore the database root file to the named directory and
file and update the file name recorded in the database root
file for all the storage areas and snapshot files to be the
same directory and file specification.
o When you restore a database root into a directory owned by
a resource identifier, the ACE for the directory is applied
to the database root file ACL first, and then the Oracle RMU
ACE is added. This method is employed to prevent database
users from overriding OpenVMS file security. However, this can
result in a database which you consider yours, but to which
you have no Oracle RMU privileges to access. See the Oracle
Rdb Guide to Database Maintenance for details.
o Only the database parameter values and the storage area
parameter values for which there are qualifiers can be updated
in the database root (.rdb) file using the restore-only-root
operation. All other database and storage area parameter
values that have changed since the database was last backed
up must be reapplied to the .rdb file using the SQL ALTER
DATABASE statement.
o There are no restrictions on the use of the Nospams qualifier
option with storage areas that have a mixed page format,
but the use of the Nospams qualifier typically causes severe
performance degradation. The Nospams qualifier is useful only
where updates are rare and batched, and access is primarily by
database key (dbkey).
o You must set both TSN and CSN values at the same time. You
cannot set the TSN value lower than the CSN value; however,
you can set a CSN value higher than the TSN value.
o The RMU Restore Only_Root command cannot be used if any
storage area has been extended since the backup operation
was done. You can use the RMU Dump Backup command with the
Option=Root qualifier to determine if this is the case.