Re: How to move Oracle database to a new machine?

Joan wrote:
> Hi all Oracle DBA experts,
>
> At work we have an Oracle 8i on Unix with a small amount of user data
> (less than 10 tables and the largest table has about 4000 records). I
> need to move this database to a new machine. The database has no
> active transactions so I can shut it down whenever I need to.
>
> I have textbook knowledge on how to do this but the only hands-on
> experience I have is installing Oracle8i on a PC. So I really need
> your help.
>
> My plan is to make a closed database backup, install Oracle8i on the
> new machine, then restore the database file. I've read some
> documentation, but I want to be sure that I understand the proper way
> to do this before I begin? Here are a couple alternatives I see:
>
> Plan One.
> a. SQL>shutdown normal;
> b. back up (cp all data files, control files, redo log files, password
> file, parameter file).
> c. install oracle8i on the new machine
> d. restore (cp all backup files to the new machine) when the oracle is
> shut down
> e. SQL>startup pfile=init.ora;
>
>
> Plan Two:
> a. SQL>shutdown normal;
> b. back up (cp all data files, control files, redo log files, password
> file, parameter file).
> c. install oracle8i on the new machine
> d. restore (cp all backup files to the new machine) when the oracle is
> shut down
> e. SQL>startup mount pfile=init.ora;
> f. SQL>recover database;
> g. SQL>alter database open;
>
> Plan Three:
> Is it easier to do this using Export/Import utility?
>
>
> The database currently is set in Archivelog mode. But there will be no
> loss of data when I start doing back up so it is not necessary to
> recover the data from archived logs.
>
> 1. My confusion is: for this situation, is the command "recover
> database" necessary?

Not necessary

 >Or once the database files are restored, my job
> is done?

Your job is done
> 2. Do I need to change archive log mode before backup?
NO

> 3. Is there a command to close a database without dismounting it or
> shutting down the instance?

HUH?
NO

> 4. Are Export/Import utility, Recover Manger etc available on unix
> platform?

Yes

> 5. If what I listed above is not correct way to do this, please kindly
> advise how to do this migration.
>
> Because the new machine is not available yet, I haven't actually done
> this. But once it is ready, I have little time to do it. So your
> advice is highly appreciated.
>
> Thank you very much for your help.
>
> Joan

If the new system & the old system have the same OS & OS version, then all you need to do is move all the Oracle files from old to new. Received on Sat Apr 24 2004 - 12:44:12 CDT