RMAN

How to Backup Oracle Database Parallelly by RMAN

If you do not explicitly allocate the channel(s) in the run block, RMAN will follow the default channel and parallelism setting for parallel backup. For example:
RMAN> show all;
...
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 5; # default
...
RMAN> run {
  backup database;
}
2> 3>
Starting backup at 08-JUN-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=12 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=13 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=14 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=15 devtype=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: sid=16 devtype=DISK
...

Explicitly allocating duplicate channels in the run block will instruct RMAN to follow the number of channels to backup the database.
RMAN> run {
  allocate channel d1 type disk format '/bk1/%U';
  allocate channel d2 type disk format '/bk2/%U';
  backup database;
}
2> 3> 4> 5>
allocated channel: d1
channel d1: sid=15 devtype=DISK

allocated channel: d2
channel d2: sid=14 devtype=DISK

Starting backup at 08-JUN-16
...
Finished backup at 08-JUN-16
released channel: d1
released channel: d2

In the above example, I use multiple channels with different destinations to backup the database, it will be faster than the backup with only one channel.

Leave a Reply

Your email address will not be published. Required fields are marked *