Re: Non DBA very confused about moving a database to new host

From: Cristian Cudizio <cristian.cudizio_at_yahoo.it>
Date: Mon, 06 Aug 2007 02:46:28 -0700
Message-ID: <1186393588.059015.280060@57g2000hsv.googlegroups.com>

On Aug 6, 5:59 am, "L C" <lccro..._at_hotmail.com> 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

? Why delete control files? if so you can not mount your database. May be you delete your online redolog (i hope)

regards,

Cristian Cudizio
http://oracledb.wordpress.com
http://cristiancudizio.wordpress.com Received on Mon Aug 06 2007 - 04:46:28 CDT