Saturday, January 29, 2011

how to place backup dumps to different mount points(disks) through Rman.

Hi All,

This Article will be useful if you have space issue in single disk(mount point).

How to configure RMAN to backup to different disks(mount points).


You need to configure two channels for two mountpoints


Below are the steps.


step i)RMAN> configure channel 1 device type disk format '/d01/stage1/%U.bak';

step ii)RMAN>configure channel 2 device type disk format '/d01/stage2/%U.bak';

step iii)RMAN>CONFIGURE DEVICE TYPE DISK PARALLELISM 2;

step iv)RMAN> configure default device type to disk;

step v)RMAN> backup database;

Then you can verify the backup dumps. It will placed in both stage1 and stage2 mountpoints

ls -l /d01/stage?

or you can write a programme and run the below script.

run { allocate channel c1 type disk maxpiecesize=60m format =
'/d01/stage1/%U.bak';
allocate channel c2 type disk maxpiecesize=60m format =
'/d01/stage2/%U.bak';
backup tablespace example;
}




I hope this helps.. :)

No comments: