Database Cloning Through RMAN(Recovery Manager)

Clone an Oracle database using a RMAN backup

1.  
1.TAKE RMAN BACKUP OF MAIN DATABASE (BACKUP DATABASE PLUS   ARCHIVELOG)
 
2.CREATE FOLDERS OF NEW (CLONE DATABASE) AT APPROPRIATE LOCATIONS
 
3.CREATE PFILE FROM NEW DATABASE I.e. MAIN DATABASE
 
4.ADD THESE TWO PARAMETERS TO NEW DATABASE (CLONED DATABASE) PFILE.db_file_name_convert=(<source_db_path>,<target_db_path>)
 
4.log_file_name_convert=(<source_db_path>,<target_db_path>)
AND IN NEW DATABASE PFILE PARAMETER LOCATIONS SHOULD BE ACCORDING TO NEW DATABASE FILE LOCATIONS NOT ACCORDING TO MAIN DATABASE.
 
5.AT CLONING TIME NEW DATABASE SHOULD BE AT NOMOUNT AND MAIN DATABASE SHOULD BE AT MOUNT OR OPEN.
 
6.AT COMMAND PROMPTRMAN TARGET SYS/MANAGER@MAIN AUXILIARY SYS/MANAGER@CLONENOTE:–
TARGET DATABASE IS MAIN
 
7.AUXILIARY DATABASE IS CLONE DATABASE
 
8.AT RMAN PROMPT ISSUE
DUPLICATE TARGET DATABASE TO "CLONE"
MONITOR THE CLONED PROCESS.
 
CLONING OF DATABASE THROUGH RMAN IS DONE.