Oracle在CentOS上的日志管理可从以下方面入手:
$ORACLE_BASE/diag/rdbms/db_name/instance_name/trace/alert_instance_name.log。$ORACLE_BASE/diag/rdbms/db_name/instance_name/trace目录。$ORACLE_HOME/dbs或数据文件目录。ALTER SYSTEM SET LOG_ARCHIVE_MODE=TRUE SCOPE=BOTH;
ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=/u01/archivelog' SCOPE=BOTH;
logrotate工具配置,示例配置(针对Alert日志):/u01/app/oracle/diag/rdbms/*/trace/alert_*.log {
daily
rotate 7
compress
missingok
postrotate
/bin/kill -HUP `cat /u01/app/oracle/diag/rdbms/*/instance_name/pid`
endscript
}
chown -R oracle:oinstall /u01/app/oracle/logs。top、iostat等命令监控日志写入性能,避免I/O瓶颈。ALTER DATABASE ADD LOGFILE增加成员)。ENABLE_DDL_LOGGING),便于追踪结构变更。参考来源: