I read from Oracle white paper that Oracle 10G R2 Dataguard Physical standby can temporarily be use for reporting. And just for curiosity If I used that feature for reporting DB and I have some batch jobs updating tables on the reporting DB. would there be impact on the synchronization of Primary and Reporting DB when I planned to resynchronized my reporting DB from Primary again?
I know that Logical Standby is much suitable for Reporting stuffs but then my boss ask me this silly question or maybe he already read the new features in 10G of Physical standby and is trying to use this Physical standby for reporting. However our reporting is dynamic that it does summations and updates to other reporting DB tables and Primary DB tables.
What would be the impact on trying to use this Physical standby for reporting DB? had anybody tried this before?
Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!