I don't want to sound like DG (Data Guard) is a bad idea, but I do want to caution you that it requires significant baby-sitting. Both DG Physical and DG Logical should only be queried. There are ways around this as documented, but be very careful. We run both DG Physical and Logical for various valid reasons. One example of an issue is in one of our DG Logical databases we allow rows to change in the standby. Every now and then a change is made in the primary and DG tries to apply the same change to the standby and the row does not exist or the key is different, etc. At that point we have to stop apply, and resync, yatta, yatta, yatta...........get a lot of ORA-00600's too.

My suggestion is to look before you leap.


--
Thank You,
Frank Dodgers
Oracle & DB2 Certified
Evergreen Information Systems
-303-784-2322 Office
-303-674-0433 Home
-303-810-6625 Cell
frank.[Email address protected]


-------------- Original message from "Titus Olowok " : --------------

> Hello Folks,
>
> We are suggesting using Oracle 9i Data Guard for reporting purposes for a
> project. The operations in the reporting Standby database (Physical Standby)
> will be mainly read only, executing custom packages to generate reports and
> querying temporary tables.
>
> A colleage had mentioned that you can NOT execute a package in a physical
> standby database in 'read only' mode, only 'SELECT' privilege is allowed. Before
> I create a standby configuration on my local machine and test, I want to run
> this by the group first.
>
> Does physical Standby configuration in 'read only' mode support only 'SELECT'
> statements? Can packages or other stored procedures be executed as well?
>
> Thanks for sharing your thoughts
>
> Titus
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html
>

Oracle LazyDBA home page