Clone DB UNIX style and taking consideration that you already have an Oracle home and user id over on the target server

1.alter database backup controlfile to trace;
2. shutdown database.
3. copy /FTP all datafiles,redo logs,init.ora (don't forget to rename the init.ora to the new database name as well as in the actual init.ora) to new server.
4. edit the control file that was put to trace.don't forget ftp it over.
ex.. CREATE CONTROLFILE SET DATABASE "Prince JR" RESETLOGS ARCHIVELOG
edit: logfiles
edit: datafiles;
you do not need to issue the recover database command
alter database open resetlogs;
5. make sure you have you're enviornment variables set to the new home and sid within your .profile /env file (or whatever you use).

6. on target server login with the user id and issue the following.
sqlplus /nolog
connect / as sysdba
@ /your/backed/up/controlfile/princ.jr

7. Vollah! you have a cloned database.


hmmm don't think I missed anything