On Aug 6, 3:09 pm, DA Morgan <damor..._at_psoug.org> wrote:
> L C wrote:
> > Hello,
>
> > I asked a similar questions a few days ago and I got even more confused
> > trying the solutions they gave me. I am sure they are correct, I am just
> > spun in a circle.
> > What I have :
> > Oracle 9.2.0.1.0
> > Old Machine W2k database lives in C:\oracle\ordata\prod ( I can shut the
> > database down and do a full copy if need be
> > New Machine 2003 server database will live in D:\oracle\ordata\prod
>
> > I have read many many posts and the RMAN part of the manual a bunch of times
> > and I keep getting errors.
>
> > When I do the rename file part do I rename every .dbf file?
>
> > Also to review my steps.
> > copy all of datafiles to new machine - delete the control files
>
> > Using SQLPlus do the following:
> > Start instance in mount
> > rename datafiles
> > open database reset logs
>
> > Thanks for the help
>
> > Larry
I'm not sure whether I was one that helped to confuse you, but you
will find an article explaining how to clone a database to a new
server here:
http://www.dizwell.com/prod/node/9
Received on Mon Aug 06 2007 - 01:20:16 CDT
