Exclude Tablespace from Rman Backup


C:\> rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Wed Dec 25 13:58:05 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: AZKKDB (DBID=1523131116)

RMAN> configure exclude for tablespace "EXAMPLE" ;
Tablespace EXAMPLE will be excluded from future whole database backups
new RMAN configuration parameters are successfully stored

To check this parameter , use the below command

RMAN> show exclude ;
RMAN configuration parameters for database with db_unique_name AZKKDB are:
CONFIGURE EXCLUDE FOR TABLESPACE 'EXAMPLE';

RMAN> backup database noexclude ;
or
RMAN> backup tablespace example ;
Starting backup at 25-DEC-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00005 name=C:\APP\DATABASE\ORADATA\AZKKDB\EXAMPLE01.DBF
channel ORA_DISK_1: starting piece 1 at 25-DEC-13
channel ORA_DISK_1: finished piece 1 at 25-DEC-13
piece handle=E:\RMAN_BACKUPUMVEC3G_1_1 tag=TAG20131229T150832 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 25-DEC-11

We can disable the exclusion feature tablespace example as :

RMAN> configure exclude for tablespace example example ;
Tablespace EXAMPLE 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 AZKKDB are :
RMAN configuration has no stored or default parameters

In order to skip READONLY and OFFLINE tablespace we can issue backup database command as,
RMAN>backup database skip readonly, skip offline ;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: