Re: Help with clone!

Glen

When you recreated the log files, using your trace file, did you do it using the RESTLOGS option. Otherwise the control files and redo logs won't match and the SCN being out of sync in the control files will cause the sort of error you are getting.

Regards

Fraser McCallum
MVP Oracle
www.brainbench.com

"Glen A Stromquist" <gstrom_at_telusplanet.net> wrote in message news:3S3p7.35322$C57.5885757_at_news1.telusplanet.net...
> 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 - 13:26:48 CDT