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

MOSC Banner

Data Guard fail over

Hi All
How do we find out that a fail over or switch over occur to a standby Data Guard  ? ( cannot use SYS to query)
As my job is monitoring the Database , I need to know that a  fail over or switch over occur .
I know that I can query the database_role from v$database but this will have to be using sysdba rule. ( database open mode )
Is there a way to do it without using SYS ?
Are there any process that run and can be found ?
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