I am trying to clean the unified audit trails using the plsql below
DBMS_AUDIT_MGMT.clean_audit_trail(
audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED,
use_last_arch_timestamp => TRUE);
END;
/
ORA-01578: ORACLE data block corrupted (file # 19, block # 299907)
ORA-01110: data file 19: /home/oracle/oradata_tbs/kamobile/sysaux01.dbf
The file id 19 is under table CLI_SWP$80370d01$2$1 under AUDSYS schema, i tried to repair using the dbms_repair package and file is marked as mark_corrupt=TRUE, Finally i made the skip corrupt block.
I am trying to clean up the audit trail, but i always get the above error
And also the audit trails is not storing under the sys.unified_audit_trail table from then onwards.
Copyright Notice:Content Author:「sriman narayana」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/69628161/oracle-clean-audit-trails