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.