rman duplicate command

To clone target database from source.

Run below command in target database.

rman log /u01/oracle/recovery.log

connect target sys/Nex#us1as3p@PRODDB

 

connect catalog rman/rman007@atlrmxx1

 

connect auxiliary /

run {

ALLOCATE auxiliary CHANNEL ch00 TYPE DISK;

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;

ALLOCATE auxiliary CHANNEL ch07 TYPE DISK;

ALLOCATE auxiliary CHANNEL ch08 TYPE DISK;

ALLOCATE auxiliary CHANNEL ch09 TYPE DISK;

ALLOCATE auxiliary CHANNEL ch10 TYPE DISK;

set until time '12-NOV-2012 15:17:00';

duplicate target database to TESTDB;    

RELEASE CHANNEL ch01;

RELEASE CHANNEL ch02;

RELEASE CHANNEL ch03;

RELEASE CHANNEL ch04;

RELEASE CHANNEL ch05;

RELEASE CHANNEL ch06;

RELEASE CHANNEL ch07;

RELEASE CHANNEL ch08;

RELEASE CHANNEL ch09;

RELEASE CHANNEL ch10;

}