Infrastructure at your Service

Michael Hein

Logical standby: No view for data guard status on session level

On logical standby you have to switch off data guard at least on session level to make modifications on objects which are maintained by data guard.

This is done by command


alter session disable guard;

Dataguard can be reenabled for this session by issuing


alter session enable guard;

For executing these commands “alter database” privilege is at least needed, which is often not liked by IT security staff.

Command “alter session disable guard” is also used in login triggers of logical standby databases for power users who have to do modifications in objects which are maintained by data guard. Problem is that no view can be queried to get data guard status of the session.

Workaround is to put result of login trigger into a log table which can be queried by the user.

Leave a Reply

Michael Hein
Michael Hein