归档日志未能及时删除导致客户端连接不上数据库

ZhangQi · 发表于 2025-11-1 19:53:54

本帖最后由 ZhangQi 于 2025-10-31 13:58 编辑

前几天有用户反映，使用plsql登录不上去某一台数据库了，这台数据库自从6月开始就不再负责业务，数据量也渐渐不再产生，大多数情况作为查询的工具来使用

那边老师怀疑是备份原因卡起了，并且该数据库是rac+dg的方式，查看主库日志发现，一直再爆连接不上备库

登录/注册后可看大图

708876904310351ae4.png (421.9 KB, 下载次数: 72)

下载附件

2025-10-31 11:46 上传

怀疑是备库有问题，于是登录上去发现果然，备库从6月6日被人为关闭了

登录/注册后可看大图

2175769044f48cc605.png (199.2 KB, 下载次数: 67)

下载附件

2025-10-31 13:55 上传

因此怀疑是归档日志传不过去，导致空间不够了，查看asm磁盘

登录/注册后可看大图

3174569044f6826e2f.png (248.06 KB, 下载次数: 88)

下载附件

2025-10-31 13:55 上传

果然是这个原因，归档日志自从6月6日备库被关闭后一直未能自动删除

登录/注册后可看大图

3931269044f761ee77.png (230.7 KB, 下载次数: 76)

下载附件

2025-10-31 13:56 上传

因此手动删除7天前归档日志，使用命令：DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7';

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture processarchived log file name=+LOGDG/orcl/archivelog/2025_10_22/thread_2_seq_142742.13993.1215157903 thread=2 sequence=142742RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture processarchived log file name=+LOGDG/orcl/archivelog/2025_10_22/thread_2_seq_142743.13995.1215159703 thread=2 sequence=142743RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture processarchived log file name=+LOGDG/orcl/archivelog/2025_10_22/thread_2_seq_142744.13997.1215161501 thread=2 sequence=142744RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture processarchived log file name=+LOGDG/orcl/archivelog/2025_10_22/thread_2_seq_142745.13999.1215163303 thread=2 sequence=142745RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture processarchived log file name=+LOGDG/orcl/archivelog/2025_10_22/thread_2_seq_142746.14001.1215165103 thread=2 sequence=142746RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture processarchived log file name=+LOGDG/orcl/archivelog/2025_10_22/thread_2_seq_142747.14003.1215166905 thread=2 sequence=142747RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture processarchived log file name=+LOGDG/orcl/archivelog/2025_10_22/thread_2_seq_142748.14005.1215168705 thread=2 sequence=142748RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture processarchived log file name=+LOGDG/orcl/archivelog/2025_10_22/thread_2_seq_142749.14008.1215170505 thread=2 sequence=142749

原来是我刚刚将备库打开了的，于是先关闭了备库，然后在主库设置将 log_archive_dest_state_2设置为DEFER，再在rman中运行命令，此时运行成功，归档日志得以删除，用户也反映能够通过客户端连进去了

后面重新同步主备库，重新启用log_archive_dest_state_2参数，系统完全恢复正常

帐号		自动登录	找回密码
密码			注册

归档日志未能及时删除导致客户端连接不上数据库

浏览过的版块