* This is the process I use to clone a database on NT


1. Back up controlfile to trace on the database to be cloned. 
   <alter database backup controlfile to trace;>
   Edit the trace file according to the new database naming.
   Change this line from 'reuse' to 'set', 'noresetlogs' to 'resetlogs'
   CREATE CONTROLFILE set DATABASE "venus" RESETLOGS
2. Shut down the database to be cloned.
3. Get a copy of the init file, rename it properly for the new databse.
   <create pfile from spfile;>
4. Create a password file in home/database
   orapwd file=PWDvenus.ORA password=venus
4. Copy all the database files, except the controlfiles, to the folder of the new database.
5. Add new database entry to tnsnames.ora, listener.ora
6. Start a new NT service
   <oradim -new -venus>
7. sqlplus/nolog
   conn sys/phoenix@venus
8. Check and run the edited trace file from 1.
   <alter database mount;>
   extract and run the modified <create controlfile> statement
9. Shutdown the instance
10. Start up mount;
11. Alter database open resetlogs;
12. If mdeia recovery required in 11 for some reasons:
    A. Copy the old online logs to a temp folder
    B. Recover database using backup controlfile
       and supply the most recent old online log
13. Change the SYS and SYSTEM password.
14. Change global name
    update global_name set global_name='venus';