data guard questions

[Lily_Liu_2004]

DBAs,

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;
1) replication
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?

Thanks,

Lily

[davey23uk]

logical or physical standby?

well you can have temp tablespace in either, I do exactly what you want - a physical which is opened read only once a day for reporting purposes and we use temp

[Lily_Liu_2004]

logical or physical standby?

well you can have temp tablespace in either, I do exactly what you want - a physical which is opened read only once a day for reporting purposes and we use temp

I am thinking about using physical standby if the end users
don't need access the stadnby all the time.

[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.

[Lily_Liu_2004]

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.

[davey23uk]

no you just add tempfiles to the temp tablespace if it doesnt have any already

[Lily_Liu_2004]

Thank all.

Waitecj & Davey23uk,

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?

Thank you so much!

[davey23uk]

alter database recover managed standby database cancel;
alter database open read only;

ta da! all done

to go back to recovering

alter database recover managed standby database disconnect from session;