Non DBA very confused about moving a database to new host

From: L C <lccronin_at_hotmail.com>
Date: Mon, 06 Aug 2007 03:59:50 GMT
Message-ID: <W0xti.16254$ug3.781@trnddc06>

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 Received on Sun Aug 05 2007 - 22:59:50 CDT