How to Configure RMAN Backups into Multiple Locations?

If we need  RMAN to distribute backup sets among multiple disks on different mountpoints. We can use the below syntax to configure backup in multiple locations.

Using Allocate Channel:

RUN
{
ALLOCATE CHANNEL c1 DEVICE TYPE DISK FORMAT ‘/u01/oracle/data1’; 
ALLOCATE CHANNEL c2 DEVICE TYPE DISK FORMAT ‘/u02/oracle/data2’; 
}

Using Configure Channel:

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ‘/u01/%U’, ‘/u02/%U’;


6 thoughts on “How to Configure RMAN Backups into Multiple Locations?”

  1. This is really interesting, You’re a very skilled blogger. I’ve joined your feed and look forward to seeking more of your magnificent post. Also, I’ve shared your site in my social networks!

Leave a Reply

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