Re: Moving database to another server

Carlos A. Gonzalez wrote:
>
> Oracle Gurus:
>
> I need your help
>
> I must move a database to another server.
>
> How do I go about it. How do I keep my control files straight ??
>
> Also is it to my advantage to use raw devices instead of file systems(Unix)
> ??
>
> Any help will be appreciated.
>
> Thanks
>
> Carlos

Raw devices are 10-20% faster. They are much harder to maintain in the long run. If your database doesn't ever change in size it might be a good idea, but if you ever have to do maintenance of any kind you will have to totally rebuild the raw device with the data on it instead of just rebuilding one file. It really depends on how much time you really have to maintain the system and how much it counts to have the system running 10-20% faster. You also lose the ability (as far as I know) to do RAID and other types of redundant operations.

There are two ways to copy oracle from one machine to another: Assumptions:
Filesystems are the same from one machine to the other

1 Export the database and import onto another machine   pros: Will work most of the time, you don't have to shutdown your server.
  cons: Takes alot of time

2. Copy the files from one machine to the other

   pros: Always works, is fast
   cons: You must shutdown your server while it is copying.

Steps:

1. Shutdown your database.
2. Execute this script to get a list of your files and tablespaces

      select * from sys.dba_data_files;

      This table holds the names of all of your files and tablespaces.    3. Use the list from the previous step and copy your files from one

      machine to the other, if you are using FTP don't forget to 
      "Set binary."
   4. After you finish copying startup your database on the destination
      machine by setting the ORACLE_SID to the correct value and 
      doing your normal startup.

Good Luck Received on Mon Apr 14 1997 - 00:00:00 CDT