Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: moving 3 oracle database onto another server.
> I have to move 3 oracle databases from one NT server to another , if i
> want to physically move these databases what .ini files and other files
> i should edit, if i could get some pointers to any enters i have to make
> in the registry. and if there is any documentation out there please let me
> know.
First be sure you have a usable backup of everything. Then you will need to move the datafiles, the log files, the initSID.ora file, and rebuild the control files from scratch. You can find instructions for rebuilding control files in the manual as it is too dangerous a process for me to want to advise anyone how to do it in this group. You will need to edit the initSID.ora file too.
In the past when I have done this I have used OARDIM to drop the Oracle Services and then rebuilt them from scratch with a new SYSTEM tablespace on the new host.
Daniel A. Morgan Received on Mon Feb 01 1999 - 19:24:59 CST