oracle apps dba blog

Dear Readers,

Its an interesting subject to discuss the above. can we use Oracle 11g Active DataGuard for Real time Reporting. Real time reporting -what i mean is the data should be always in sync with the primary(no longer time delays). Yes You can but only in Oracle 11g Active DataGuard.There will be a lot of confusion if you look at the terms.viz Active DataGuard, Snapshot standby etc., Active DataGuard is the new feature in 11g though which you can open the dataguard database in “read only ” mode when still it is recovering the data from primary.Previously in 10g and before versions,you can only open the dataguard in read only mode but your recovery will not happen in the background.If you use Active DataGuard in RealTime Apply Mode(RTA), then Yes you can use Active Guard for Real time Reporting,there will be no loss of data in the standby and it will be always in sync with the primary, no need to worry that what will happen if some thing wrong happened in primary, in 11g you have the flash back,so always you can flashback the data.And ofcourse to use ActiveDataGuard You need to buy separate license from Oracle apart from the Oracle Database License.It has some hindrances also ,you can not use right now active data guard for e-business suite since this is not certified,before deciding to go for active dataguard for realtime reporting you need to test whether it will work for your application

Your comments are most welcome
–Vivek