posted @ 2024-10-17 13:41 IT-35plus 阅读(9) 评论(0) 推荐(0) 编辑
posted @ 2024-10-12 23:34 IT-35plus 阅读(11) 评论(0) 推荐(0) 编辑
|
|||
摘要:
结论1:主库和master ob 挂掉,不会fofo! DGMGRL> SHOW OBSERVERS ObserverConfigFile=observer.ora observer configuration file parsing succeeded Submitted command "SH 阅读全文
posted @ 2024-10-12 23:34 IT-35plus 阅读(11) 评论(0) 推荐(0) 编辑
摘要:
详见 https://www.bilibili.com/video/BV1QY2uYNEAY 阅读全文
posted @ 2024-10-11 13:39 IT-35plus 阅读(2) 评论(0) 推荐(0) 编辑
摘要:
原有状态最大性能: DGMGRL> SHOW CONFIGURATION lag verbose Configuration - dg_config Protection Mode: MaxPerformance Members: orcl - Primary database orcl2dg - 阅读全文
posted @ 2024-10-11 13:34 IT-35plus 阅读(9) 评论(0) 推荐(0) 编辑
摘要:
1 创建metric 确定触发诊断阈值(利用现有得也可以) 监控脚本select a.event, a.SECONDS_IN_WAIT from v$session a where blocking_session is not null and event = 'enq: TX - row loc 阅读全文
posted @ 2024-09-12 11:37 IT-35plus 阅读(9) 评论(0) 推荐(0) 编辑 |
|||