(接上文)
https://likingzi.com/2021/06/09/大量事务并发回滚彻底堵塞数据库1/
https://likingzi.com/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
以上只是为了证明数据库主库在当时并不存在归档空间满的情况。
---未完待续
文章评论