Database Administration (MOSC)

MOSC Banner

Disable Trigger on Active Standby Database

edited Nov 29, 2019 4:09AM in Database Administration (MOSC) 3 commentsAnswered

Hi,

we use dataguard and I want to know if it is somehow possible  to disable an after servererror on database trigger on the active standby database?

I can check with an SQL if I am on the PRIMARY or PHYSICAL STANDBY db but this produces additional overhead e.g.  always execute -> SELECT database_role  FROM v$database;

The trigger can't insert the error in a table anyway because the standby db is in open mode -> READ ONLY WITH APPLY, so the trigger itself always fails. Is there a way to disable it?

thx

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