Re: Moving Databases

You have many options available:

1. Create the instance on the target server. Do a cold backup and copy all the files to the target server. If the drives and directories structure match, everything should be fine. Remember, a combination of database name and hostname can be resolved using the SQL*Net connect string. If the drives and directories do not match, you will have to rename the files. The easiest way to do this is to recreate the control file (after mounting, but not opening the database)
2. Create the instance, database, and all tablespaces on the target server. Export data from the source and import it into the target server.

Feel free to contact me if you have any more questions.

--
-------------------------------------------
Murali Kazhipurath
Oracle DBA
-------------------------------------------
How? wrote in message <3496D504.296B_at_nowhere.ca>...


>Hello all,

>

>I have 2 servers, both running 7.3.3.3 but one has a dual processor.  We

>use 1 server for development and 1 server for production.  I want to

>switch the two as my dev server has 2 CPU's and I want production to be

>a little more powerful.  Anyone have any thoughts on how best to do

>this?

>I've never tried this out but I'm thinking a full database export of

>each and switch.  Do I have to then replicate the tablespaces beforehand

>via server manager ahead of time or what?  Any thoughts posted to this

>newsgroup would be appreciated, thanks.