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.