We are asked to create a copy of one production database for the
reporting purpose. It needs to be refreshed at least 3 times every day.
We are considering two options;
2) data guard
I personally want to do it using data guard. But I was told
by our senior dba that the standby does notwork.
The reason is that the reporting service need to write to temporary tablespace. This is not allowed in data guard. This is true?
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 220.127.116.11.
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.
Would you please give me a little more details about how to
switch the data guard mode between recovery mode and the
read only? It is great if you can send me the scripts you already have. Or just layout the procedures?