Clone oracle db

1) in orginal db, alter database backup controlfile to trace;

2) it generates a script containing a create controlfile command and store it in the trace directory identified in the user_dump_dest parameter of the init.ora

3) shutdown original db NORMAL/IMMEDIATE;

4) copy whole db directory to new destination

5) edit the init file to change the new path, and delete the old control files

6) [windows] drop and create the service

7) run the trace file sql....CREATE CONTROLFILE SET DATABASE "MMBO8" RESETLOGS NOARCHIVELOG.....

8) alter database open resetlogs;9) may need to add back temp file to temp tablespace