2023年8月1日发(作者：)
oracle19c⽇志，审计，监听⽂件过多，过⼤1、审计⽂件查看审计⽂件存储路径show parameter dump或者show parameter auditNAME TYPE VALUE
--------------- ------ -----------
diagnostic_dest string /vol/oracle
NAME TYPE VALUE
-------------------- ------ --------------------------------------------
background_dump_dest string /opt/oracle/product/19c/dbhome_1/rdbms/log
core_dump_dest string /vol/oracle/diag/rdbms/orclcdb/ORCLCDB/cdump
user_dump_dest string /opt/oracle/product/19c/dbhome_1/rdbms/log
**NAME TYPE VALUE
--------------- ------ -------------------------------
audit_file_dest string /opt/oracle/admin/ORCLCDB/adump**
NAME TYPE VALUE
-------------------- ------ ------------------------------------------
background_dump_dest string /opt/oracle/product/19c/dbhome_1/rdbms/log
NAME TYPE VALUE
------ ------ ------------------------------------------------------
spfile string /opt/oracle/product/19c/dbhome_1/dbs/
NAME TYPE VALUE
-------------------- ------ --------------------------------------------
background_core_dump string partial
background_dump_dest string /opt/oracle/product/19c/dbhome_1/rdbms/log
core_dump_dest string /vol/oracle/diag/rdbms/orclcdb/ORCLCDB/cdump
max_dump_file_size string unlimited
shadow_core_dump string partial
user_dump_dest string /opt/oracle/product/19c/dbhome_1/rdbms/log
adump:审计信息bdump：后台进程trace和alert log,就是说alert_⽇志也存在此处cdump：core trace,⼀般是⽤来⽇志应⽤程序的 除⾮数据库出了问题 否则基本上不会有什么信息
dpdump ：是存放⼀些登录信息的pfile ：初始化参数⽂件 initSID
udump ：user dump，前台⼿动trace的 ⽐如sql trace之后session的trace⽂件修改审计⽂件路径vim /opt/oracle/product/19c/dbhome_1/dbs/*.audit_file_dest=’/opt/oracle/admin/ORCLCDB/adump’alter system set AUDIT_FILE_DEST=。。。 scope=spfile;2、监听⽂件查看监听⽂件位置[oracle@93 ~]$ adrci
ADRCI: Release 19.0.0.0.0 - Production on Mon Jun 28 10:48:06 2021Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights base = "/vol/oracle"adrci> show homesADR Homes:
diag/rdbms/orclcdb/ORCLCDBdiag/tnslsnr/93/listener或者select value from v$diag_info where name='Diag Trace';select value from v$diag_info where name='Diag Alert';处理办法1、关闭监听⽇志记录lsnrctl set log_status off2、备份3、清空⽇志或定期删除echo /dev/null > d /opt/oracle/diag/tnslsnr/93/listener/alert/ -ctime +30 -name log*.xml -exec rm {} ;find /opt/oracle/diag/tnslsnr/93/listener/trace -ctime +30 -name listener*.log -exec rm {} ;4、开启监听⽇志记录lsnrctl set log_status on5、修改⽇志路径show parameter diagnostic_destalter system set diagnostic_dest = '/u02/app/oracle';不⽤重启及时⽣效这样修改有可能原有session不在新路径下⽣成⽇志，待验证。3、备份⽂件。。。
2023年8月1日发(作者：)
oracle19c⽇志，审计，监听⽂件过多，过⼤1、审计⽂件查看审计⽂件存储路径show parameter dump或者show parameter auditNAME TYPE VALUE
--------------- ------ -----------
diagnostic_dest string /vol/oracle
NAME TYPE VALUE
-------------------- ------ --------------------------------------------
background_dump_dest string /opt/oracle/product/19c/dbhome_1/rdbms/log
core_dump_dest string /vol/oracle/diag/rdbms/orclcdb/ORCLCDB/cdump
user_dump_dest string /opt/oracle/product/19c/dbhome_1/rdbms/log
**NAME TYPE VALUE
--------------- ------ -------------------------------
audit_file_dest string /opt/oracle/admin/ORCLCDB/adump**
NAME TYPE VALUE
-------------------- ------ ------------------------------------------
background_dump_dest string /opt/oracle/product/19c/dbhome_1/rdbms/log
NAME TYPE VALUE
------ ------ ------------------------------------------------------
spfile string /opt/oracle/product/19c/dbhome_1/dbs/
NAME TYPE VALUE
-------------------- ------ --------------------------------------------
background_core_dump string partial
background_dump_dest string /opt/oracle/product/19c/dbhome_1/rdbms/log
core_dump_dest string /vol/oracle/diag/rdbms/orclcdb/ORCLCDB/cdump
max_dump_file_size string unlimited
shadow_core_dump string partial
user_dump_dest string /opt/oracle/product/19c/dbhome_1/rdbms/log
adump:审计信息bdump：后台进程trace和alert log,就是说alert_⽇志也存在此处cdump：core trace,⼀般是⽤来⽇志应⽤程序的 除⾮数据库出了问题 否则基本上不会有什么信息
dpdump ：是存放⼀些登录信息的pfile ：初始化参数⽂件 initSID
udump ：user dump，前台⼿动trace的 ⽐如sql trace之后session的trace⽂件修改审计⽂件路径vim /opt/oracle/product/19c/dbhome_1/dbs/*.audit_file_dest=’/opt/oracle/admin/ORCLCDB/adump’alter system set AUDIT_FILE_DEST=。。。 scope=spfile;2、监听⽂件查看监听⽂件位置[oracle@93 ~]$ adrci
ADRCI: Release 19.0.0.0.0 - Production on Mon Jun 28 10:48:06 2021Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights base = "/vol/oracle"adrci> show homesADR Homes:
diag/rdbms/orclcdb/ORCLCDBdiag/tnslsnr/93/listener或者select value from v$diag_info where name='Diag Trace';select value from v$diag_info where name='Diag Alert';处理办法1、关闭监听⽇志记录lsnrctl set log_status off2、备份3、清空⽇志或定期删除echo /dev/null > d /opt/oracle/diag/tnslsnr/93/listener/alert/ -ctime +30 -name log*.xml -exec rm {} ;find /opt/oracle/diag/tnslsnr/93/listener/trace -ctime +30 -name listener*.log -exec rm {} ;4、开启监听⽇志记录lsnrctl set log_status on5、修改⽇志路径show parameter diagnostic_destalter system set diagnostic_dest = '/u02/app/oracle';不⽤重启及时⽣效这样修改有可能原有session不在新路径下⽣成⽇志，待验证。3、备份⽂件。。。
![一种面向实时数据库的独立透明型安全审计保护的方法[发明专利]](/uploads/image/0819.jpg)
发布评论