Re: moving a database

llowejr_at_usa.net (Larry Lowe) wrote in message news:<ad17577.0308261042.5636495_at_posting.google.com>...
> I need to move a database to a new machine; we are doing a hardware
> upgrade. The system has the same OS, the same version of Oracle and
> the same hard drive layout. Can I just shutdown the database on the
> old machine and copy the pfile, control files, online log files, data
> files and archived log files into the same paths they where on the old
> system and startup the database or is there more to it?
>
> Thanks
> Larry
I've done just that before. Actually used our legato backup software to backup all the oracle installation, and the mount points for logs and datafiles, while the database was down and then did a directed recover/restore to the new machine (didn't have to write copy commands and maybe miss a file).

Going to a new machine I would hope you can just do a test first and see if the database comes up OK -- the move this way is really a just making a copy of the database and process should be repeatable until you get it write or are ready for the final moving day.

Will have to change your tnsnames.ora and listener.ora to the new IP or machine name.

If you don't have the same mount points or file system layout for your datafiles on the new machine, then you have edit a trace of the control file and bring it up with the backup control file feature. Received on Fri Aug 29 2003 - 22:31:00 CEST