cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Dataguard setup on SAP AS Java stack

0 Kudos
303

Dear All,

I have recently setup DR on my ABAP stack and the archive logs are getting transferred to the standby DR server. I have another instance of AS Java running on the same database with a different schema (SAPSR3DB). I restored the backup of my primary database on the standby server and activated dataguard, AS ABAP instance is starting up fine but the J2EE instace fails to startup with instance ID error, the instance ID on the instance.properties file is different from the instanceid of dispatcher on the configtool cluster data. The instace id is stored in the database and hence it came to standby due to restore.Both primary and DR server have different hostname. What should I do to resolve the instanceid mismatch error?

1. One option is to export Java from primary instance, switch it to standby mode, make the standby as primary and import the Java instace that was exported earlier. But in that case the archive logs will flow in opposite direction from new primary to new standby(original primary), will it affect my original primary instance when I later switch it back to normal operation?

2. Option 2, break the DR, startup standby in open mode, import the Java from the exported file and resync DR, in order to resync DR I again have to restore the DB from original primary to standby, in tht case again we have the same situation as the instance ID is stored in database and will be copied to standby when I restore.

Please provide your valuable inputs.

View Entire Topic
former_member188883
Active Contributor
0 Kudos

Hi Avik,

Create a virtual hostname for your DR system . This virtual hostname should be like the primary hostname.

Re-install DR and re-configure DR using this virtual hostname. This is resolve the issue of hostname mismatch.

As rightly pointed out by Sunny earlier, for JAVA systems you need to write some scripts or use 3rd party tool to sync up files on the OS level.

Hope this helps.

Regards,

Deepak Kori