Thursday, 6 July 2017

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

No comments:

Post a Comment

Was this Post Helpful?

Feel free to suggest your opinions in the comments section!