snippetMinor
How to free up disk space? which logs/directories to clean?
Viewed 0 times
cleanspacelogsdiskfreehowwhichdirectories
Problem
I want to free up the disk space on my Linux machine. I've drill down the space usage and found that the following directories have a big size
Can I delete contents from these directories? Note: I mean contents and not directories.
/u01/app/11.2.0/grid/cv/log
/u01/app/11.2.0/grid/log/diag/tnslsnr/r1n1/listener_scan2/alert (Contains xml files)
/u01/app/11.2.0/grid/rdbms/audit(Contains .aud files)
/home/oracle/oradiag_oracle/diag/clients/user_oracle/host_XXXXXXXXXX/alert(Contains xml files)
/u01/app/oracle/diag/rdbms/crimesys/crimesys1/alert (Contains xml files)Can I delete contents from these directories? Note: I mean contents and not directories.
Solution
You can change the default retention policy of oracle log and trace files.
Source: https://streetkiter.wordpress.com/2011/04/06/do-you-really-need-one-year-old-logs-and-traces-for-your-oracle-database/
Relevant extract:
There are two parameters: SHORTP_POLICY (default 720 hours) and LONGP_POLICY (default 8720 hours). so SHORTP_POLICY is 30 days while LONGP_POLICY is 365 days.
From the commandline run "adrci". In adrci, use the following commands.
And now the traces are dropped after one week (SHORTP) or one month (LONGP).
Source: https://streetkiter.wordpress.com/2011/04/06/do-you-really-need-one-year-old-logs-and-traces-for-your-oracle-database/
Relevant extract:
There are two parameters: SHORTP_POLICY (default 720 hours) and LONGP_POLICY (default 8720 hours). so SHORTP_POLICY is 30 days while LONGP_POLICY is 365 days.
From the commandline run "adrci". In adrci, use the following commands.
adrci> show homes
....(homes are listed)...
adrci> set home diag/....(the location)
adrci> show control
.... (current settings are listed) ....
adrci> set control (SHORTP_POLICY = 168)
adrci> set control (LONGP_POLICY = 720)And now the traces are dropped after one week (SHORTP) or one month (LONGP).
Code Snippets
adrci> show homes
....(homes are listed)...
adrci> set home diag/....(the location)
adrci> show control
.... (current settings are listed) ....
adrci> set control (SHORTP_POLICY = 168)
adrci> set control (LONGP_POLICY = 720)Context
StackExchange Database Administrators Q#15715, answer score: 7
Revisions (0)
No revisions yet.