Database - RAC/Scalability (MOSC)

MOSC Banner

redo日志切换频繁和生成的归档日志大小很小问题

edited Jan 28, 2017 4:00AM in Database - RAC/Scalability (MOSC) 1 commentAnswered

最近我们一套10.2.0.4单实例数据库迁移到11.2.0.4的2节点RAC后,出现redo日志切换异常频繁,采用VMware虚拟化服务器,配置24c,96G内存,redo日志设置为100M,基本上每1-2分钟切换一次redo日志,高峰时几秒就切换一次,但是每次切换redo日志并没有写满,部分归档日志只有10多M甚至几兆一个,如下:

redo日志切换记录:

归档日志大小:

AWR报告redo日志量:

节点1:

节点2:

log_buffer大小:

请各位帮忙看看什么问题,谢谢

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center