|
-
You need t install the same version of Oracle with the same patches. It needs to be the same operating system, and it helps if the file layout is the same. Shutdown your original database and copy over the datafiles, log files and archive log files into the same directory structure. You can also copy over you admin folder and the files in $ORACLE_HOME/dbs. Although you will want to recreate your external password file with orapwd. Then you shoul be able to start up the database on the new server.
If you want to change the name or file location of the database, then you need to "alter database backup controlfile to trace;". Then look for the folder in your $ORACLE_BASE/admin/sidname/udump folder or wherever udump is on your system and edit the file for the new system.
If you don't know what I am talking about then you should get someone to help you to move the database.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|