RMAN: Backing Up Large Files in Parallel (SECTION SIZE)

RMAN: Multiple files backup, SECTION SIZE
Andrey Volkov

Andrey Volkov

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

Normally, RMAN will only use one channel to back up a single data file. When you enable parallelism, it allows RMAN to spawn multiple processes to back up multiple files. However, even when parallelism is enabled, RMAN will not use parallel channels simultaneously to back up one data file.

Starting with Oracle 11g, you can instruct RMAN to use multiple channels to back up one data file in parallel. This is known as a multisection backup. This feature can speed up the backups of very large data files. Use the SECTION SIZE parameter to make a multisection backup. The following example configures two parallel channels to back up one file:

RMAN> configure device type disk parallelism 2;

RMAN> configure channel 1 device type disk format '/u01/O12C/rman/r1%U.bk';

RMAN> configure channel 2 device type disk format '/u02/O12C/rman/r2%U.bk';

RMAN> backup section size 2500M datafile 10;

When this code runs, RMAN will allocate two channels to back up the specified data file in parallel.

Image Note  If you specify a section size greater than the size of the data file, RMAN will not back up the file in parallel.

Вас заинтересует / 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... 1468 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