Re: Moving database

Carlos,

If the new server is a complete clone of the first, just copy all files to the same location as in the master, change the sqlnet files, tnsnames.ora and listener.ora and you should be able to bring the clone db up.

However if the server is not a clone, i.e directory structure changes, you have to do the following:

1) Startup mount your original instance.
2) Use the command " ALTERDATABASE BACKUP CONTROL FILE TO TRACE"
3) Edit the trace file( will be in your dest path for background_dumps, to create

   a new control file for thenew instance. 4) Move all files to the appropiate locations. Notethese should match the

   edit copy of the orig control file
5) Startup database on the copy server with the pfile=<pfile location name)

Hope this helps.

--
Vikram Goel                                 Motorola email: vgoel_at_pts.mot.com
Sr. Oracle DBA - Consultant
Aerotek Inc.                                My email:  vgoel_at_emi.net

Motorola Info:
Mail Stop 39, Room S1014
1500 Gateway Blvd,
Boynton Beach, FL 33426 

In article <3169D1B4.65BF_at_hal-pc.org>, "Carlos A. Gonzalez" <cagosg_at_hal-pc.org> writes:


>Help Please :


>

>How do I go about moving Oracle Database from one computer to another

>

>My problem lies with the control files.

>

>No problem in copying the datafile for the logs and the database.

>Also I know I must have an INIT.ORA pointing to the proper *.cntl files.

>

>Should I create new cntl files and if so how ???

>

>This is really not a database backup but a move to another 

>machine/directory

>

>Any help will be appreciated.

>

>Thanks