Why alert log shows: Diskgroup Gets Mounted / Dismounted

I always see the following messages in Alertlog , was curious to know the reason behind it…


Wed Jun 25 06:35:22 2014
SUCCESS: diskgroup DATA2 was mounted
SUCCESS: diskgroup DATA2 was dismounted
SUCCESS: diskgroup DATA2 was mounted
SUCCESS: diskgroup DATA2 was dismounted
SUCCESS: diskgroup DATA2 was mounted
SUCCESS: diskgroup DATA2 was dismounted
SUCCESS: diskgroup DATA2 was mounted
SUCCESS: diskgroup DATA2 was dismounted
Wed Jun 25 06:35:22 2014
Starting control autobackup
Control autobackup written to DISK device
 handle '/backup/BAK/OMSMIT/cfc-453770213-20140625-01.ctl'
Wed Jun 25 06:35:38 2014
SUCCESS: diskgroup DATA2 was mounted
SUCCESS: diskgroup DATA2 was dismounted
SUCCESS: diskgroup DATA2 was mounted
SUCCESS: diskgroup DATA2 was dismounted
Wed Jun 25 09:34:53 2014

According to metalink note : Why Archive, FRA Diskgroup Gets Mounted / Dismounted ? (Doc ID 603204.1)

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 FLASHDG_NEW 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.

This alerts will be only seen for diskgroups that holds flash recovery area.

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.


Hope so u will find this post very useful 🙂

Cheers

Regards,

Adityanath

10 replies

  1. This is a very good tip particularly to those new to the blogosphere. Short but very precise info… Appreciate your sharing this one. A must read post!

  2. I like the valuable info you provide in your articles.

    I will bookmark your blog and check again here regularly.
    I’m quite sure I will learn a lot of new stuff right here!
    Best of luck for the next!

  3. I was reading some of your posts on this internet site and I think this site is real instructive! Keep putting up.

  4. Howdy are using WordPress for your blog platform?
    I’m new to the blog world but I’m trying to get started and
    create my own. Do you need any coding knowledge to make your own blog?

    Any help would be really appreciated!

  5. Hello there! This is my first comment here so I just wanted to give a quick shout out and say I really enjoy reading your blog posts. Can you recommend any other blogs/websites/forums that cover the same topics? Thanks!

  6. I’m truly enjoying the design and layout of your site. It’s a very easy on the eyes which makes it much more enjoyable for me to come here and visit more often. Did you hire out a designer to create your theme? Excellent work!

  7. I truly love your site.. Great colors & theme. Did you develop this amazing site yourself? Please reply back as I’m trying to create my very own site and would love to learn where you got this from or just what the theme is named. Thank you!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s