[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 566
  • Last Modified:

Help on Using Oracle Dataguard 10G

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?
0
mchua
Asked:
mchua
  • 2
  • 2
1 Solution
 
schwertnerCommented:
http://www.dba-oracle.com/t_logical_standby_reporting_database.htm

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!
0
 
mchuaAuthor Commented:
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?
0
 
mchuaAuthor Commented:
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?
0
 
schwertnerCommented:
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.
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now