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.