DR setup for EP7 on Windows+Oracle

[Former Member]

Hi,

We are in the process of DR setup for our portal system based on NW2004s, Windows 2003 and Oracle 10.2.

We are thinking of using oracle standby database with log shipping to keep the portal databases in sync on the primary and DR site. We are planning to do the following.

_Primary site:_

EP 7.0 installed on MSCS cluster

_DR site:_

EP 7.0 created as a copy of Primary via sapinst, non-clustered. The database will be refreshed from the Primary site DR and will be put in standby mode. Log shipping & apply will be configured.

Now if any apps are applied via SDM on the Primary site, will that be replicated via log shipping on the DR site? What about .par files deployed on the Primary site? Any way to keep the OS level files in sync provided these do not contain the hostname?

Do you see any issue with this setup? Has anybody done something similar?

The only reason we want to keep the database in sync on both the sites is because our users are in the j2ee UME and the user information including password needs to be retained on the DR site. The UME can't be moved due to our infrastructure setup.

Is there any way we can keep the UME content, user details/password in sync between 2 j2ee systems? If there is a way, then we don't need to setup the standby database.

Any help is welcome.

regards,

Mohan

[sunny_pahuja2]

Hi,

In your DR setup, there are number of problems:

1) Since you are keeping your standby db in sync with primary as a result hostname of primary will come in your stand by database as a result your system will not start until you will not change hostname/ip address at number of places manually.

2) Since in Java system most of the configuration lies in the file system so if you will not sync your file system at standby with primary then it will create a lot of problems.

Thanks

Sunny

[Former Member]

Hello Sunny,

We are planning the same set up.

Can it be done that the hostname and ip can be set same as that of the primary server?

Also can you pl tell me, if logshipping is not recommended then what method can be used to keep the primary and DR in sync?

Is it possible to have almost zero downtime with DR set up?

Can you provide any links to - how to set up the logshipping in oracle?

Regards,

Yuvi Basis.

[Former Member]

Hello,

We have installed DB/SCS on external disks which are part of the cluster resources. Oracle / SCS disks are replicated onto mirror disks by SRDF replication. So Oracle/SCS have no issues in a DR environment, although there is downtime while services are being started up on DR. The app servers connect to the DB/SCS using aliases , so we just the change the DNS of the alias to point to the DR server before restarting application servers. We have never had trouble with application deployed on production environment. They always reflect on DR.

However, because the DR application servers are installed as dialog instances of the same instance, we do not have access to CI (and hence SDM, VA, Config Tool) in a DR environment. I wanted to know if there is a way to set up the Central Instance so that it is available in DR as well.

thanks,

Snigdha