Re: Issues with moving database

"L C" <lccronin_at_hotmail.com> wrote in message news:t4Ksi.149$V53.46_at_trnddc08...
>
> "Cristian Cudizio" <cristian.cudizio_at_yahoo.it> wrote in message
> news:1186067398.662947.159410_at_j4g2000prf.googlegroups.com...
> > On Aug 2, 4:45 pm, "L C" <lccro..._at_hotmail.com> wrote:
> > > Using
> > > Oracle 9i
> > > Trying to move an entire database from a Windows 2K server to a
Windows
> 2003
> > > server.
> > > The database will have the same SID on the new machine as the old.
> > > I can shut the old database down after hours if I have to.
> > > They are in the same network room so copying data from server to
server
> is
> > > not an issue.
> > > Old database lives on C:\oracle... New location will be D:\oracle...
> > >
> > > My issue is I have setup OMS and keep getting a "failed" when I try to
> > > export the database. I can't find a log file to tell me what is going
> > > wrong.
> > > I have read the Import/Export pages but it doesn't really say what to
do
> > > when it doesn't work.
> > >
> > > Can anyone point me in the correct direction or give me another option
> to
> > > move the database.
> > >
> > > Thanks for the help
> > >
> > > Larry C
> >
> > I don't know if there can be any issues, however you can simply copy
> > datafiles,
> > create service with oradim
> > start database in nomount and set control_files parameter to where
> > controlfiles are
> > moun database and rename datafiles;
> > open database
> > (see
>

http://groups.google.com/group/comp.databases.oracle.server/msg/4968c2183715 9a56)
> >
> > regards
> > Cristian Cudizio
> >
> > http://oracledb.wordpress.com
> > http://cristiancudizio.wordpress.com
> >
>
>
> I have a question about what to copy over to the new machine. Is it the
> entire c:\oracle\.... directory, or is it the just the directory that
> contains my data files. Also I delete the controls files from that
> directory on the new machine after I copy. Correct?
>
> Thanks
>
> Larry C
>
>

you should only need to copy the datafiles because the Oracle installation will have created the Oracle_Home. and the bdump, udump, pfile folders etc (if set)

When moving a database always delete the control files and re-create new ones you may also not want to copy the UNDO tablespace either since you can re-create this on the new machine.

Regards,

Andy. Received on Sat Aug 04 2007 - 16:30:49 CDT