How to Backup Oracle Database Parallelly by RMAN

  • by
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 *