Infrastructure at your Service

Oracle Team

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Oracle Team
Oracle Team