Re: Moving Oracle one box to another
Date: 13 Mar 1995 22:19:12 GMT
Message-ID: <3k2gd0$uif_at_mdnews.btv.ibm.com>
In <3jogkm$9mg_at_newsbf02.news.aol.com>, jusmar_at_aol.com (Jusmar) writes:
>I am a newbie to ORACLE. We are running ORACLE 7.1.4 on RS-6000 (AIX)
>and I need to move the entire database to completely different box. Can I
>do this with any of AIX utilities or must I re-install ORACLE on the new
>box and import from the old. Any help on this matter would be
>appreciated. Thanks in advance!
>Daniel A. Fattore
>JUSMAR_at_AOL.COM
It has been awhile, but...
I have successfully moved Oracle from one box to another using a tape
backup of all Oracle software, database files, etc. My situation:
- The OS was the same on both boxes.
- I used the same drive designation on the new box as the old box (ie., If the Oracle Software was installed on drive D on the old machine I put it on Drive D on the new machine using the same directory, subdirectory structure as the old box); this rule needs to apply to all database files, etc.
Finally, If there are differences in RAM between the two boxes you may want to adjust the database's SGA for your new environment. Note: I have not done this under AIX so I may be missing something.
M.Landa Received on Mon Mar 13 1995 - 23:19:12 CET