Re: Force users to use Active DG for reporting

srvctl add service -d dbname -s service_name -r instname -l PHYSICAL_STANDBY

to create a service that is only running when the role is physical standby.

On Mon, Mar 31, 2014 at 5:21 PM, Karth Panchan <keyantech_at_gmail.com> wrote:

> 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_at_gmail.com>
> 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
> >
> >
> >
> >
> >
> >
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l