Linux环境下定期清理归档日志

Linux环境下定期清理归档日志
1、执行 sqlplus /nolog进入SQLPlus， 执行 conn / as sysdba
[oracle@custom04 data]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sat Feb 2 16:37:55 2019
Copyright © 1982, 2009, Oracle. All rights reserved.
Connected.
SQL>
2、执行show parameter recover;查询归档日志的位置，注意：如果更改过归档日志路径，请执行archive log list;查看
SQL> show parameter recover;

NAME TYPE VALUE

---

db_recovery_file_dest string /data/oracle/flash_recovery_area
db_recovery_file_dest_size big integer 70G
recovery_parallelism integer 0
SQL>
–更改过归档日志路径的情况查看，执行archive log list;
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /home/oracle/oracle_fast_recovery_area
Oldest online log sequence 1622
Next log sequence to archive 1624
Current log sequence 1624
SQL>
3、进入归档日志目录，查看并记住文件个数。执行ls -l |grep “^-”|wc -l
[root@custom04 oracle_fast_recovery_area]# ls -l |grep “^-”|wc -l
1215
4、建立del_archivelog.sh脚本，执行vi del_archivelog.sh
[oracle@custom04 oracle]$ vi del_archivelog.sh
5、输入内容，注意修改/data/oracle/del_archivelog/路径
#!/bin/bash
echo “----------------------------------------date---------------------------------------”
source ~/.bash_profile
LOG_DIR=/data/oracle/del_archivelog/
DATEL=date '+%Y-%m-%d'
LOG_NAME=$LO{G}_{D}IR${DATEL}".log"

rman log=KaTeX parse error: Undefined control sequence: \n at position 166: …; EOF echo -e "\̲n̲" echo "-------… chmod 777 del_archivelog.sh
5、测试脚本是否有效，执行./del_archivelog.sh
[oracle@custom04 oracle]$ ./del_archivelog.sh
----------------------------------------Sun Feb 3 13:41:11 CST 2019---------------------------------------
RMAN> RMAN> RMAN> RMAN>

------------------------------------- FINISHED -------------------------------------
[oracle@custom04 oracle]$
6、再次查看归档日志目录文件个数。执行ls -l |grep “^-”|wc -l
[root@custom04 oracle_fast_recovery_area]# ls -l |grep “^-”|wc -l
1189
7、创建 crontab定时任务，执行crontab -e
[oracle@custom04 oracle]$ crontab -e
8、写入内容，每天凌晨4点执行脚本del_archivelog.sh，并将执行结果输出到task.log
00 4 * * * sh /data/oracle/del_archivelog.sh >> /data/oracle/del_archivelog/task.log 2>&1 &
9、查看crontab所有定时任务，执行crontab -l
[oracle@custom04 oracle]$ crontab -l
00 4 * * * sh /data/oracle/del_archivelog.sh >> /data/oracle/del_archivelog/task.log 2>&1 &
到此整个Linux下的配置已结束，注意定期观察任务的运行情况。