AIX Oracle磁盘空间满

问：

AIX 6.1
Oracle 11g r2 RAC
由于安装操作系统时只给/var文件系统分配了10GB的空间，现在两台主机的/var文件系统都已经使用了100%。
# du -sk /var/tmp/oradia_oracle 结果显示该目录所占空间为9GB以上
请问
1. 需要给/var/tmp分配多大空间才能满足Oracle 11g R2的最低要求?
2. 如果无法为该目录增加更多的磁盘空间，可以清理某些文件以释放空间吗?
3. 能否通过修改Oracle数据库配置，改变oracle_diag_oracle等目录的存放位置？
4. 能否通过修改Oracle数据库配置，降低oracle_diag_oracle等目录对磁盘空间的要求？

答：

1. 因为这个路径像关于trace文件的产生，所以需要手动的观察磁盘的增长情况
2. 如果你确信相关的trace文件不在需要，你可以把它归档到其他的地方或者删除。删除的时候也建议在停机后实施。
你能参照文档1450470.1

 

Applies to:

Oracle Server - Enterprise Edition - Version 11.1.0.6 and later
Information in this document applies to any platform.

Goal

 

There are a lot of *.trc and *.trm files generated in diagnostic_dest directory , is there a way to limit or reduce these kind of files?

 

Fix

 

The trace files are generated when specific errors are raised in the database like Internals errors(ORA-7445/600) or critical errors (ORA-4030,ORA-4031 etc).

 

So, these trace files are required for diagnosis and as such cannot be avoided.

 

The trace files are also created when events are set in the database for further diagnosis.

 

By default the files are purged based on the Retention Policy for ADR as outlined in Note:564269.1  Retention Policy for ADR.

 

Alternatively, you can use the purge option of ADRCI tool to purge files (trace files and incident files(*.trc and *.trm)).

 

The purge option can be specificed for specific types of files/data and age of the files.

 

Purge options in Oracle 11.2 :

 

 

 

adrci> help purge

Usage: PURGE [[-i <id1> | <id1> <id2>] |
[-age <mins> [-type ALERT|INCIDENT|TRACE|CDUMP|HM|UTSCDMP]]]:

Purpose: Purge the diagnostic data in the current ADR home. If no option is specified, the default purging policy will be used.

Options:
[-i id1 | id1 id2]: Users can input a single incident ID, or a range of incidents to purge.

[-age <mins>]: Users can specify the purging policy either to all the diagnostic data or the specified type. The data older than <mins>
ago will be purged

[-type ALERT|INCIDENT|TRACE|CDUMP|HM|UTSCDMP]: Users can specify what type of data to be purged.

Examples:
purge
purge -i 123 456
purge -age 60 -type incident

 

Note:

Data Type UTSCDMP is available from 11.1.0.7 onwards .

 

References

NOTE:750982.1 - TRM Trace Files Getting Generated in 11g Database
NOTE:564269.1 - Retention Policy for ADR
NOTE:756140.1 - ADRCI PURGE Command Is Not Cleaning Up CDUMP_ Folders In TRACE Directory
NOTE:811844.1 - ADRCI Purge -age Deletes Almost All Files Instead Of Only The Ones Older Than days
NOTE:453125.1 - 11g Diagnosability: Frequently Asked Questions

3. 你能修改参数"DIAGNOSTIC_DEST"
4. 你能参照文档1450470.1