Oracle清理数据库以各种日志文件
1. (optional)可以创建备份目录,提前备份需要清理日志
mkdir /log_bak_date
2. 数据库各项日志文件路径
sqlplus / as sysdba SYS@honor1 > show parameter dump_dest; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ background_dump_dest string /u01/app/oracle/diag/rdbms/honor/honor1/trace core_dump_dest string /u01/app/oracle/diag/rdbms/honor/honor1/cdump user_dump_dest string /u01/app/oracle/diag/rdbms/honor/honor1/trace 11gR1之后引入全新的诊断信息架构: SYS@honor1 > show parameter diag; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ diagnostic_dest string /u01/app/oracle SYS@honor1 > show parameter audit