Clear the database log

最新推荐文章于 2024-10-31 19:05:05 发布

名曰华平

最新推荐文章于 2024-10-31 19:05:05 发布

阅读量1.7k

点赞数

CC 4.0 BY-SA版权

分类专栏： The Oracle Operation Guide

本文链接：https://blog.youkuaiyun.com/mingyuehuaping/article/details/11756019

The Oracle Operation Guide 专栏收录该内容

3 篇文章

订阅专栏

本文指导如何在Oracle 11g环境下清理ASM日志、客户端日志、RDBMS日志、监听器日志，并移除审计日志文件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

ORACLE_Guide_Clear the database log

1. Clean the ASM log

oracle11g:

oracle@host1:~> cd $ORACLE_BASE/diag/asm/+asm/<ASM_SID>/alert

oracle@host1:~> find ./ -name "log_*.xml"|xargs rm -rf

oracle@host1:~> cp $ORACLE_BASE/diag/asm/+asm/<ASM_SID>/trace/alert_<ASM_SID>.log /tmp/alert_<ASM_SID>.log.bak <====== Must finish the backup

oracle@host1:~> echo ‘’ > $ORACLE_BASE/diag/asm/+asm/<ASM_SID>/trace/alert_<ASM_SID>.log

2. Clean the clients log

oracle11g:

oracle@host1:~> cd $ORACLE_BASE/diag/clients/<USER_NAME>/<HOST_NAME>/alert

oracle@host1:~> find ./ -name "log_*.xml"|xargs rm -rf

oracle@host1:~> cp $ORACLE_BASE/diag/clients/<USER_NAME>/<HOST_NAME>/sqlnet.log /tmp/sqlnet.log.bak <====== Must finish the backup

oracle@host1:~> echo ‘’ > $ORACLE_BASE/diag/clients/<USER_NAME>/<HOST_NAME>/sqlnet.log

3. Clean the rdbms log

oracle11g:

oracle@host1:~> cd $ORACLE_BASE/diag/rdbms/<DB_NAME>/<ORACLE_SID>/alert

oracle@host1:~> find ./ -name "log_*.xml"|xargs rm -rf

oracle@host1:~> cp $ORACLE_BASE/diag/rdbms/<DB_NAME>/<ORACLE_SID>/trace/alert_<ORACLE_SID>.log /tmp/alert_<ORACLE_SID>.log.bak <====== Must finish the backup

oracle@host1:~> echo ‘’ > $ORACLE_BASE/diag/rdbms/<DB_NAME>/<ORACLE_SID>/trace/alert_<ORACLE_SID>.log

4. Clean the listener log

oracle11g:

oracle@host1:~> cd $ORACLE_BASE/diag/tnslsnr/<HOSTNAME>/<LISTENER_NAME>/alert

oracle@host1:~> find ./ -name "log_*.xml"|xargs rm -rf

oracle@host1:~> cp $ORACLE_BASE/diag/tnslsnr/<HOSTNAME>/<LISTENER_NAME>/trace/listener.log /tmp/listener.log.bak <====== Must finish the backup

oracle@host1:~> echo ‘’ > $ORACLE_BASE/diag/tnslsnr/<HOSTNAME>/<LISTENER_NAME>/trace/listener.log

5. Removethe audit log file

oracle11g:

oracle@host1:~>cd $ORACLE_BASE/admin/<SID_NAME>/adump

oracle@host1:~>find ./ -name "*.aud"|xargs rm -rf