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
select database_role into v_role from v$database; if v_role != 'PHYSICAL' --this will prevent connection to primary DB.
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>