Re: Moving Databases

1. What would you suggest for copying a database to the same server.

Declan

Murali Kazhipurath wrote:

> 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.
Received on Mon Dec 22 1997 - 00:00:00 CST