Saturday, September 8, 2012

This scenario describes what happens when you lose one redo log member of a multiplexed group.
It could happen for a simply
media failure or because some one "needed" to free some space and saw that .log file!!!
It happens to me years ago and that was
told to me by a system administrator.

Anyway when you have multiplexed your redo log group using several members as Oracle best practices suggest and your disks begin to experience problems
your database will continue to function since it's still able to write to one redo log member.
If your disk is completely out you can opt to some options whether or not you have a new disk!
With a new disk you can drop and create again the "lost" redo log member to the original location, otherwise you have to perform the same two steps
(drop and create) choosing a different location.
Even if you have already lost your redo log member Oracle will arise the ORA-01609 error when you try to drop
a member of a CURRENT group.
Querying the status column of V$LOG view you can have several results and generally they are:
CURRENT when that log file is "currently" written by the log writer process (ps -ef|grep lgwr),
ACTIVE when that log file is required in case of a crash recovery (even if it's already archived)
INACTIVE when that log file is not required in case of a crash recovery.

So when you try to drop your "failed" redo log member and you receive the ORA-01609 error just force the database to switch to the next redo log group.

As you can see I have three redo log groups formed by two multiplexed members and currently the redo log group number 2 is the CURRENT one.
Now I simulate the lost of the redo log member named 'redo02b.log'.

What's happening ? My new redo log member is still INVALID ? What does it mean ?
If you look at the Oracle documentation INVALID could mean: inaccessible (as it was before) or just created (as I did few lines above).
Let's look what it happens when I force logfiles to switch:

190 comments:

Anonymous
said...

Wow that was odd. I just wrote an incredibly long comment but after I clicked submit my comment didn't appear. Grrrr... well I'm not writing all that over again. Anyway, just wanted to say wonderful blog!Here is my webpageget real money online

It is the best time to make some plans for the long run and it is time to be happy.I've learn this post and if I may just I desire to suggest you some attention-grabbing things or advice. Perhaps you can write subsequent articles referring to this article. I wish to read even more things about it!My website : play online blackjack for money

Generally I don't learn post on blogs, but I wish to say that this write-up very forced me to try and do it! Your writing style has been surprised me. Thank you, quite nice article.Here is my homepage : real money slots online

Thank you for the auspicious writeup. It in fact was a amusement account it. Look advanced to far added agreeable from you!However, how can we communicate?Also visit my webpageplay slots for real Money online

Usually I don't read article on blogs, however I would like to say that this write-up very pressured me to check out and do it! Your writing style has been surprised me. Thank you, quite great article.Feel free to surf my site : online blackjack for real money

I know this if off topic but I'm looking into starting my own blog and was wondering what all is required to get set up? I'm assuming having a blog like yours would cost a pretty penny? I'm not very internet smart so I'm not 100% sure. Any tips or advice would be greatly appreciated. Many thanksFeel free to visit my web site ... online casino eecbLac http://bestonlinecasinoworld.tumblr.com/

Ahaa, its fastidious discussion concerning this piece of writing at this place at this webpage, I have read all that, so at this time me also commenting here.Have a look at my web page : forex online trading

Hello there! I know this is kinda off topic but I was wondering if you knew where I could find a captcha plugin for my comment form? I'm using the same blog platform as yours and I'm having difficulty finding one?Thanks a lot!My weblogreal online slots

Hey just wanted to give you a quick heads up. The text in your post seem to be running off the screen in Firefox. I'm not sure if this is a format issue or something to do with browser compatibility but I thought I'd post to let you know.The design look great though! Hope you get the issue fixed soon.Many thanksVisit my page : play slots for real money online

Thanks for any other informative web site. Where else may just I am getting that type of information written in such a perfect manner?I have a mission that I am simply now operating on, and I have been at the glance out for such info.My webpage ; real online roulette

Hi there! Do you know if they make any plugins to help with Search Engine Optimization?I'm trying to get my blog to rank for some targeted keywords but I'm not seeing very good gains. If you know of any please share. Appreciate it!My webpage :: Binary Options Signals

Thank you for any other excellent article. The place else may just anyone get that type of info in such a perfect manner of writing?I've a presentation next week, and I am on the look for such information.Also visit my web site :: on line slots for money

Asking questions are actually nice thing if you are not understanding something completely,however this piece of writing provides fastidious understanding yet.My web page: best ways to make money online

It's a pity you don't have a donate button! I'd without a doubt donate to this outstanding blog! I guess for now i'll settle for bookmarking and adding your RSS feed to my Google account. I look forward to new updates and will talk about this website with my Facebook group. Chat soon!My weblog : online blackjack real money

Today, I went to the beachfront with my children. I found a sea shell and gave it to my 4 year old daughter and said "You can hear the ocean if you put this to your ear." She placed the shell to her ear and screamed. There was a hermit crab inside and it pinched her ear. She never wants to go back! LoL I know this is completely off topic but I had to tell someone!Stop by my page - online trading academy scam

What's up everyone, it's my first go to see at this web site, and post is really fruitful designed for me, keep up posting these types of articles.Feel free to visit my web site : ways to make money fast

First of all I would like to say great blog!I had a quick question that I'd like to ask if you don't mind.I was interested to find out how you center yourself and clear your mind before writing. I have had a tough time clearing my thoughts in getting my ideas out. I do take pleasure in writing but it just seems like the first 10 to 15 minutes tend to be lost simply just trying to figure out how to begin. Any recommendations or tips?Cheers!Also visit my sitewyoming job search

It's the best time to make some plans for the future and it is time to be happy. I have read this post and if I could I want to suggest you some interesting things or advice. Perhaps you can write next articles referring to this article. I wish to read even more things about it!Here is my web-site ; traderush.tm

Hello There. I found your weblog the usage of msn.This is a really smartly written article. I will make sure to bookmark it and return to read more of your useful information. Thank you for the post. I will certainly comeback.My blogcasinos online usa

Hello there, just became aware of your blog through Google, and found that it's really informative. I am going to watch out for brussels. I will be grateful if you continue this in future. Numerous people will be benefited from your writing. Cheers!My web pagehow to make money on the side

Greetings I am so happy I found your blog, I really found you by accident, while I was researching on Google for something else, Nonetheless I am here now and would just like to say thanks for a incredible post and a all round interesting blog (I also love the theme/design),I don’t have time to look over it all at the moment but I have saved it and also included your RSS feeds, so when I have time I will be back to read a great deal more, Please do keep up the superb b.Review my blog : how to make good money online

you are truly a just right webmaster. The web site loading velocity is incredible. It kind of feels that you're doing any distinctive trick. Moreover, The contents are masterwork. you've done a fantastic process in this topic!My web page :: legit money making online

Hi there! Someone in my Facebook group shared this website with us so I came to look it over. I'm definitely enjoying the information. I'm book-marking and will be tweeting this to my followers! Wonderful blog and excellent style and design.my web page > online forex news

You are so awesome! I don't believe I have read something like that before. So good to find someone with a few original thoughts on this subject. Seriously.. many thanks for starting this up. This website is one thing that is required on the web, someone with a little originality!My web blog ... forex currency trading online

Wow, marvelous weblog layout! How long have you ever been running a blog for? you made blogging look easy. The full look of your site is magnificent, as smartly as the content material!Here is my web-site ; stock options strategies

Hey! I know this is kinda off topic nevertheless I'd figured I'd ask.Would you be interested in exchanging links or maybe guest writing a blog article or vice-versa?

My blog goes over a lot of the same subjects as yours and I think we could greatly benefit from each other.If you happen to be interested feel free to shoot me an email. I look forward to hearing from you! Wonderful blog by the way!

It's a pity you don't have a donate button! I'd without a doubt donate to this excellent blog! I guess for now i'll settle for book-marking and adding your RSS feed to my Google account. I look forward to brand new updates and will talk about this blog with my Facebook group.Talk soon!

you're really a just right webmaster. The website loading velocity is incredible. It sort of feels that you are doing any distinctive trick. Also, The contents are masterpiece. you have done a excellent process on this matter!

Just wish to say your article is as surprising. The clarity in your submit is simply excellent and that i could assume you're an expert in this subject. Well along with your permission let me to snatch your RSS feed to keep updated with forthcoming post. Thank you 1,000,000 and please keep up the rewarding work.

It's a shame you don't have a donate button! I'd definitely donate to this fantastic blog! I guess for now i'll settle for book-marking and adding your RSS feed to my Google account. I look forward to new updates and will share this website with my Facebook group. Chat soon!

I do trust all of the concepts you have offered for your post.They're very convincing and can definitely work. Nonetheless, the posts are very brief for starters. May just you please prolong them a little from subsequent time? Thanks for the post.

Hello There. I found your weblog the usage of msn. This is a very smartly written article. I'll make sure to bookmark it and come back to read more of your helpful information. Thank you for the post. I will certainly return.

Greetings! Quick question that's totally off topic. Do you know how to make your site mobile friendly? My website looks weird when browsing from my iphone 4. I'm trying to find a theme or plugin that might be able to fix this problem.If you have any suggestions, please share. Thanks!

Thanks , I've recently been looking for info approximately this topic for ages and yours is the greatest I have found out so far. However, what in regards to the conclusion? Are you certain concerning the supply?

Greetings! This is my first visit to your blog!We are a collection of volunteers and starting a new project in a community in the same niche. Your blog provided us beneficial information to work on.You have done a outstanding job!

Great blog you have here but I was wanting to know if you knew of any community forums that cover the same topics discussed here?I'd really love to be a part of online community where I can get suggestions from other knowledgeable individuals that share the same interest. If you have any recommendations, please let me know. Bless you!

Thanks on your marvelous posting! I truly enjoyed reading it,you are a great author. I will make sure to bookmark your blog and will often come back sometime soon.I want to encourage you to definitely continue your great work, have a nice morning!

Wonderful beat ! I wish to apprentice even as you amend your website, how can i subscribe for a blog site? The account helped me a applicable deal.I had been a little bit familiar of this your broadcast provided vivid clear concept

Do you have a spam issue on this website; I also am a blogger, and I was wanting to know your situation; we have created some nice procedures and we are looking to trade techniques with other folks, why not shoot me an e-mail if interested.

Nice post. I was checking continuously this blog and I am impressed!Very useful information specially the last part :) I care for such information a lot. I was seeking this certain info for a long time. Thank you and good luck.

Undeniably believe that which you said. Your favorite justification appeared to be on the web the simplest thing to be aware of. I say to you, I definitely get irked while people think about worries that they just don't know about. You managed to hit the nail upon the top and defined out the whole thing without having side effect , people could take a signal. Will likely be back to get more. Thanks

I blog quite often and I really appreciate your information.This article has truly peaked my interest. I am going to book mark your blog and keep checking for new information about once a week.I opted in for your RSS feed as well.

Thank you for every other great article. The place else could anybody get that kind of information in such an ideal method of writing? I've a presentation subsequent week, and I am at the search for such info.

Hey there! Quick question that's totally off topic. Do you know how to make your site mobile friendly? My site looks weird when viewing from my apple iphone. I'm trying to find a theme or plugin that might be able to resolve this issue.If you have any suggestions, please share. Thank you!

Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point. You obviously know what youre talking about, why throw away your intelligence on just posting videos to your blog when you could be giving us something informative to read?

A motivating discussion is definitely worth comment. There's no doubt that that you need to publish more about this topic, it may not be a taboo subject but generally people do not speak about these subjects. To the next! Best wishes!!

When I originally left a comment I seem to have clicked the -Notify me when new comments are added- checkbox and from now on whenever a comment is added I get four emails with the same comment. There has to be a means you can remove me from that service?Many thanks!

I'm really enjoying the design and layout of your website. 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 developer to create your theme? Exceptional work!

Its like you read my mind! You appear to know a lot about this, like you wrote the book in it or something. I think that you could do with a few pics to drive the message home a bit, but other than that, this is wonderful blog. A fantastic read. I will certainly be back.

This design is incredible! You obviously know how to keep a reader amused.Between your wit and your videos, I was almost moved to start my own blog (well, almost...HaHa!) Excellent job. I really loved what you had to say, and more than that, how you presented it. Too cool!

I'm amazed, I must say. Rarely do I encounter a blog that's both equally educative and engaging, and let me tell you, you've hit the nail on the head. The issue is something that not enough people are speaking intelligently about. I'm very happy that I came across this in my hunt for something relating to this.

Fantastic beat ! I wish to apprentice while you amend your site, how could i subscribe for a blog web site?The account aided me a acceptable deal. I had been tiny bit acquainted of this your broadcast provided bright clear concept

First off I would like to say wonderful blog! I had a quick question in which I'd like to ask if you do not mind. I was interested to know how you center yourself and clear your mind prior to writing. I have had trouble clearing my mind in getting my thoughts out there. I do take pleasure in writing but it just seems like the first 10 to 15 minutes are usually wasted simply just trying to figure out how to begin. Any suggestions or tips? Appreciate it!

Hey this is kind of of off topic but I was wondering if blogs use WYSIWYG editors or if you have to manually code with HTML. I'm starting a blog soon but have no coding knowledge so I wanted to get guidance from someone with experience. Any help would be enormously appreciated!

Definitely believe that that you stated.Your favourite reason appeared to be at the web the simplest thing to keep in mind of. I say to you, I definitely get annoyed at the same time as other folks think about worries that they plainly don't know about. You controlled to hit the nail upon the top and outlined out the entire thing without having side-effects , other people can take a signal. Will probably be again to get more. Thank you

It's a shame you don't have a donate button! I'd definitely donate to this brilliant blog! I guess for now i'll settle for book-marking and adding your RSS feed to my Google account. I look forward to brand new updates and will share this blog with my Facebook group.Chat soon!

I am really impressed with your writing abilities and also with the layout to your blog. Is this a paid topic or did you modify it your self?Either way stay up the excellent quality writing, it is uncommon to look a nice weblog like this one nowadays..

I tend not to comment, however after looking at a few of the comments here "How to recover from a loss of one redo log member of a multiplexed group".I do have a few questions for you if it's allright. Is it simply me or do some of the responses look like they are left by brain dead visitors? :-P And, if you are writing at additional online sites, I'd like to follow anything new you have to post. Would you list of all of all your social networking pages like your Facebook page, twitter feed, or linkedin profile?

Hey there! Someone in my Facebook group shared this website with us so I came to look it over.I'm definitely enjoying the information. I'm bookmarking and will be tweeting this to my followers! Exceptional blog and amazing style and design.

After I originally commented I appear to have clicked the -Notify me when new comments are added- checkbox and now every time a comment is added I receive four emails with the same comment. Is there an easy method you can remove me from that service? Thanks a lot!

Having read this I believed it was very enlightening.I appreciate you finding the time and effort to put this content together.I once again find myself personally spending a lot of time both reading and leaving comments.But so what, it was still worthwhile!

What's Taking place i'm new to this, I stumbled upon this I've found It absolutely helpful and it has helped me out loads. I'm hoping to give a contribution & aid other customers like its helped me. Great job.

A person essentially lend a hand to make severely posts I would state.This is the very first time I frequented your website page and up to now? I amazed with the research you made to create this particular submit extraordinary.Excellent job!

You can definitely see your expertise within the article you write.The sector hopes for more passionate writers such as you who are not afraid to mention how they believe. At all times follow your heart.

I loved as much as you will receive carried out right here.The sketch is tasteful, your authored material stylish. nonetheless,you command get bought an edginess over that you wish be delivering the following. unwell unquestionably come further formerly again since exactly the same nearly very often inside case you shield this hike.

Hello! I know this is somewhat off topic but I was wondering if you knew where I could get a captcha plugin for my comment form?I'm using the same blog platform as yours and I'm having problems finding one?

Hey there just wanted to give you a quick heads up and let you know a few of the pictures aren't loading properly. I'm not sure why but I think its a linking issue.I've tried it in two different internet browsers and both show the same outcome.

Hi, Neat post. There's an issue together with your website in web explorer, would check this? IE still is the market chief and a good component to folks will pass over your excellent writing due to this problem.

Woah! I'm really digging the template/theme of this website. It's simple, yet effective.A lot of times it's very difficult to get that "perfect balance" between usability and visual appearance. I must say you've done a superb job with this.Also, the blog loads very fast for me on Safari. Excellent Blog!

Do you ever run into any internet browser compatibility problems?A handful of my blog visitors have complained about my website not operating correctly in Explorer but looks great in Opera. Do you have any ideas to help fix this problem?

Hi! I know this is sort of off-topic however I needed to ask. Does building a well-established website such as yours require a large amount of work? I am completely new to writing a blog however I do write in my diary every day. I'd like to start a blog so I will be able to share my own experience and views online. Please let me know if you have any kind of recommendations or tips for new aspiring blog owners. Thankyou!

I was wondering if you ever thought of changing the structure of your website?Its very well written; I love what youve got to say.But maybe you could a little more in the way of content so people could connect with it better. Youve got an awful lot of text for only having 1 or two pictures.Maybe you could space it out better?

Hmm it appears like your blog ate my first comment (it was super long) so I guess I'll just sum it up what I had written and say, I'm thoroughly enjoying your blog.I as well am an aspiring blog writer but I'm still new to the whole thing. Do you have any tips and hints for beginner blog writers? I'd genuinely appreciate it.

An excellent over the counter topical treatment is Abreva, or you can have your doctor prescribe other topical or oral treatments that are creams containing either penciclovir or acyclovir or oral antivirals like famciclovir, valacyclovir or acyclovir.These blisters are filled with a large quantity of fluid and are quite distracting to yourself and those visiting with you.This form of the disease is called community-associated MRSA, CA-MRSA,and it frequently starts with a painful boil on the skin and is spread by skin-to-skin contact8.

Does your site have a contact page? I'm having a tough time locating it but, I'd like to shoot you an email.I've got some suggestions for your blog you might be interested in hearing. Either way, great site and I look forward to seeing it expand over time.

Hey very nice web site!! Man .. Beautiful .. Wonderful .. I will bookmark your website and take the feeds additionally?I'm happy to find so many useful info here in the submit, we need work out more strategies on this regard, thank you for sharing. . . . . .