To exclude a particular tablespace from full database backup.

To exclude a particular tablespace from full database backup.

In most of the environment we know few tableapces zero data change happned in test environment.
In a such environment tablespace data is not crucial. then we can avoid particular tablespace backup from
RMAN full backup.

note: the following command may override the backup policy

step1: Exclude the particular tablespace in rman level.

RMAN> CONFIGURE EXCLUDE FOR TABLESPACE SAMTBS1;

using target database control file instead of recovery catalog
Tablespace SAMTBS1 will be excluded from future whole database backups
new RMAN configuration parameters are successfully stored


step2: Then need to perform the default full backup. so now rman will backup all tablespace in
the database except the tablespace mentioned in step 1

RMAN> BACKUP DATABASE;

the below command help to view excludes tablespace with rman

To list the excludes tablespace



RMAN> show exclude;

RMAN configuration parameters for database with db_unique_name JATWAY are:
CONFIGURE EXCLUDE FOR TABLESPACE 'SAMTBS1';

Command to skip multiple tablespaces blog to same database.

RMAN> CONFIGURE EXCLUDE FOR TABLESPACE SAMTBS2;
RMAN> CONFIGURE EXCLUDE FOR TABLESPACE SAMTBS3;

Here tablespace SAMTBS2,SAMTBS3 will be excluded from backup.

Command to override (or) clear the Excluded tablespace in RMAN

 (a)Command for Override the excluded tablespaces

You can override this exclusion feature by explicitly issuing keyword NOEXCLUDE in order to take whole database backup.

RMAN>BACKUP DATABASE NOEXCLUDE;

 (b)Command for Clear the Excluded SAMTBS1 tablespace 

RMAN>CONFIGURE EXCLUDE FOR TABLESPACE SAMTBS1 CLEAR;

Command to backup READONLY and OFFLINE tablespaces

RMAN>BACKUP DATABASE SKIP READONLY, SKIP OFFLINE;