Quote Originally Posted by waitecj
Based on the information you have given i'd say that Dataguard would work fine. When we make our database open read only, we just recreate our tempfiles as part of the script.

You haven't said what version you are using but if it is 9.2 or higher then Dataguard is the right choice. 9.0 Dataguard was a bit flaky at times.
Thanks. Our version is oracle 9.2.0.6.
Actually the one who told me that the data guard won't work is my boss. So I want to make sure it really works for reporting.
He insisted that reporting service need to write to temp tablespace,
which will fail data guard.