Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to move Oracle database to a new machine?

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

From: Joan <joan48105_at_yahoo.com>
Date: 24 Apr 2004 19:22:46 -0700
Message-ID: <39d54693.0404241822.1c153feb@posting.google.com>


AnaCDent <anacedent_at_hotmail.com> wrote in message news:<NHxic.91851$U83.33754_at_fed1read03>...
> 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.

Thank you much for the tip. The new machine is going to run unix too but I am not sure what version. Just want to be sure, do I need to reinstall Oracle on new machine? Or I can just move all software files over as well along with database files? If the new system and the old one have different version of Linux, will Plan One work? Received on Sat Apr 24 2004 - 21:22:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US