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’;


Leave a Reply

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