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.