Tuesday, 28 January 2025

RMAN DUPLICATE / CLONE RAC DATABASE


RMAN RAC Database backup pieces are available in below location.

RMAN Backup ==> /backup/rman_1060/proddb/db_bkp_prod


Cloning the target database using RMAN backup.


rman
connect auxiliary /
run 
{
ALLOCATE auxiliary CHANNEL ch01 TYPE DISK;
ALLOCATE auxiliary CHANNEL ch02 TYPE DISK;
ALLOCATE auxiliary CHANNEL ch03 TYPE DISK;
ALLOCATE auxiliary CHANNEL ch04 TYPE DISK;
ALLOCATE auxiliary CHANNEL ch05 TYPE DISK;
ALLOCATE auxiliary CHANNEL ch06 TYPE DISK;
DUPLICATE DATABASE TO DEVDB BACKUP LOCATION '/backup/rman_1060/proddb/db_bkp_prod' NOFILENAMECHECK;
RELEASE CHANNEL ch01;
RELEASE CHANNEL ch02;
RELEASE CHANNEL ch03;
RELEASE CHANNEL ch04;
RELEASE CHANNEL ch05;
RELEASE CHANNEL ch06;
}

No comments:

Post a Comment