Hi,
for a customer I am currently enabling audit on a 12c database under OL 7.3.
I've also configured a purging auditdata mechanism as follows:
- setting a archive timestamp on DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED,DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD,DBMS_AUDIT_MGMT.AUDIT_TRAIL_OS
- creating purging jobs for these 3 types
All jobs works fine on primary site. Due redo-apply the auditdata in DB-tables are purged on both sites. But the OS-Audit files are purged only on primary.
Maybe because the standby DB is in read only there is no scheduler available, which can run the purge job.
If I run manually
DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(
audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_OS,
container => DBMS_AUDIT_MGMT.CONTAINER_ALL
);
on standby, all OS audit files will purged there, but it doesn't work via DBMS_SCHEDULER.
Is there another recommended way to implement purging jobs in a DataGuard env on stanby site?
Should I create a job at OS-Level (cron...) on standby site? Or what is my mistake here?
Best regards Peter