(UR = A ) setting for Mount/unmount database to connect in Oracle dataguard

Standby Dataguard is not connected when in mount state

(UR = A ) is required to allow you to connect to the service while the database is in mount/nomount mode.

In Oracle dataguard, configuration the standby database is present in nomount or mount state which need to be connected. we need to add (UR = A) entry in tns for connectivity.

prim_STBY =
   (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = host02)(PORT = 1521))
      (CONNECT_DATA =
         (SERVER = DEDICATED)
         (SERVICE_NAME = primstby) (UR = A)
      )
   )
This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply