Re: Force users to use Active DG for reporting
- From: Karth Panchan <keyantech@xxxxxxxxx>
- To: "ricard.martinez@xxxxxxxxx" <ricard.martinez@xxxxxxxxx>
- Date: Mon, 31 Mar 2014 18:21:39 -0400
If I am not wrong, Active Data Guard enables read-only access to Primary
standby from Oracle 11g.
This will enable to run for Reporting.
Karth
Sent from my IPhone
> On Mar 31, 2014, at 11:55 AM, Ricard Martinez <ricard.martinez@xxxxxxxxx>
> wrote:
>
> Hi list,
>
> We got an environment formed by one standalone 11g database (lets call it RW)
> with an active dataguard on another server (lets call it RO)
> We have provided to the users 2 tnsnames, one pointing to RW and the other to
> the RO, and we have told them to use the first one for DML, etc and the RO
> only for runing the reporting statments.
>
> As good users, they just ignore us and run all on the RW database, so we want
> to force them to use the RO for reporting.
> Meanwhile they got the 2 tnsnames entries, i see no real options to force
> them to use the RW, unless we separate the schema in two (one with
> insert/update, the other only with select), and we kill any session of the
> select schema on the RO (using a cron maybe, forcing them to use RW to be
> able to end their reports)
>
> Has any of you found in a similar situation, or can think in other options?
>
> Thanks
>
>
>
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
