SEO

#1 (**permalink**) 02-26-2008, 07:23 AM

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

#2 (**permalink**) 02-26-2008, 07:23 AM

On Aug 2, 4:45 pm, "L C" <lccro...@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....68c21837159a56)

regards
Cristian Cudizio

http://oracledb.wordpress.com
http://cristiancudizio.wordpress.com

#3 (**permalink**) 02-26-2008, 07:26 AM

"Cristian Cudizio" <cristian.cudizio@yahoo.it> wrote in message
news:1186067398.662947.159410@j4g2000prf.googlegro ups.com...
> On Aug 2, 4:45 pm, "L C" <lccro...@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....68c21837159a56)
>
> 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

#4 (**permalink**) 02-26-2008, 07:27 AM

"L C" <lccronin@hotmail.com> wrote in message
news:t4Ksi.149$V53.46@trnddc08...
>
> "Cristian Cudizio" <cristian.cudizio@yahoo.it> wrote in message
> news:1186067398.662947.159410@j4g2000prf.googlegro ups.com...
> > On Aug 2, 4:45 pm, "L C" <lccro...@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....g/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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Issues with moving database