topic Re: migrating oracle rac in Operating System - HP-UX

migrating oracle rac

Salibt — Thu, 25 Jun 2009 18:10:22 GMT

i hace oracle rac with asm, on a hp-ux machine 11.23, storage eva4000, i need to migrate to a new storage using san copy. after copying the data to the new storage, and i present the new lun to the servers, the oracle rac didn't start.
any idea what should i do?

Re: migrating oracle rac

Steven E. Protter — Thu, 25 Jun 2009 19:09:34 GMT

Shalom,

ASM needs to be backed up using Oracle utilities. exp is probably best.

Then you need to set up the new storage and import the data.

There are additional steps needed on the Oracle side http://metalink.oracle.com is the place for the procedure.

SEP

Re: migrating oracle rac

Wim Rombauts — Fri, 26 Jun 2009 06:04:10 GMT

The Oracle RAC didn't start ... Oracle RAC on ASM has 3 layers : Clusterware, ASM, Database.
And below that, you can still have LVM from HP-UX.

So could you let us know if clusterware is starting ?
Have you verified the ownership of the raw disk device files ? They need to be writable by oracle.

Re: migrating oracle rac

Salibt — Fri, 26 Jun 2009 07:02:36 GMT

hi
we are using ASM, i thing the problem is the asm disk were pointing to device number that is changed,
per example
ASM disk group data1, have 3 disks
c3t1d1
c3t1d2
c3t1d3

and now the disks are
c7t4d0
c7t4d1
c7t4d2
is there any way to change the ASM map file?

Re: migrating oracle rac

Wim Rombauts — Mon, 29 Jun 2009 09:20:36 GMT

Yes, certainly taht is the problem. ASM is still looking at the old devices (which are no longer thee ?), so it doesn't find any datafile.
I don't know if ASM is capable of moving datafiles this way.

Another way to handle this, would be to "rename" the device files on the OS.

First, you need to take care that the LUN numbers of the new devices are identical to the LUN numbers on the original on devices. (These are the last 2 numbers in the device file. Normally lun 0 is t0d0, lun 33 is t4d1). This is something you need to do on the storage.

After that, you could need to make an ioinit file to renumber your scsi busses.
First execute "ioscan -fnC ext_bus".
Note the hardware path (if it isd still there) of instance 3 (second column) and instance 7.
If instance 3 still exists, you have to move it aside to a free number. Otherwise, don't specify instance 3 in the file below.
Now create a file with the following lines :
ext_bus
ext_bus 3

Now execute ioinit -f -r.

This will reboot your machine and the devices previously accessible on c7... will now be accessible on c3...

Re: migrating oracle rac

Steven E. Protter — Mon, 29 Jun 2009 10:33:00 GMT

Shalom again,

Based on your last post, ASM is now owning a disk without any data on it.

You will need to restore the data from backup to get back into operation.

SEP