High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Who can connect and query standby instance ?

Hi

The question can be split in to 2.

1. Which OS user can connect using SQLPLUS into standby instance ? i.e. does he have to be at dba group as the primary group or  any group ?

2. which DB user can query the standby instance ? i.e Is only SYS can connect and query ? any other DB user ?

the tables/ view that we are querying are :

v$archive_gap

DBA_LOGSTDBY_LOG

system.logmnr_log$

system.logstdby$parameters

dba_logstdby_progress

v$archive_dest_status

v$database_incarnation

v$instance

v$log

v$dataguard_stats


thanks

Eyal

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center