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

"Cristian Cudizio" <cristian.cudizio_at_yahoo.it> wrote in message news:1186393588.059015.280060_at_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
>

Thanks for the replies.

I will try to answer the questions asked me in recent posts

To answer Dan
I am just trying to move my Oracle database to a new machine. From a 2k server to 2003. And the Oracle directory is on "d" on the new server not "c" like the old.

To answer Josh
I tried to export but is just lists it as failed. It doesn't even create a log file. That's what started this.

To answer Howard
I confused myself, but I am going to read your post

I think I was going between RMAN and SQLPlus. I had read so many different things over the course of the weekend I was getting my self confused.
I have had a few hours sleep so I am going to give it a try again today. Fortunately I don't need to have this completed till Aug 12th.

Thanks Received on Mon Aug 06 2007 - 06:03:57 CDT