708876904310351ae4.png (421.9 KB, 下载次数: 73)
2025-10-31 11:46 上传
怀疑是备库有问题，于是登录上去发现果然，备库从6月6日被人为关闭了
2175769044f48cc605.png (199.2 KB, 下载次数: 69)
2025-10-31 13:55 上传
因此怀疑是归档日志传不过去，导致空间不够了，查看asm磁盘
3174569044f6826e2f.png (248.06 KB, 下载次数: 89)
2025-10-31 13:55 上传
果然是这个原因，归档日志自从6月6日备库被关闭后一直未能自动删除
3931269044f761ee77.png (230.7 KB, 下载次数: 77)
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参数，系统完全恢复正常
| 欢迎光临 重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/) | Powered by Discuz! X3.2 |