oracle 清理listener

more del_lisenter_log.sh

rq=`date +%d`
HOME=xxxxxxxxxxxxxx/listener/trace
cp $HOME/listener.log $HOME/listener_$rq.txt
lsnrctl set log_status off
cp /dev/null $HOME/listener.log
lsnrctl set log_status on

more del_oracle_xml_log.sh

find xxxxxxxxxxxxxxxxxxxxxxx/listener/alert -maxdepth 1 -name log_*.xml -type f -mtime +30 -exec rm -f {} \;

more delarch.txt

run{
crosscheck archivelog all;
delete force noprompt archivelog all completed before ‘sysdate-5’;
}

more delarch.sh
source /home/oracle/.bash_profile
cd /home/oracle/xxxxxx
rman target / nocatalog cmdfile delarch.txt log=/home/oracle/xxxxxx/delarch.log.`date +%Y%m%d` append

上一篇 倒计时1天!掘金年度演讲明天见!精彩亮点抢先看
下一篇 openGauss学习笔记126 openGauss 数据库管理设置账本数据库归档账本数据库