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
Categories: Administration
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!
I rattling glad to find this website on bing, just what I was looking for : D besides bookmarked.
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!
Like!! Thank you for publishing this awesome article.
I was reading some of your posts on this internet site and I think this site is real instructive! Keep putting up.
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!
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!
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!
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!
This site was… how do I say it? Relevant!! Finally I have found something which helped me. Cheers!