NOTE
Use these qualifiers to reconcile the information in the
database root file with the storage area files on disk.
These values can get out of synchronization when changes
have been made to storage areas or snapshot files after the
backup from which you are restoring the database root file
was created.
Setting these parameters updates the data in the root file
only; it does not change the attributes of the storage areas
or snapshot files themselves.
1 – Blocks Per Page
Blocks_Per_Page=integer
Noblocks_Per_Page
Updates the database root file with the number of blocks per
page for the storage area. Use this qualifier to update the root
when the blocks per page for a storage area has changed since
the backup file from which you are restoring was created. This
qualifier does not change the page size of a storage area itself;
its purpose is to update the database root file with corrected
information.
If you use the default, the Noblocks_Per_Page qualifier, RMU
Restore Only_Root takes the page size for the storage area from
the page size specified for the database you backed up. This is a
positional qualifier. This qualifier conflicts with storage areas
that have a uniform page format.
2 – File
File=file-spec
Updates the database root file with the file specification
for the storage-area-name parameter it qualifies. Use this
qualifier to update the root when the file specification for a
storage area has changed since the backup file from which you are
restoring the root was created. (For example, if you have used
the RMU Move_Area command since the backup file was created.)
This qualifier does not change the file specification of the
storage area it qualifies; its purpose is to update the database
root file with corrected information. When you specify the File
qualifier, you must supply a file name.
See the Usage Notes for information on how this qualifier
interacts with the Root, Snapshot, and Directory qualifiers.
This qualifier is not valid for single-file databases. This is a
positional qualifier.
3 – Read Only
Updates the database root file to reflect the read-only attribute
for the storage area it qualifies. Use this qualifier to update
the root when the read/write or read-only attribute has changed
since the backup file from which you are restoring has changed.
This qualifier does not change the attribute of the storage area
it qualifies; its purpose is to update the database root file
with corrected information.
If you do not specify the Read_Only or the Read_Write qualifier,
the storage areas is restored with the read/write attributes that
were in effect when the database was backed up.
4 – Read Write
Updates the database root file to reflect the read/write
attribute for the storage area it qualifies. Use this qualifier
to update the root when the read/write or read-only attribute
has changed since the backup file from which you are restoring
has changed. This qualifier does not change the attribute of the
storage area it qualifies; its purpose is to update the database
root file with corrected information.
If you do not specify the Read_Only or the Read_Write qualifier,
the storage areas is restored with the read/write attributes that
were in effect when the database was backed up.
5 – Snapshot
Snapshot=(Allocation=n,File=file-spec)
Updates the database root file to reflect the snapshot allocation
or snapshot file specification (or both) for the area it
qualifies. Use this qualifier to update the root when the
snapshot attributes have changed since the backup file from which
you are restoring the database root has changed. This qualifier
does not change the attributes of the snapshot file it qualifies;
its purpose is to update the database root file with corrected
information.
See the Usage Notes for information on how this qualifier
interacts with the Root, Snapshot, and Directory qualifiers.
The Snapshot qualifier is a positional qualifier.
When you do not specify the Snapshot qualifier, RMU Restore Only_
Root restores snapshot areas according to the information stored
in the backup file.
6 – Spams
Spams
Nospams
Updates the database root file to reflect the space area
management (SPAM) information for the storage areas in the
storage-area-list. Use this qualifier when the setting of SPAM
pages (enabled or disabled) has changed since the backup file
from which you are restoring the root was created. This qualifier
does not change the attributes of the storage area it qualifies;
its purpose is to update the database root file with corrected
information.
Use the Spams qualifier to update the root file information
to indicate that SPAM pages are enabled for the storage areas
qualified; use the Nospams qualifier to update the root file
information to indicate that SPAM pages are disabled for the
storage areas qualified. The default is to leave the attribute
unchanged from the setting recorded in the backup file. This is a
positional qualifier.
7 – Thresholds
Thresholds=(val1[,val2[,val3]])
Updates the database root file to reflect the threshold
information for the storage areas in the storage-area-list. Use
this qualifier when the threshold values have changed since the
backup file from which you are restoring the root was created.
This qualifier does not change the attributes of the storage area
it qualifies; its purpose is to update the database root file
with corrected information.
This is a positional qualifier.
The Thresholds qualifier applies only to storage areas with a
mixed page format.
If you do not use the Thresholds qualifier with the RMU Restore
Only_Root command, Oracle Rdb uses the storage area's thresholds
as recorded in the backup file.
See the Oracle Rdb7 Guide to Database Performance and Tuning for
more information on SPAM thresholds.