#!/bin/bash
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=/oracle/app/oracle/product/12.2.0/db
export ORACLE_SID=gc
export PATH=$ORACLE_HOME/bin:$PATH
sqlplus / as sysdba <<EOF
delete from aud$
where substr(sysdate-NTIMESTAMP#,2,9)>180;
commit;
exit
EOF
定时清理审计日志
最新推荐文章于 2023-10-12 09:10:56 发布