HELPLIB.HLB  —  RMU72  Restore  Only Root, File or Area Qualifiers
                                   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.
Close Help