| migrate ora8.1.7.4.1 to a new server [message #61079] |
Fri, 26 March 2004 04:11  |
ChristiDB
Messages: 2
Registered: February 2004
|
Junior Member |
|
|
We currently have a production Oracle Server in a failover cluster setup that we would like to shrink to a stand-alone configuration on a new server.
In MS SQL & DB2 UDB you can detach the files from 1 instance, map the SAN to the new server, then re-map the database to a new instance on another server without having to run exports or backups or loads. Does anyone know of a way to do this in Oracle?
Our config:
DBMS: Oracle8i Enterprise Edition Release 8.1.7.4.1 with partitioning option
OS: Win 2000 SP3 (IE v5.0.3502.5400)
Database spread across a 1GB Compaq fiber based SAN
Thanks!
Christi
|
|
|
|
| Re: migrate ora8.1.7.4.1 to a new server [message #61084 is a reply to message #61079] |
Sat, 27 March 2004 06:19  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
I dont see a reason why its impossible in Oracle. You would generate a controlfile trace(which will have the physical structure of your database),shutdown the database clean,detach the files,present the SAN to the new Server,edit the controlfile trace to rename the files if required, recreate the controlfile on the new Server with the datafiles in the new location and open the database ( cancel recovery,open resetlogs if required).
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
