Auditing for Physical Standby Databases with Real-Time Query

Today I got asked by a colleague whether we can do auditing on a Physical Standby that does Real-Time Query. My response was: Probably yes, with AUDIT_TRAIL=OS for the Standby and the audit command specified on the Primary. I did just test that and it really works this way! There is no need to have the AUDIT_TRAIL parameter value different from NONE on the Primary even. Just call a command like

SQL> audit session whenever not successful;

on the Primary and it will reach the Physical Standby via Redo-Apply. I tested that with

SQL> select * from v$version;

Oracle Database 11g Enterprise Edition Release - 64bit Production
PL/SQL Release - Production
CORE    Production
TNS for Linux: Version - Production
NLSRTL Version - Production

but I suppose it will work the same with lower versions. But then: „Don’t believe it, test it!“ 🙂

, , ,

  1. #1 von Ashish Man Baisyet am Dezember 13, 2013 - 12:51

    I have been thinking of the same on how to enable auditing in Active Data Guard scenario. Very useful for PCI and other compliance. Really appreciable.

Kommentar verfassen

Trage deine Daten unten ein oder klicke ein Icon um dich einzuloggen:

Du kommentierst mit Deinem Abmelden /  Ändern )


Du kommentierst mit Deinem Twitter-Konto. Abmelden /  Ändern )


Du kommentierst mit Deinem Facebook-Konto. Abmelden /  Ändern )

Verbinde mit %s

Diese Seite verwendet Akismet, um Spam zu reduzieren. Erfahre, wie deine Kommentardaten verarbeitet werden..