大量事务并发回滚彻底堵塞数据库(3)

2021年6月11日 1237点热度 1人点赞 0条评论

(接上文)
https://liking.site/2021/06/09/大量事务并发回滚彻底堵塞数据库1/
https://liking.site/2021/06/10/大量事务并发回滚彻底堵塞数据库2/
在后续的故障定位时,有人根据如下日志,认为是归档空间满,导致了数据库挂死。

实际不然,这个FAL报错,只是到DG的归档由于其他原因导致了报错,日志也写在了主库alertlog文件,并非是主库归档失败,对主库并无其他影响,仅仅是写了一个日志而已。事后我的详细排查也印证了这一点,当天中午12:00和18:00分别有一次短信提示,如下。

当前时间是:2021-06-04 12:00,归档监控短信提醒:171总大小:5000GB,171空间已使用:3415.52GB,171空间剩余百分比:31.69%
当前时间是:2021-06-04 18:06,归档监控短信提醒:171总大小:5000GB,171空间已使用:3030.58GB,171空间剩余百分比:39.39%

且定时任务日志显示,16:05刚刚清理了一次过期日志,如下。

Recovery Manager: Release 11.2.0.4.0 - Production on Fri Jun 4 16:05:01 2021
,,,
3340556 1    624981  A 2021-06-03 12:04:45
        Name: +FRA/jkdb/archivelog/2021_06_03/thread_1_seq_624981.286.1074254719
,,,
3341290 1    625094  A 2021-06-03 16:01:06
        Name: +FRA/jkdb/archivelog/2021_06_03/thread_1_seq_625094.4142.1074268981
3340558 2    536296  A 2021-06-03 12:04:30
        Name: +FRA/jkdb/archivelog/2021_06_03/thread_2_seq_536296.1029.1074254725
,,,
3341292 2    536426  A 2021-06-03 16:01:43
        Name: +FRA/jkdb/archivelog/2021_06_03/thread_2_seq_536426.1675.1074269001
3340560 3    575370  A 2021-06-03 12:04:43
        Name: +FRA/jkdb/archivelog/2021_06_03/thread_3_seq_575370.1189.1074254743
,,,
3341294 3    575494  A 2021-06-03 16:02:15
        Name: +FRA/jkdb/archivelog/2021_06_03/thread_3_seq_575494.1319.1074269079
,,,
deleted archived log
archived log file name=+FRA/jkdb/archivelog/2021_06_03/thread_1_seq_624981.286.1074254719 RECID=3340556 STAMP=1074254722
,,,
deleted archived log
archived log file name=+FRA/jkdb/archivelog/2021_06_03/thread_1_seq_625094.4142.1074268981 RECID=3341290 STAMP=1074268990
deleted archived log
archived log file name=+FRA/jkdb/archivelog/2021_06_03/thread_2_seq_536296.1029.1074254725 RECID=3340558 STAMP=1074254736
,,,
deleted archived log
archived log file name=+FRA/jkdb/archivelog/2021_06_03/thread_2_seq_536426.1675.1074269001 RECID=3341292 STAMP=1074269017
deleted archived log
archived log file name=+FRA/jkdb/archivelog/2021_06_03/thread_3_seq_575370.1189.1074254743 RECID=3340560 STAMP=1074254745
,,,
deleted archived log
archived log file name=+FRA/jkdb/archivelog/2021_06_03/thread_3_seq_575494.1319.1074269079 RECID=3341294 STAMP=1074269087
Deleted 370 objects

以上只是为了证明数据库主库在当时并不存在归档空间满的情况。
---未完待续

liking

这个人很懒,什么都没留下

文章评论