| Moving database to another host (Win2000) [message #167591] |
Fri, 14 April 2006 04:30  |
sebpon
Messages: 1
Registered: April 2006
Location: Belgium
|
Junior Member |
|
|
Greetings everyone,
I would like to have your toughts on the following.
I need to move a database from server1 to server2 without changing the db name but I have well to change the location of the files (not the same disk layout).
Here is what I thought to do in order to achieve that.
On server 1:
* alter database backup control file to trace
* shutdown the database
Moving the files
* copy the initSID.ora from server1 to server2
* copy the online redo logs from server1 to server2
* copy the archive redo logs from server1 to server2
* copy the datafiles from server1 to server2 new location
On server2
* adapt the control files location in initSID.ora
* adapt the control file creation script to indicate the new location of online redo logs and data files
* startup nomount
* create the control file (REUSE SID NORESETLOGS)
* alter database open
PS: Oracle software is already installed and the service for the instance as well.
Is this a valid way of working ?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
