Daniel,
Regrettably I can't provide a web site or paper. But on the other hand I've
done this task before.
- make sure the machines are the same OS. (a stupid item for sure, but then
you'd be suprised)
- IF possible make the mount points identical (not necessary, but sure helps)
- Copy (in BINARY ) all of the database and log files from the old to the new
machine. If you want, you can copy the control and init files as well. If you
don't you'll need to create an init file and use the output from an "alter
database backup controlfile to trace;" command to recreate the control files.
You will need to edit this file to make the commands real and to rename
datafiles if needed.
- startup nomount the database if you are using the control file rebuild method
and run the sql generated from above. This will recreate the control file(s),
mount the database, reset the logs, and open the database. In essence your
done.
- Assuming you don't want to recreate the control files, startup mount the
database. Rename any files with the "alter database rename file <original> to
<whatever_it_is_now>;" that need it. The "alter database open;". If all went
well the database will open normally and your done.
PS: don't forget the listener and sqlnet.ora files and /etc/oratab (Unix) as
well.
Dick Goulet
____________________Reply Separator____________________
Subject: Move Database from one machine to another
Author: "Mullings; Daniel" <daniel.mullings_at_hq.gte.com>
Received on Fri Jun 23 2000 - 13:40:03 CDT
