on 03-25-2011 2:04 PM
Dears,
suppose you have an huge Sap BW where a lot of daily reports need to be executed and suppose there is a Physical Standby in place.
Two questions :
1) In you opinion it's possible to start the BW system on the Standby database while it continue to work in managed recovery mode and to execute part of these reports here in order to reduce the load on the Primary instance ?
2) In you opinion it's possible to connect directly to the Standby database, in managed recovery mode, in order to extract data for reporting purposes ?
In my opinion it should not be possible for both of them; till the Standby is in Recovery mode the Sap instance cannot be started...right ?
What do you think ?
Thanks in advace for any suggestion.
In my opinion the purpose of standby database is different. You may want to look at adding a dialog instance, tuning etc.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Not possible.
Do do so you need to "open" the DB.
It may even be open readonly (so you can continue applying logs later on), but this would not work with SAP as it "writtes" to the database when it starts. I think there is a note with this information.
In Oracle 11g there is a feature that may allow to do query Physical Standby Databases, but it is not documented in any SAP note so I do not think it will be allowed or even possible.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.