Suppose you have a tablespace that contains noncritical data, and you don’t ever want to back it up. RMAN can be configured to exclude such tablespaces from the backup. To determine if RMAN is currently configured to exclude any tablespaces, run this command:
RMAN> show exclude;
RMAN configuration parameters for database with db_unique_name O12C are:
RMAN configuration has no stored or default parameters
Use the EXCLUDE command to instruct RMAN as to which tablespaces not to back up:
RMAN> configure exclude for tablespace users;
Now, for any database-level backups, RMAN will exclude the data files associated with the USERS tablespace. You can instruct RMAN to back up all data files and any excluded tablespaces with this command:
RMAN> backup database noexclude;
You can clear the exclude setting via the following command:
RMAN> configure exclude for tablespace users clear;