Have Geek Brain

Oracle move / migrate schemas from one server to another

I need to move databases from one server to another.

Oracle on Server A has died, so I cannot back up the existing databases to move them.

I was wondering if there is another way to move databases to servers in Oracle.

0


a source to share


3 answers


There is a way to deal with some of the data and management files and install them on a new server.

See User Guide for Backup and Restore http://download.oracle.com/docs/cd/B10501_01/server.920/a96572/toc.htm (but look for the correct version of your database)



For example, something like:

% cp /disk1/oracle/dbs/*.dbf / disk2 / backup
% cp /disk1/oracle/dbs/*.cf / disk2 / backup
% cp /disk1/oracle/network/admin/*.ora / disk2 / backup
% cp /disk1/oracle/rdbms/admin/*.ora / disk2 / backup
+2


a source


If the old database is shutting down relatively cleanly, you should just copy the db files to the new host. "Db files" includes data files, temp files, control files and online redo logs (off the top of my head). If you can make the directory structures on the new host the same as the old ones, you should simply specify the original environment (including the ORACLE_SID) and then start running with SQL * Plus. You are using the phrase "Oracle Service" in your answer to my question, so I am assuming you are on Windows - I don’t know how you will re-register it as a Windows service.



+1


a source


If the servers are the same, then yes. You can create the same directory structure on the new server as the old one. Install oracle software and patch it in same version as old window server. Copy all data files, control files, spfile, etc. To the appropriate location on the new server. Using the account you are installing oracle, which has the privelege administrator and belongs to the dba group, run oradim to add the service to windows to start oracle, point it to your database spfile.

ORADIMxx -NEW -SID -INTPWD -STARTMODE -PFILE

or with a newer version of the database:

ORADIM -NEW -SID | -ASMSID [-SYSPWD password] [-STARTMODE auto | manual] [-SRVCSTART system | demand] [-PFILE filename | -SPFILE]

0


a source






More articles:


All Articles