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

"Bob Jones" <email_at_me.not> wrote in message news:IpRti.1822$rG7.955_at_nlpi061.nbdc.sbc.com...
>
> "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.
>
>

Thanks for the informative post Bob. I appreciate the help. Received on Tue Aug 07 2007 - 07:30:33 CDT