My production utilization is pretty high sometime, and there is a lot of new report requirements.
The solution which we had thought was to create an Oracle Dataguard setup(ODG), one such setup is already there running in passive mode to maintain our DR site.
Now the second ODG setup we were thinking to create for developing a reporting database, which could get in sync with prod by every morning and can be used throughout the day.
Is this possible to create two DR site using ODG, or is there any other solution which is economical as well. Golden gate is there but thats costly.
DB we are using is 10G.