Re: Help with clone!

"Glen A Stromquist" <gstrom_at_telusplanet.net> wrote in message news:20010916.140011.689007625.1501_at_localhost.localdomain...
> I copied the online redo logs over from the prod db, so I didnt think I'd
> need to reset the logs?

You don't. You only need to resetlogs if you are renaming the database by editing the relevant line in the controlfile backup trace file.

You aren't doing that, so there is no need to do what was suggested.

Regards
HJR
>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 - 22:07:49 CDT