Question

如何清理Oracle11g RAC日志文件

Answer 1

1.库日志
SQL> show parameter audit_file_dest
NAME TYPE VALUE
----------------------------------------------- ------------------------------
audit_file_dest string /oracle/admin/ora11g/adump
SQL> show parameter dump_dest
NAME TYPE VALUE
----------------------------------------------- ------------------------------
background_dump_dest string /oracle/diag/rdbms/ora11g/ora11g/trace
core_dump_dest string /oracle/diag/rdbms/ora11g/ora11g/cdump
user_dump_dest string /oracle/diag/rdbms/ora11g/ora11g/trace
2.集群日志

alert日志：
$CRS_HOME/grid/log/[hostname]/alert*.log
后台进程日志：
crsd.Log: $ORA_CRS_HOME/grid/log/[hostname]/crsd/crsd.Log
ocssd.Log: $ORA_CRS_HOME/grid/log/[hostname]/cssd/ocsd.Log
evmd.Log: $ORA_CRS_HOME/grid/log/[hostname]/evmd/evmd.Log