Yup, and you can set up a service like this: 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@xxxxxxxxx> 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@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 > > > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'