Help on Using Oracle Dataguard 10G

Posted on 2007-10-04
Last Modified: 2013-12-19
I read from Oracle white paper that Oracle 10G R2 Dataguard Physical standby can temporarily be use for reporting. And just for curiosity If I used that feature for reporting DB and I have some batch jobs updating tables on the reporting DB. would there be impact on the synchronization of Primary and Reporting DB when I  planned to resynchronized my reporting DB from Primary again?

I know that Logical Standby is much suitable for Reporting stuffs but then my boss ask me this silly question or maybe he already read the new features in 10G of Physical standby and is trying to use this Physical standby for reporting. However our reporting is dynamic that it does summations and updates to other reporting DB tables and Primary DB tables.

What would be the impact on trying to use this Physical standby for reporting DB?  had anybody tried this before?
Question by:mchua
    LVL 47

    Accepted Solution


    Physical Dataguard can be queried ReadOnly.
    You can not apply batch jobs to update the DataGuard DB.
    If you once open the Physical DataGuard for normal
    DMLs you can not further synchronize it with the Primary
    without recreating.

    So - pure select only!

    Author Comment

    When you say "You can not apply batch jobs to update the DataGuard DB."
    The Dataguard DB i presume you are referring to the Physical standby DB  is that correct?

    Author Comment

    Here's what I read from the white paper

    In Oracle Database 10g Release 2, using a combination of Data Guard and Flashback Database, a physical standby database can be opened temporarily in read/write mode for development, reporting, or testing purposes, and then flashed back to a point in the past to be reverted back to a physical standby database. After the database is flashed back, Data Guard automatically synchronizes the standby database with the primary database, without the need to re-create the physical standby database from a backup copy of the primary database.

    With our dynamic reporting stuff that updates data to both reporting and primary tables, can i still use this feature? what would be the effect? Can I still synchcronized it with my primary dB?
    LVL 47

    Expert Comment

    Yes, I mean Physical DataGuard.
    But in both cases (Physical, Logical) your
    batch code can also connect to the Primary and maintain
    the tables the reports change on the Primary.
    After that the changes will be automatically propagated
    to the dataGuard.
    This is the most clean solution.
    LVL 1

    Expert Comment

    Forced accept.

    EE Admin

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Oracle Cursor 5 50
    Parse data from XMLtype data in Oracle SQL 5 60
    Right Function in Oracle SQL Query 6 39
    Number Format 1 31
    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now