Thursday, May 15, 2014

RMAN exclude tablespace from backup



1.Configuring the tablespace to exclude

RMAN> configure exclude for tablespace example;

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

2.While taking the whole database backup the tablespace example will be excluded

RMAN> backup
2> tag="exclude_example_tbs"
3> database;

Starting backup at 15-MAY-2014 02:54:47
using channel ORA_DISK_1
file 5 is excluded from whole database backup
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/cvrman/datafile/system.256.847354793
input datafile file number=00002 name=+DATA/cvrman/datafile/sysaux.257.847354793
input datafile file number=00003 name=+DATA/cvrman/datafile/undotbs1.258.847354795
input datafile file number=00006 name=+DATA/cvrman/datafile/tbs1.294.847433665
input datafile file number=00004 name=+DATA/cvrman/datafile/users.259.847354795
channel ORA_DISK_1: starting piece 1 at 15-MAY-2014 02:54:49



No comments: