Thu Apr 7 03:41:01 2011
SUCCESS: diskgroup RECOVERY_AREA was mounted
SUCCESS: diskgroup RECOVERY_AREA was dismounted
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2 to 10.2
This problem can occur on any platform.
Symptoms:
Database alert.log shows the following messages frequently:
SUCCESS: diskgroup LOG was mounted
SUCCESS: diskgroup LOG was dismounted
SUCCESS: diskgroup LOG was mounted
SUCCESS: diskgroup LOG was dismounted
Cause:
This is intended behavior.
From bug:4465015 Asm Diskgroup For Flash Recovery Area Display Mount And Dismount In Db Alert Log (Not published)
This is expected behavior. The messages you see are not errors (that is why they are prefixed with "SUCCESS"). The database instance is creating and then closing archive logs one at a time in the LOG disk group.
Whenever a database closes its last file in a disk group, it dismounts the disk group.
Whenever a database accesses a disk group when it does not have any other files open in the disk group, it mounts the disk group.
If a diskgroup is used only for flashback feature and rman backups in a database, many log messages are seen in alert.log. However, the same may also occur for diskgroups keeping datafiles but in less frequency.
Solution:
This is intended behavior. No solution is required. If you do not want to see the log messages frequently, you can put a mirrored control-file, or mirrored online redo, or dummy online tablespace data file on the diskgroup. This message will not be output frequently in this case. Because CKPT keeps opening a control-file, LGWR keeps opening an online redo, DBW keeps opening an online tablespace data file. So, the diskgroup is not dismounted until the database shutdown.
本文解析了Oracle ASM磁盘组(特别是用于闪回和RMAN备份的磁盘组)在数据库警报日志中频繁显示挂载和卸载消息的现象。这是一种预期行为,通常与数据库实例创建和关闭归档日志有关。为了避免这些消息频繁出现,可以在磁盘组中放置镜像控制文件、在线重做日志或虚拟在线表空间数据文件。

4万+

被折叠的 条评论
为什么被折叠?



