His requirement is to have active data guard for database.But we are still not clear whether active data guard is supported in SAP or there are some issues as some application tries to write.Active dataguard supported for Oracle backend database, Never mind whether frontend is SAP/Peoplesoft or something else.
Also the architecture is like there is a main database to which another database BW of application is linked which is used by the applicatrion.Again there is like a Centralised database in SAP to lessen the load of main database.So the main database DB and centralised database DB CI are in OS cluster.Linked means can you please describe more on it? Not sure.. check the compatibility how Applications supports.
Now i am getting confused in this architecture.Normally if you talk about database interlinked, EX: Db links.. So this will support in different versions, releases and Heterogeneous platforms.
As our requirement is to upgrade the main database DB to 11gR2.So my question is do i need to upgrade centralised database DB CI also and BW DB which is interlinked to DB.
Please anyone has an idea in such scenario.Please do share some information or link.No settings on primary, From active dataguard which is from 11gRx you can put standby in OPEN & RECOVERY Mode, so that it will be used for reporting who can perform SELECT operations, to reduce Load on Primary database.
Also clear me for active data guard.Do we need to perform sone settings at Sap end so as to shift writes to primary and let use stanby smoothly.
Heartly thanks CKPTWelcome
actually i am not clear whether BW DB is linked with db-link..as BW is a module of SAP which has BW DB that fetches data from DB and put in its form which is used by application.You can implement dataguard for Oracle database, it wont matter whether what application is this, its just deal with database of oracle. as simple.
Actually client also wants to upgrade SAP version to EHP5 from ECC 6.0.So we were in a thought that we need to make changes in application for active data guard.
so can we move like as
1.Upgrade OS to HP-UX 11iV3
2.Upgrade database to 11gR2
3.Implement active data guard
4.Upgrade Sap to EHP5
will it work fine that to implement active data guard pn current SAP version and after implemmenting upgrade SAP.would there be any changes required in active data guard after SAP upgrade.Or there might be issues with it.
I want to know also that if i will use the standby for reporting purpose , would Sap allow to do that.No problem.. You can ask more and more question as far as reasonable. ;-)
Secondly do you have idea that how the login of user is done on frontend.I mean does on login through frontend in SAP enter some information of user login to database.That was my doubt that if i use standby for reporting purpose and login of user detail goes to database.So that will be write operation which data guard wont allow.
Also some Oracle person said that using active data guard in SAP for reporting might create some lock and have issues.