copy database to new machine method...

From: Glen A Stromquist <glen_stromquist_at_nospam.yahoo.com>
Date: Tue, 04 Jun 2002 22:39:55 GMT
Message-ID: <%kbL8.21900$qA.755398@news2.telusplanet.net>

To move an 8.1.7 db to a newer machine with the same OS(2000 advanced server) I decided to try the following rather than the usual exp/imp or clone using copy datafiles etc.. and create database/controlfile from trace file:

*installed 8.1.7 on new machine, create listener

*shutdown db on old server

*did cold backup

*created identical directory structures for db on new machines drives (drag
& drop)

*copied datafiles, init.ora, control files and redo logs to new machine

*created internal password using orapwd

*set oracle_sid to [sid]

*create instance on new machine using oradim -new -sid [sid] -pfile
["pfile"]

*start new instance using oradim -startup -sid [sid] -intpwd [pwd]
-starttype srvc -pfile'[pfile] (-starttype srvc,inst returned ORA-12560?)

*use net8 assistant to create tnsnames.ora with new sid

*start up database from svrmgrl using startup pfile=[pfile]

This almost seems to easy, at least it went much smoother than any other method I've used in the past. With the datbase shutdown, one could even drag the entire directories and contents to the new machine rather than use the backed up files. (this is not a large database)

Before I put this in to production is there any possible pitfalls I may have missed using this method?

TIA Received on Tue Jun 04 2002 - 17:39:55 CDT