RMAN: Excluding Oracle Tablespaces from Backups

RMAN: Excluding Tablespaces from Backups
Андрей Волков

Андрей Волков

Системное, сетевое администрирование +DBA. И немного программист!))  Профиль автора.

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 ... 1623 views Андрей Волков Sat, 29 Feb 2020, 10:01:33
RMAN: Specifying the Backup Us...
RMAN: Specifying the Backup Us... 2464 views Андрей Волков Sat, 29 Feb 2020, 10:14:03
RMAN: Checking for Corruption ...
RMAN: Checking for Corruption ... 26913 views Андрей Волков Thu, 30 Sep 2021, 11:57:27
RMAN: Backing UP Oracle Databa...
RMAN: Backing UP Oracle Databa... 912 views Андрей Волков Wed, 29 Sep 2021, 18:27:51
Comments (0)
There are no comments posted here yet
Leave your comments
Posting as Guest
×
Suggested Locations