Anyone -

I need to move an Oracle 9.2.0.2 Database to a new machine. How can I do
this by moving the database files, control files, parameter files, and redo
files ?

thanks in advance.

Richard A. Negron wrote:
It depends.
It is easier on some OS than others.

In theory, yes; but only if you really know what you are doing.
Even if you succeed you may be in for a nasty surprise in the future.

"Richard A. Negron" <rnegron (AT) cox (DOT) net> wrote

If the filesystem layout is the same then yes it is simple

close down db on PC-A
move all files across
create new service for db on PC-B using oradim
startup

If you wish to change names, file locations etc the process is more
difficult. What you are doing is known as cloning a database so you could
search for that on google.


--
Niall Litchfield
Oracle DBA
Audit Commission UK

Hey there,

I'm trying to do the same thing. Is it possible to do with
full/import export?

--
Posted via http://dbforums.com

oscar_1 wrote:


Please keep in mind that the import utility REQUIRES
a functioning and opened INSTANCE to be avialable &
against which it connects & logs into it.

So the real challenge is to create the "empty" DB
into which the data gets imported.

Hi oscar_1, thanks for writing this:
It can get pretty confusing, can't it? I'm with you. But maybe this will
help.

You use oradim to administer the Windows service for Oracle (or you can
simply get to it thru your control panel - as I prefer - as a member of
the Admistrator group).

You probably then want to create an "empty" database with the Database
Config Assistant (DBCA) off your start menu (and copy the "starter" db
from the CD when DBCA asks - so you don't have to wait for Oracle to
compile and resolve those 8000+ java classes). You will get the standard
userids - sys, system, etc. BTW, you should not get in the habit of using
svrmgr since it disappears with 9i.

Then create your tablespaces (manually or with OEM). Then create the
appropriate schema user accounts.

Then import into them with something like:

imp system/manager ... fromuser=<src_userid> touser=<dst_userid>

Then immediately change the password for the SYS and SYSTEM userids (you
are "forced" to do this for 9i).

--
[:%s/Karsten Farrell/Oracle DBA/g]