RMAN: Excluding Oracle Tablespaces from Backups

RMAN: Excluding Tablespaces from Backups
Andrey Volkov

Andrey Volkov

System, network administration + DBA. And a little programmer!)) See Author profile.

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;

Вас заинтересует / Intresting for you:

RMAN: Using Online or Offline ...
RMAN: Using Online or Offline ... 819 views Андрей Волков Sat, 29 Feb 2020, 10:01:33
RMAN: Specifying the Backup Us...
RMAN: Specifying the Backup Us... 1467 views Андрей Волков Sat, 29 Feb 2020, 10:14:03
RMAN: Checking for Corruption ...
RMAN: Checking for Corruption ... 161 views Андрей Волков Thu, 30 Sep 2021, 11:57:27
RMAN: Backing UP Oracle Databa...
RMAN: Backing UP Oracle Databa... 112 views Андрей Волков Wed, 29 Sep 2021, 18:27:51
Log in to comment