Help with clone!

Trying to do a clone here, but I must be missing a step somewhere, here is what has transpired so far:

created a database with same name on test machine, using db assistant to create the scripts, then ran them
backup controlfile to trace on prod database, shut ii down, copied datafiles, redo logs, etc... to target db edited init.ora to match file locations etc.. most were same anyway edited trace file to startup nomount pfile=<path>\init.ora edited trace file to match new datafile locations deleted controlfiles from target db, but left system, rbs etc tablespaces intact

tried to run the script and got

ORA-01159 - file is not from same database as previous files - wrong database id
ORA-01110 - datafile 7: 'file name>'

must be something simple, what am I missing? Do I need to over write the system etc. tablespaces from the prod instance as well?

thanks in advance Received on Sun Sep 16 2001 - 10:49:19 CDT