Oracle disk usager >= 80% , how can we clean that up.

How much space does the DIAG folder consume?

How's the retention for the above (-> ADRCI)?

hi,

tks for the reply

so I use the query:

SELECT value
FROM v$diag_info
WHERE name = 'ADR Home';

Select allOpen in new window

to find out DIAG path, and I can only use the ADRCI tools to determine the retention period of the oracle 19c DIAG folder?

e.g.

set homepath diag

show control_retention

?

so by this you means the ADG has a lot of archive log files saved in standby server and this files never delete? 

You need to 

set homepath .... (use "show homes" to get a list of your homes) -> set this to the DIAG of the RDBMS

Select allOpen in new window

then you issue the command:

show control

Select allOpen in new window

You may also "try" to purge with the command:

purge -age 60

Select allOpen in new window

where 60 would be 1h, meaning purge everything that's older than 1h

Hi,

Some oracle member said it is not about DIAG as she is sure about that it is the sys.aud$ is big!

so we tried:

df –h /<mount volumn>

to see which folder takes large space. and it is the sys.aud$ folder, xxGB !

and we also do du –sh * to see which folder has a lot of stuff to delete 

so the diag folder also inside the same folder as admin ! admin is the largest folder. and we go inside the admin folder and see this:

and we see a lot of *.aud inside and finally we delete all of the .aud file  inside.

1 x question:

1) we don't need this one as we read other audit table for the same reason, how can we stop this files from keep generating ?

is oem_xxxxx_. aud really need for Oracle's operation ?

 

Hi,

You could delete those files manually:

done it already !  but can't be let it be a long term problems. we have our own audit table anyway.

 Ref: https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/AUDIT_FILE_DEST.html#GUID-82C7E258-EEF7-48D2-B06B-7F949686E54B

but it don't say how can we disable that right?

You can't fully disable it; Oracle will always audit something there...

I think so.. 

how about set retention period of .aud files ... ? is it possible ?

tks and let me try.

slightwv ,

Outside the scope of this question but I suggest you take a look at logrotate:
https://linux.die.net/man/8/logrotate

tks.

may I know the good thing when compare to 

https://arunbavera.wordpress.com/2022/02/12/cleaning-database-logs-using-adrci-and-cleaning-audit-files/ 

?

this is unix/linux build in command ? and it seems it is freE?

this is unix/linux build in command ? and it seems it is freE?

If you mean ADRCI: yes, it comes with the DBMS and it's free/included.

no I meant :logrotate  

tks.