Database Cloning (Cold backup)

1) Copy all tha datafiles, redo files from source database to a different location

2) Make a copy of the init.ora and make changes to parameters and save it as init.ora

3) Startup the source database

3) Create a control file from the source database
alter database backup controlfile to trace; [stores trace file to udump, if specified in init.ora]
[OR]
alter database backup controlfile to trace as /u02/.../.../create_control.sql;

4) Shutdown the source database

5) Add the destination database entry in oratab(/var/opt/oracle)

6) Edit the control file that is generated as a trace file in step 3

7) Use Set#2 i.e ResetLogs option. Delete all the lines related to Set#1 and the script should contain only lines related to create control file.
a) Startup nomount pfile=
b) Create control file set database
c) Delete all the commented lines
d) Save the trace file as .sql file

8) Use the destination instance

9) Run the script generated by step 7

10) Control file will be generated

11) alter database open resetlogs;

12) Above step will open the database in resetlogs mode and creates a new Global database name