认真就输

前期发布的Oracle环境中自动删除归档日志有很多朋友在生产环境中已经部署，其中发现了部分小问题，今天把这些问题都已经修复了，请大家及时在群里面下载最新的版本。

[oracle@primary tmp]$ ./delete_archive  -h
Usage: ./delete_archive [options]
Options:
  -s <instance>   instance name you will delete archivelog, 0 means all instances (default: htz)
  -n <num>        Threshold (percent) to trigger log deletion (default: 90)
  -f <num2>       Threshold (percent) to trigger forced log deletion (default: 98)
  -d              Enable script debugging
  -v              display script version and contact info
  -h, --help      display this help information

Version: 0.2
Contact: For the latest version, contact phone/WeChat: 18081072613

[oracle@primary tmp]$ ./delete_archive  -s 0 -f 50
2025-08-19 11:12:39.636088 main.main                : Script started at: 2025-08-19T11:12:39+08:00
2025-08-19 11:12:39.684785 main.getRunningInstances : Running instances: his
2025-08-19 11:12:39.684814 main.setOracleSID        : beging executing modify Oracle sid
2025-08-19 11:12:39.684823 main.checkCkptProcess    : beging executing check ckpt process
2025-08-19 11:12:39.732681 main.setOracleSID        : Set ORACLE_SID to: his
2025-08-19 11:12:39.818310 main.setOracleSID        : beging executing modify Oracle sid
2025-08-19 11:12:39.818323 main.checkCkptProcess    : beging executing check ckpt process
2025-08-19 11:12:39.865318 main.setOracleSID        : Set ORACLE_SID to: his
2025-08-19 11:12:40.029989 main.getDiskUsage        : The archive path is configured as a file system
2025-08-19 11:12:40.131168 main.getDiskUsage        : Using FRA to manage archive logs
2025-08-19 11:12:40.221763 main.deleteMain          : Current archive used PCT :79 and Force delete archive log
2025-08-19 11:12:40.221777 main.deleteArchLog       : Begin delete archive log 
2025-08-19 11:12:43.160135 main.getDiskUsage        : The archive path is configured as a file system
2025-08-19 11:12:43.244757 main.getDiskUsage        : Using FRA to manage archive logs
2025-08-19 11:12:43.333405 main.deleteMain          : Current archive used PCT :79 and Force delete archive log
2025-08-19 11:12:43.333420 main.deleteArchLog       : Begin delete archive log 
2025-08-19 11:12:46.239023 main.getDiskUsage        : The archive path is configured as a file system
2025-08-19 11:12:46.321487 main.getDiskUsage        : Using FRA to manage archive logs
2025-08-19 11:12:46.410271 main.deleteMain          : Current archive used PCT :78 and Force delete archive log
2025-08-19 11:12:46.410286 main.deleteArchLog       : Begin delete archive log 
2025-08-19 11:12:49.300022 main.getDiskUsage        : The archive path is configured as a file system
2025-08-19 11:12:49.381976 main.getDiskUsage        : Using FRA to manage archive logs
2025-08-19 11:12:49.467961 main.deleteMain          : Current archive used PCT :78 and Force delete archive log
2025-08-19 11:12:49.467973 main.deleteArchLog       : Begin delete archive log 
2025-08-19 11:12:52.335126 main.getDiskUsage        : The archive path is configured as a file system
2025-08-19 11:12:52.423801 main.getDiskUsage        : Using FRA to manage archive logs
2025-08-19 11:12:52.517380 main.deleteMain          : Current archive used PCT :77 and Force delete archive log
2025-08-19 11:12:52.517397 main.deleteArchLog       : Begin delete archive log 
2025-08-19 11:12:55.404024 main.getDiskUsage        : The archive path is configured as a file system
2025-08-19 11:12:55.492048 main.getDiskUsage        : Using FRA to manage archive logs
2025-08-19 11:12:55.579164 main.deleteMain          : Current archive used PCT :77 and Force delete archive log
2025-08-19 11:12:55.579179 main.deleteArchLog       : Begin delete archive log 
2025-08-19 11:12:58.454136 main.getDiskUsage        : The archive path is configured as a file system
2025-08-19 11:12:58.537819 main.getDiskUsage        : Using FRA to manage archive logs
2025-08-19 11:12:58.627192 main.deleteMain          : Current archive used PCT :76 and Force delete archive log
2025-08-19 11:12:58.627205 main.deleteArchLog       : Begin delete archive log 
2025-08-19 11:12:58.714552 main.deleteArchLog       : Get error archive log info :no rows selected

——————作者介绍———————–
姓名：黄廷忠
现就职：Oracle中国高级服务团队
曾就职：OceanBase、云和恩墨、东方龙马等
电话、微信、QQ：18081072613
个人博客: (http://www.htz.pw)
CSDN地址: (https://blog.csdn.net/wwwhtzpw)
博客园地址: (https://www.cnblogs.com/www-htz-pw)