RMAN: Backing Up Tablespaces

RMAN: Backing Up Oracle Tablespaces
Andrey Volkov

Andrey Volkov

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

RMAN has the ability to back up at the database level (as shown in the prior section), the tablespace level, or, even more granularly, at the data file level. When you back up a tablespace, RMAN backs up any data files associated with the tablespaces(s) that you specify. For instance, the following command will back up all the data files associated with the SYSTEM and SYSAUX tablespaces:

RMAN> backup tablespace system, sysaux;

One scenario in which I back up at the tablespace level is if I’ve recently created a new tablespace and want to take a backup of just the data files associated with the newly added tablespace. Note that when B&R issues, it’s often more efficient to work with one tablespace (because it’s generally much faster to back up one tablespace than the entire database).

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

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