HELPLIB.HLB  —  RMU72  Backup  Database  Command Qualifiers, Exclude
    Exclude[=storage-area[,...]]

    Specifies the storage areas that you want to exclude from the
    backup file. If you specify neither the Exclude nor the Include
    qualifier with the RMU Backup command, or if you specify the
    Exclude qualifier but do not specify a list of storage area
    names, a full and complete backup operation is performed on the
    database. This is the default behavior.

    If you specify a list of storage area names with the Exclude
    qualifier, RMU Backup excludes those storage areas from the
    backup file and includes all of the other storage areas. If
    you specify more than one database storage area in the Exclude
    qualifier, place a comma between each storage area name and
    enclose the list of names within parentheses.

    Use the Exclude=* qualifier to indicate that you want only the
    database root file to be backed up. Note that a backup file
    created with the Exclude=* qualifier can be restored only with
    the RMU Restore Only_Root command.

    You can use an indirect command file as shown in the following
    example:

    $ RMU/BACKUP/EXCLUDE="@EXCLUDE_AREAS.OPT" -
    _$ MF_PERSONNEL.RDB PARTIAL_MF_PERS.RBF
    %RMU-I-NOTALLARE, Not all areas will be included in this backup file

    See the Indirect-Command-Files help entry for more information on
    indirect command files.

    If you use the Exclude qualifier with a list of storage area
    names, your backup file will be a by-area backup file because
    the Exclude qualifier causes database storage areas to be
    excluded from the backup file. The following example shows the
    informational message you receive if you do not back up all of
    the areas in the database:

    %RMU-I-NOTALLARE, Not all areas will be included in this backup file

    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

    If you plan to use the RMU Backup and RMU Restore commands to
    back up and restore only selected storage areas for a database,
    you should perform full and complete backup operations on the
    database at regular intervals.

    If you plan to back up and restore only selected storage areas of
    a database, Oracle Corporation also strongly recommends that you
    enable after-image journaling for the database. This ensures that
    you can recover all of the storage areas in your database if a
    system failure occurs.

    If you do not have after-image journaling enabled and one or
    more of the areas restored with the RMU Restore command are not
    consistent with the unrestored storage areas, Oracle Rdb does
    not allow any transaction to use the storage areas that are not
    consistent in the restored database. In this situation, you can
    return to a working database by restoring the database, using
    the backup file from the last full and complete backup operation
    of the database storage areas. However, any changes made to the
    database since the last full and complete backup operation are
    not recoverable.

    If you do have after-image journaling enabled, use the
    RMU Recover command (or the Restore command with the Recover
    qualifier) to apply transactions from the .aij file to storage
    areas that are not consistent after the RMU Restore command
    completes; that is, storage areas that are not in the same state
    as the rest of the restored database. You cannot use these areas
    until you recover the database. When the RMU Recover command
    completes, your database will be consistent and usable.

    Using the Exclude or Include qualifier gives you greater
    flexibility for your backup operations, along with increased
    file management and recovery complexity. Users of large databases
    might find the greater flexibility of the backup operation to
    be worth the cost of increased file management and recovery
    complexity.

    You cannot specify the Exclude=area-list and Include=area-list
    qualifiers in the same RMU Backup command.
Close Help