Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

How do I move my software oracle installation ?

SOLVED
Go to solution
Deanna Tran_1
Frequent Advisor

How do I move my software oracle installation ?

Currently, the software oracle is on internal disk, and i want it to move to the external disk? Is there an easy way to do so? without reinstall the oracle?
8 REPLIES
Jean-Luc Oudart
Honored Contributor

Re: How do I move my software oracle installation ?

backup + create logical volume (external disk) + restore.
This one way to clone the oracle installation on the same Unix box.
cf link
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x30046049dbb6d611abdb0090277a778c,00.html

Jean-Luc
fiat lux
T G Manikandan
Honored Contributor

Re: How do I move my software oracle installation ?

I am not sure the reason why you are moving the files to external disk.

I am not sure but you can try these
copy the oracle files to the external disk like to /home2/oracle.
For example if your current directory is /opt/oracle.
Then create a link to /opt/oracle so that the oracle is not disturbed any way.
ln -s /home2/oracle /opt/oracle.

But can you revert for the reasons why you are moving the oracle.


Thanks
Ashwani Kashyap
Honored Contributor

Re: How do I move my software oracle installation ?

Put the external disks in the same VG as your oracle software PV's are . Create an LV on the external disk of the same size as your oracle LV .

Then pvmove all your physical extents in your old LV to new LV .

Unmount oyur oracle LV . Mount your new oracle LV to the same mount point . Update your fstab .

THis should work
Anil C. Sedha
Trusted Contributor

Re: How do I move my software oracle installation ?

Best available option without hassles.


Involve an external disk in your current volume group.

Then do a pvmove of the oracle filesystems /ora_data, /ora_index, /ora_rdo etc etc onto the new disk if you have the partitions on multiple disks.

If you have them on one single disk then you can do a pvmove from one disk to another disk directly.

pvmove /dev/dsk/c0t0d0(old) /dev/dsk/c1t1d1 (new)
(Above is for disk to disk)

else - for lvol to disk

pvmove /dev/vg03/ora_data /dev/dsk/c1t1d1(new disk)
and so on

Regards,
Anil (Don't forget to assign points if the answers are valuable to you)
If you need to learn, now is the best opportunity
Ray Brewer
Valued Contributor
Solution

Re: How do I move my software oracle installation ?

I just got through doing this and it's quite easy.

1. Create a new volume that includes the new disks that you want to use
2. Create Logical volumes that have the same names as the current LV's you are using for Oracle
3. Create temporary mount points that correspond to the current one's.

ie. for a mount point named /oracle create something like /new/oracle

4. Mount your new LV's to the new mount points.

5. Shutdown Oracle

6. Copy files from old LV's point to new LV's. Here is a great command that works real quick and nice.

cd /
find . -depth -print | cpio -pudmvx /

7. Unmount all of the old Oracle mount points and new Oracle mount points.

8. Modify /etc/fstab so that the new LV's point to the old mount point directories.

9. Mount all of the file systems.

10. Verify permissions and restart Oracle

What this will do is allow you to move all of the data but keep the same directory names. This is real quick and easy to do and keeps down time to a minimum. You can create the new Volume Groups, Logical Volumes, file systems, directories, etc while Oracle is still up and running and only have it down for the time it takes to copy the files to their new LV's. Hope this works for you.

Ray
Christian Gebhardt
Honored Contributor

Re: How do I move my software oracle installation ?

Hi

Be sure you have the same directory structure on the new disc. It is not supported from orcacle to change the directory of an existing installation.

Of course you can relink the oracle-binaries within a new directory structure and the database will work, but you cannot use OraInstaller on this Installation (e.g for Patching or Upgrade) because in $ORACLE_HOME/oraInventory/... the former Installation-Pathes are hardcoded in binary-files.

Very strange !!!

Christian
Christian Gebhardt
Honored Contributor

Re: How do I move my software oracle installation ?

Excuse me it's $ORACLE_BASE/oraInventory
Alexander M. Ermes
Honored Contributor

Re: How do I move my software oracle installation ?

Hi there.
A copy can only be done with a change of mount point names. As Christian said, the ORACLE_HOME
will be held in the oraInventory file.
We tried this for an upgrade and ran into tons of problems.
Make an external disk ( same size ) a mirror of your internal disk.
Split the mirror in favour of the external disk and change the LV on the internal and give it a new mount point.
Rgds
Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"