HELPLIB.HLB  —  RMU72  Restore  Command Qualifiers, Area
    Area

    Specifies that only the storage areas listed in the storage-area-
    name parameter on the command line or in the Options file are
    to be restored. You can use this qualifier to simplify physical
    restructuring of a large database.

    By default, the Area qualifier is not specified. When the Area
    qualifier is not specified, all the storage areas and the
    database root (.rdb) file are restored. Therefore, if you want
    to restore all the storage areas, omit the Area qualifier. If
    you specify the Area qualifier, a valid database root must exist.
    (First issue the RMU Restore Only Root command with a full backup
    file to create a valid database if one does not exist.)

    By using the RMU Backup and RMU Restore commands, you can back up
    and restore selected storage areas of your database. This Oracle
    RMU backup- and restore-by-area feature is designed to:

    o  Speed recovery when corruption occurs in some (not all) of the
       storage areas of your database.

    o  Reduce the time needed to perform backup operations because
       some data (data in read-only storage areas, for example) does
       not need to be backed up with every backup operation performed
       on the database.

                                   NOTE

       When you perform a by-area restore operation, an area may
       be marked as inconsistent; that is, the area may not be at
       the same transaction state as the database root when the
       restore operation completes. This may happen, for example,
       when automatic aij recovery is disabled with the Norecovery
       qualifier, or if automatic recovery fails. You can check
       to see if an area is consistent by using the RMU Show
       Corrupt_Pages command. If you find that one or more areas
       are inconsistent, use the RMU Recover command to apply the
       .aij files. If the .aij files are not available, refer to
       the section on Clearing an Inconsistent Flag in the Oracle
       Rdb Guide to Database Maintenance for information on the
       implications of setting a corrupt area to consistent. Then
       refer to Set Corrupt_Pages for information on using the Set
       Corrupt_Pages command to clear the inconsistent flag.

    If you attempt to restore a database area that is not in the
    backup file, you receive an error message and, typically, the
    database will be inconsistent or unusable until the affected area
    is properly restored.

    In the following example, the DEPARTMENTS storage area is
    excluded from the backup operation; therefore, a warning message
    is displayed when the attempt is made to restore DEPARTMENTS,
    which is not in the backup file. Note that when this restore
    operation is attempted on a usable database, it completes, but
    the DEPARTMENTS storage area is now inconsistent.

    $ RMU/BACKUP /EXCLUDE=DEPARTMENTS MF_PERSONNEL.RDB -
    _$ PERS_BACKUP5JAN88.RBF
    $ RMU/RESTORE /NEW_VERSION /AREA PERS_BACKUP5JAN88.RBF DEPARTMENTS
    %RMU-W-AREAEXCL, The backup does not contain the storage
     area - DEPARTMENTS

    If you create a backup file by using the RMU Backup command and
    the Exclude qualifier, it is your responsibility to ensure that
    all areas of a database are restored and recovered when you
    use the RMU Restore and RMU Recover commands to duplicate the
    database.

    The Area qualifier conflicts with the After_Journal and Aij_
    Options qualifiers.
Close Help