Sunday, June 17, 2012

Excluding Tablespace from RMAN Backup

You have a tablespace with test data that you don't need to backup. You can exclude such tablespaces from a whole backup of the database.

First find out any tablespace are already configured to be excluded from backups:

RMAN> show exclude;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name TEST are:
RMAN configuration has no stored or default parameters

Use following command to exclude tablespace from whole database.

RMAN> configure exclude  for tablespace users;

Tablespace USERS will be excluded from future whole database backups
new RMAN configuration parameters are successfully stored

To make confirm tablespace exclude in your RMAN backup

RMAN>  show exclude;

RMAN configuration parameters for database with db_unique_name TEST are:
CONFIGURE EXCLUDE FOR TABLESPACE 'USERS';

Now you want to include a previously excluded tablespace in your backup by using the following command.

RMAN> configure exclude  for tablespace users clear;


Tablespace USERS will be included in future whole database backups
old RMAN configuration parameters are successfully deleted

RMAN> show exclude;
RMAN configuration parameters for database with db_unique_name TEST are:
RMAN configuration has no stored or default parameters



You want include all tablespace even you configured exclude tablespace. You use the 'noexclude' option as part of a backup database command.

RMAN>backup database noexclude;

No comments:

Post a Comment