Re: SAP and Oracle DG: Looking for ideas and best practices

Vince Laurent wrote:
> We have 2 servers with the following configuration:
>
> role server SID
> ------- ------------------- ---
> primary sapsnd.ic.ssmhc.com SND
> standby sapude.ic.ssmhc.com SND
>
> I managed to get oracle data guard working to where I
> can fail sapsnd over to sapude. NOW we are trying to
> figure out how to bring SAP up on sapude. Ideas we
> are pondering include changing DNS or changing the IP
> of sapude to make it sapsnd.
>
> Someone must have done this before. What have you
> found to be best practice?
>
> Thanks
> Vince
> -----------------------------------------------------
> Come race with us!
> http://www.mgpmrc.org

Your main problem will probably be that the SAP profiles are bound to the host name. The IP itself doesn't really matter as SAP binds itself to all interfaces (in my experience with 4.0B anyway).

If you copy all of the application directories for SAP (using a scheduled rsync or such), and the sidadm user home directory, you may be able to get away with an alias.

i.e. on sapude use the alias option of ifconfig to add a hostname of sapsnd. You would obviously have to change the IP to avoid conflicts, or shutdown sapsnd while testing (probably not a good proposition)

We took a slightly different tack when faced with the same situation. I first installed a shell/default instance of SAP on our "sapude" server using the SID "SND". This allowed me to tune the SAP instance specifically for the "sapude" server. I then deployed dataguard to replace the "SND" database on "sapude".

When we tested the dataguard switchover, I had to import the "sapude" instance profile to get it in synch, but other than that there weren't too many issues getting SAP running. Switching back didn't cause any issues either, other than not being able to maintain the "sapude" instance profile when adjusting parameters.

You will also need to get another license for the "SND" instance on "sapude", but that's not too much of an issue on sapnet.

I seem to remember seeing some high availability recommendation docs on sapnet, but will need to confirm the details later.

HTH,
Andy. Received on Sun Jul 03 2005 - 03:05:25 CDT