This content has been marked as final. Show 7 replies
sachinpawan wrote:i can think of two option now...
how to block access to production and allow access to DG for users?
thanks in advance
1. tnsnames.ora in client side should point to standby DB.(i like to believe your DG is in active real-time apply and standby DB open in readonly)
2. check: http://uhesse.com/2009/08/19/connect-time-failover-transparent-application-failover-for-data-guard
when you are creating trigger, use standby instead of primary e.g
select database_role into v_role from v$database; if v_role != 'PHYSICAL' --this will prevent connection to primary DB.
Yes it would block any User who did not have RESTRICT ACCESS granted to them. So generally SYS and SYSTEM would have this.
Your tnsnames will need an additional setting too.
The UR=A is need for restrict
RECOVER2= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=myhost) (PORT=1521) ) (CONNECT_DATA= (SERVICE_NAME=RECOVER2) (UR=A) ) )
Results - Worked!
SQL> startup restrict ORACLE instance started. Total System Global Area 830930944 bytes Fixed Size 2231048 bytes Variable Size 503317752 bytes Database Buffers 318767104 bytes Redo Buffers 6615040 bytes Database mounted. Database opened. SQL> alter system switch logfile; SQL> / SQL>
Edited by: mseberg on Oct 25, 2012 5:09 AM
Edited by: mseberg on Oct 25, 2012 5:38 AM