Yesterday, I had as issue which was standby log shipping giving below error ,
PING[ARC2]: Heartbeat failed to connect to standby '<stbyDb>' Error is 1033.
On Standby server , db side was giving below error ,
NOTE: Deferred communication with ASM instance
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 28: No space left on device
ASM side was giving also,
OS Audit file could not be created; failing after 6 retries
Oracle support has a note about this issue which is "Large Number of Audit Files Generated by Oracle Restart or Grid Infrastructure (Doc ID 1378881.1)" . Oracle restart deamons is checking availability of registered services within a CHECK_INTERVAL parameter duration.Default it is 1 second.
crsctl status res ora.asm -p command shows that checking frequency of asm service availability is 1 second. Modifying value of parameter can avoid execessive generation of audit files.
crsctl modify res ora.asm -attr "CHECK_INTERVAL=60"
But this change will provide checking service availability every minute and unavailability will be detected one minute later in worst case.If it is acceptable , parameter can be changed. I have not changed parameter. I have solved issue by adding script into crontab which work everyhour and deletes ASM audit files
1 * * * * rm -rf /oracle/app/grid/product/12.1.0/grid/rdbms/audit/*.aud
can we disable this Audit Trail on ASM?
ReplyDeleteHi,
DeleteAs i know we cannot. Increasing check interval is the best solution to avoid lots of audit file creation beside disadvantage mentioned above.
Thanks a lot.