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

"L C" <lccronin_at_hotmail.com> wrote in message news:xeDti.528$V53.339_at_trnddc08...
>
> "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
>
>

Dude, why would you want to read stuff from different places, when it is clearly explained in the manual? No wonder you are confused. Received on Mon Aug 06 2007 - 22:11:46 CDT