Issues with moving database
L C
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
Cristian Cudizio
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/4968c21837159a56)
regards
Cristian Cudizio
http://oracledb.wordpress.com
http://cristiancudizio.wordpress.com
L C
"Cristian Cudizio" <cristian...@yahoo.it> wrote in message
news:1186067398.6...@j4g2000prf.googlegroups.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
Andy
"L C" <lccr...@hotmail.com> wrote in message
news:t4Ksi.149$V53.46@trnddc08...
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.