Re: Help with clone!

I copied the online redo logs over from the prod db, so I didnt think I'd need to reset the logs? Also, being that the database was shut down when the files were copied, I should even be able to do an alter database clear logfiles should I not?  

In article <l66p7.29918$4j4.148814_at_NewsReader>, "Fraser McCallum" <fmcc_at_nospamodbaguru.com> wrote:

> 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 - 14:56:16 CDT