We have an 11gR2 database with physical standby (Dataguard with Fast start Fail over) implementation and considering the options for including Active Dataguard configuration on the above setup for using standby database for reporting.
Has anyone configured 'Active dataguard' with combination of FSFO, any pointers on lessons learnt or limitations on this combinations would be greatly appreciated.
An issue with Active Data Guard is the design of service level agreements. In the event of failover, service will degrade - perhaps dramatically. Clients are often very keen to bring the standby into use because it appears to be a way of saving money, but what will you do if it is activated? Your SLA will have to state either that the query service will be disabled, or that both the r/w and the r/o services will continue to be available, but at greatly reduced performance (which you must quantify). You need to get the client's agreement and document this.
Thank you john, for your input much appreciated. Yes we are already considering this point of whether there will be any comprosmise on SLA on Fail over, which has to be tested and agreed with business.