DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: data guard questions

  1. #1
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257

    data guard questions

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    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

  3. #3
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    Quote Originally Posted by 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
    I am thinking about using physical standby if the end users
    don't need access the stadnby all the time.

  4. #4
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    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.
    Assistance is Futile...

  5. #5
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    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.

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    no you just add tempfiles to the temp tablespace if it doesnt have any already

  7. #7
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    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!

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    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;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width