Cloning RMAN Database in Oracle

Source Database for Clone

1)Ensure the database is in Archive mode  (for Hot backups)

2) Make rmancat TNS enteries in TNSnames.ora (RMANCAT is the catalog database service name)

3) Rman target sys/xxxxx catalog=rcat_user/xxx@rmancat

4) Register database; (While cloning for the first time you would require to do this since catalog          would not have information about the new DBID)

5) CONFIGURE channel c1 type disk format 'K: \RMAN\Backup\df_%d_%U_%p_%c';

    (Had to change the backup location from default location)

6) Backup database plus archivelog;   

Steps for the Clone or Target Database 

12) Startup nomount pfile='pfile with absolute path';  (Edit the Pfile on the targe DB ) 

13) Rman target sys/manager catalog=rcat_user/rcatpass@rmancat

14) RESTORE CONTROLFILE FROM "K:\RMAN\BACKUP\DF_CPAUPG_03R4NTIJ_1_1_1_1";

 (Will get this backup piece information from "list backup" command)

 15) Mount the database through sqlplus or RMAN

 16) RESTORE DATABASE;

17) RECOVER DATABASE;

 18) ALTER DATABASE OPEN RESETLOGS;