Announcement

Collapse
No announcement yet.

Need help to purge audit_trail table in OTM

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Need help to purge audit_trail table in OTM

    I'm looking for a procedure (such as a generic SQL script) to purge audit tables in OTM. I checked the admin guide and searched metalink to find an ideal solution and also checked under the $GLOG_HOME/glog/oracle/script8 directory, but couldn't find any. From the application front end, I found a link "Audit Cleanup" under "Configuration & Administration" -> "Process Management". It looks close, but the help page says that it'll only purge the rows older than the cut-off date where the OBJECT_GID is null. In our instance, audit_trail has about 50 million rows but there's no row with OBJECT_GID having null value and if we run this process, it won't delete anything at all.

    Is there a way to purge all the rows older than the cut-off date, regardless of the OBJECT_GID value ? Also, can we manually purge the other audit tables also, such as AUDIT_DATA_INFO (has more than 90 million rows) etc. ?

    I raised an SR with Oracle Support with the same request, but they said, i can technically delete the old audit_trail data that's not referenced by any active business objects. Which, I think, means that, I can delete the data from audit_trail where object_gid is null. We don't have any data with object_gid as null values.

    Has anyone done this ? Any ideas please ?

    Thanks
    Muthu

  • #2
    Re: Need help to purge audit_trail table in OTM

    Hi,

    Please let us know some of the information,

    1. Which version of OTM are you using?

    2. What is the procedure to enable audit_trail?

    3. What is the requirement to save the data in audit_trail?

    4. Below is the list of tables which are associated with audits
    AUDIT_CONTROL
    AUDIT_DATA_INFO
    AUDIT_OBJECT_CONTROL
    AUDIT_OBJECT_TYPE
    AUDIT_TRAIL

    To purge data from these tables, you need to first find out the foreign key and primary key relationships and then proceed with purging

    Thank you


    -Prasad-

    If my post was helpful, then click on the Thanks button

    Let's connect on LinkedIn
    Mobile: +91 973 049 6886
    E-mail: prasad.chandane@gmail.com

    Comment


    • #3
      Re: Need help to purge audit_trail table in OTM

      Hello Prasad,

      Thanks for the reply. Sorry, that I couldn't respond immediately.

      1. Which version of OTM are you using?

      We're using 6.2

      2. What is the procedure to enable audit_trail?

      I need to check with our tech team. I'm providing support from the DBA role.

      3. What is the requirement to save the data in audit_trail?


      This is the first time we're planning to purge the data and thinking about retaining 100 days old data and purge anything older than that.

      Thanks
      Muthu

      Comment


      • #4
        Re: Need help to purge audit_trail table in OTM

        Hi Muthu,

        Thanks for providing the information

        I am also providing OTM DBA support along with OTM TechnoFunctional role

        I have implemented the policy to purge XML BLOB data which is older than 90 days

        However, I need to check the procedure for purging AUDIT_TRAIL and let you know


        -Prasad-

        If my post was helpful, then click on the Thanks button

        Let's connect on LinkedIn
        Mobile: +91 973 049 6886
        E-mail: prasad.chandane@gmail.com

        Comment


        • #5
          Re: Need help to purge audit_trail table in OTM

          Hi Prasad,

          Can you please provide the details of hoe to purge All audit table.
          I enabled audit control for domain.. added contact notification for few events.

          Comment


          • #6
            Re: Need help to purge audit_trail table in OTM

            Hi ,
            please help me if the solution of purging is figured out.
            i use 6.3.2
            i enabled audit for different notify subjects through a contact with com menthod aud.
            For purging do these tables have mark_for_purge field?

            Comment


            • #7
              hi,
              Any suggestions for purging audit trail tables in OTM?

              Comment

              Working...
              X