I have encountered storage crash on one of the Database system. After storage is back online, not able to bring up the database. The database comes to mount stage, but going down.
We are receiving below error.
ORA-03113: end-of-file on communication channel
Process ID: 5038
Session ID: 202 Serial number: 3
When I look into the alert.log I found below error messages
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC2: Becoming the heartbeat ARCH
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Tue Mar 10 10:24:10 2015
Incomplete read from log member '/oracle/ORAC/datafile/ORAC/onlinelog/ORAC_Redo1_.log'. Trying next member.
ARCH: All Archive destinations made inactive due to error 333
ARCH: Closing local archive destination LOG_ARCHIVE_DEST_1: '/oracle/ORAC/archiveORAC_ARCH_347548987.dbf' (error 333) (ORAC)
Committing creation of archivelog '/oracle/ORAC/archive/1_3541_854889367.dbf' (error 333)
Errors in file /oracle/diag/rdbms/orac/ORAC/trace/ORAC_ora_23498.trc:
ORA-16038: log 1 sequence# 3541 cannot be archived
ORA-00333: redo log read error block count
ORA-00312: online log 1 thread 1: '/oracle/ORAC/datafile/ORAC/onlinelog/ORAC_Redo1_.log'
USER (ospid: 23498): terminating the instance due to error 16038
Tue Mar 10 10:24:12 2015
System state dump requested by (instance=1, osid=23498), summary=[abnormal instance termination].
System State dumped to trace file /oracle/diag/rdbms/orac/ORAC/trace/ORAC_diag_23470.trc
Dumping diagnostic data in directory=[cdmp_20150310102412], requested by (instance=1, osid=23498), summary=[abnomal instance termination].
Instance terminated by USER, pid = 23498
By looking the error, I can see that one of the online redo is corrupted. Archive process cannot able to archive to disk. In order to bring up the database you need to clear the corrupted redo log.
From ALERT.LOG file, I am able to identify that group 1 redo log 1 corrupted. By using below command I have cleared the unarchived log file
SQL> alter database clear unarchived logfile ‘/oracle/ORAC/datafile/ORAC/onlinelog/ORAC_Redo1_.log'
If you find all multiplexed redo members are corrupted then you need to run below command to clear the GROUP.
SQL> alter database clear unarchived logfile group 1;
Now I am able to bring up the database. But note that you cannot able to bring the database back beyond corrupted point using old backups. Now you must take one FULL database backup.
Regards
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com
http://www.sqlserver-expert.com
Subscribe to:
Post Comments (Atom)
Great and Useful Article.
ReplyDeleteJava Online Training
Java Course Online
Java EE course
Java Course in Chennai
Java Training in Chennai
Java Training Institutes in Chennai
Java Interview Questions
Java Interview Questions
شركة نقل اثاث بحائل
ReplyDeleteشركة نقل اثاث ببريدة
شركة نقل اثاث بالقصيم
You have performed a great job on this article. It’s very precise and highly qualitative. You have even managed to make it readable and easy to read. You have some real writing talent. Thank you so much. log splitter
ReplyDeleteIt is my first visit to your blog, and I am very impressed with the articles that you serve. Give adequate knowledge for me. Thank you for sharing useful material. I will be back for the more great post. taxi rotterdam centraal
ReplyDeleteI really like your writing style, great information, thankyou for posting. 토토사이트
ReplyDeleteHi there! Nice post! Please tell us when I will see a follow up! 토토사이트
ReplyDeleteNice to be visiting your blog once more, it has been months for me. Well this article that ive been waited for therefore long. i want this article to finish my assignment within the faculty, and it has same topic together with your article. Thanks, nice share. click here
ReplyDeleteYou have done a great job on this article. It’s very readable and highly intelligent. You have even managed to make it understandable and easy to read. You have some real writing talent. Thank you. 토토사이트
ReplyDeleteThis is the type of information I’ve long been trying to find. Thank you for writing this information. 릴게임
ReplyDeleteGreat articles and great layout. Your blog post deserves all of the positive feedback it’s been getting. 안전놀이터
ReplyDeleteGreat post, you have pointed out some fantastic points , I likewise think this s a very wonderful website. 먹튀검증
ReplyDeleteNice post. I was checking constantly this blog and I’m impressed! Extremely useful info 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. buy real youtube views
ReplyDeleteNice post. I was checking constantly this blog and I’m impressed! Extremely useful info 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. pii-email
ReplyDeleteI’ve read some good stuff here. Definitely worth bookmarking for revisiting. I surprise how much effort you put to create such a great informative website. academic transcription services
ReplyDeleteI’ve read some good stuff here. Definitely worth bookmarking for revisiting. I surprise how much effort you put to create such a great informative website. 먹튀검증
ReplyDeleteI’m going to read this. I’ll be sure to come back. thanks for sharing. and also This article gives the light in which we can observe the reality. this is very nice one and gives indepth information. thanks for this nice article... 88카
ReplyDeletei am always looking for some free stuffs over the internet. there are also some companies which gives free samples. Orange County Family Law Lawyer
ReplyDeleteThank you a bunch for sharing this with all of us you actually realize what you are talking about! Bookmarked. Please also seek advice from my site =). We could have a hyperlink change contract between us! joker123
ReplyDeleteIf you are going for finest contents like I do, simply go
ReplyDeleteto see this site every day as it provides quality contents, thanks 우리카지노
(mm)
I like the efforts you have put in this, appreciate it for all the great blog posts. 파워볼게임
ReplyDeleteArticle writing is also a fun, if you know then you can write otherwise it is complex to write.Look at my site 경마
ReplyDeleteThis is such a great resource that you are providing and you give it away for free. 슬롯머신
ReplyDeleteWonderful website. Plenty of helpful information here. 토토
ReplyDeletePretty nice post. I just stumbled upon your weblog and wanted to say that I have really enjoyed browsing your blog posts. After all I’ll be subscribing to your feed and I hope you write again soon! https://www.abercrombieand-fitch.com.co/
ReplyDeleteGreat articles and great layout. Your blog post deserves all of the positive feedback it’s been getting. www.digitalanalog.in
ReplyDeletePost writing is also a fun, if you be familiar with after
ReplyDeletethat you can write or else it is complicated to write.카지노사이트
That is a very good tip especially to those new to the blogosphere.
ReplyDeleteShort but very precise information…카지노사이트핫
We are really grateful for your blog post. You will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work.
ReplyDelete송송넷
When you use a genuine service, you will be able to provide instructions, share materials and choose the formatting style. https://sites.google.com/view/buy-twitch-followers/
ReplyDeleteSomeone necessarily help to make severely articles I might state. That is the first time I frequented your web page and up to now? I surprised with the analysis you made to create this actual publish extraordinary. Fantastic process keonhacai
ReplyDeleteHello, I'm happy to see some great articles on your site. Would you like to come to my site later? My site also has posts, comments and communities similar to yours. Please visit and take a look 토토사이트
ReplyDeleteIt's so nice to know you. I hope you also welcome me.카지노사이트검증If you welcome me, please visit my blog and write. My blog is on It's hard because of Covid - 19, but let's do our best!!
ReplyDeleteI finally found what I was looking for! I'm so happy. 메이저사이트
ReplyDeleteI hope you can help me. I've been thinking about this for a long time, but I'm not getting it resolved.꽁머니
ReplyDeleteI’m thinking some of my readers might find a bit of this interesting. Do you mind if I post a clip from this and link back? Thanks 사설토토
ReplyDeleteI finally found what I was looking for! I'm so happy. 우리카지노
ReplyDeleteThanks for such a fantastic blog. Where else could anyone get that kind of info written in such a perfect way? I have a presentation that I am presently writhing on, and I have been on the look out for such great information. 먹튀검증사이트
ReplyDeleteMany thanks for the article, I have a lot of spray lining knowledge but always learn something new. Keep up the good work and thank you again. 먹튀사이트
ReplyDeleteI'm so happy to finally find a post with what I want. 메이저토토사이트 You have inspired me a lot. If you are satisfied, please visit my website and leave your feedback.
ReplyDeleteAs I am looking at your writing, 파워볼사이트 I regret being unable to do outdoor activities due to Corona 19, and I miss my old daily life. If you also miss the daily life of those days, would you please visit my site once? My site is a site where I post about photos and daily life when I was free.
ReplyDeleteWhat an interesting story! I'm glad I finally found what I was looking for 메리트카지노.
ReplyDeleteIt seems like I've never seen an article of a kind like . It literally means the best thorn. It seems to be a fantastic article. It is the best among articles related to 바카라사이트 . seems very easy, but it's a difficult kind of article, and it's perfect.
ReplyDeleteI was impressed by your writing. Your writing is impressive. I want to write like you.스포츠토토사이트 I hope you can read my post and let me know what to modify. My writing is in I would like you to visit my blog.
ReplyDeleteThanks for your marvelous posting! I really enjoyed reading it, you could be a great author. I will be sure to bookmark your blog and definitely will come back in the foreseeable future. I want to encourage you to continue your great posts, have a nice afternoon! Digital Marketing Course in Bangalore with Placement
ReplyDeleteWhat a nice post! I'm so happy to read this. 안전놀이터모음 What you wrote was very helpful to me. Thank you. Actually, I run a site similar to you. If you have time, could you visit my site? Please leave your comments after reading what I wrote. If you do so, I will actively reflect your opinion. I think it will be a great help to run my site. Have a good day.
ReplyDeleteI think a lot of articles related to are disappearing someday. That's why it's very hard to find, but I'm very fortunate to read your writing. When you come to my site, I have collected articles related to 크레이지슬롯 .
ReplyDeleteSucceed! It could be one of the most useful blogs we have ever come across on the subject. Excellent info! I’m also an expert in this topic so I can understand your effort very well. Thanks for the huge help. start a credit card processing business
ReplyDeleteIt is my first visit to your blog, and I am very impressed with the articles that you serve. Give adequate knowledge for me. Thank you for sharing useful material. I will be back for the more great post. Blissy pillow case reviews
ReplyDeleteWonderful article. Fascinating to read. I love to read such an excellent article. Thanks! It has made my task more and extra easy. Keep rocking. North American Bancard Agent Program
ReplyDeleteI just seen whatever I just hoped for pretty soon in the least. Reasonably unique. https://www.5g999.co/baccarat
ReplyDeleteI haven’t any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us. North American Bancard Sales Partner
ReplyDeleteYou made some good points there. I did a Google search about the topic and found most people will believe your blog. 메이저사이트
ReplyDeleteThanks for your insight for your fantastic posting. I’m exhilarated I have taken the time to see this. It is not enough; I will visit your site every day. Selling Payment Processing
ReplyDeleteI’ve been surfing online more than 5 hours today, yet I never found any interesting article like yours without a doubt. It’s pretty worth enough for me. Thanks... when to buy cryptocurrency and when to sell
ReplyDeleteThis is a truly good site post. Not too many people would actually, the way you just did. I am really impressed that there is so much information about this subject that have been uncovered and you’ve done your best, with so much class. If wanted to know more about green smoke reviews, than by all means come in and check our stuff. new internet device
ReplyDeleteYou there, this is really good post here. Thanks for taking the time to post such valuable information. Quality content is what always gets the visitors coming. winnerslot
ReplyDeleteHello, I have browsed most of your posts. This post is probably where I got the most useful information for my research. Thanks for posting, maybe we can see more on this. Are you aware of any other websites on this subject. buy cialis 40mg in
ReplyDeleteYour article has piqued a lot of positive interest. I can see why since you have done such a good job of making it interesting. detectives infidelidades
ReplyDeleteI admire this article for the well-researched content and excellent wording. I got so involved in this material that I couldn’t stop reading. I am impressed with your work and skill. Thank you so much. Golden revive plus
ReplyDeleteI have been impressed after read this because of some quality work and informative thoughts. I just want to say thanks for the writer and wish you all the best for coming! Your exuberance is refreshing. golden revive plus reviews
ReplyDeleteCaptivating post. I Have Been contemplating about this issue, so an obligation of appreciation is all together to post. Completely cool post.It 's greatly extraordinarily OK and Useful post.Thanks 사설토토사이트
ReplyDeletePost writing is also a fun, if you be familiar with after
ReplyDeletethat you can write or else it is complicated to write. 사설토토
mtgumc
ReplyDeleteMany thanks for the article, I have a lot of spray lining knowledge but always learn something new. Keep up the good work and thank you again. 먹튀검증업체
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteExtremely decent blog and articles. I am realy extremely glad to visit your blog. Presently I am discovered which I really need. I check your blog regular and attempt to take in something from your blog. Much obliged to you and sitting tight for your new post.메이저사이트모음
ReplyDeleteThis is the perfect webpage for everyone who hopes to understand this topic. You know a whole lot its almost tough to argue with you (not that I personally would want to…HaHa). You definitely put a brand new spin on a topic that's been written about for ages. Excellent stuff, just wonderful! SEO Company In Durgapur
ReplyDeleteRoyalcasino581
ReplyDeletePretty nice post. I just stumbled upon your weblog and wanted to say that I have really enjoyed browsing your blog posts. After all I’ll be subscribing to your feed and I hope you write again soon 먹튀검증업체 I would like to write an article based on your article. When can I ask for a review?!
ReplyDeleteBuying a business does not have to be a complicated endeavor when the proper process and methodology is followed. In this article, we outline eleven specific steps that should be adhered to when buying a business and bank financing is planned to be utilized. 메이저토토사이트추천
ReplyDeleteI'm just looking for knowledge. Thanks. เดิมพันขั้นต่ำ 1 บาท
ReplyDeleteค่ายสล็อตชั้นนำ เกมสล็อตเเตกง่าย ที่สุดของเกมสล็อต ambbets.com มีให้เล่นอย่างจุใจ เกมสล็อตทั้งเก่า เเละใหม่ รวมครบจบในเว็บไซต์เดียว สล็อตเล่นได้ทุกเกม สล็อตลิขสิทธิ์เเท้ 100% สล็อตเล่นได้ทุกระบบ ไม่ต้องโหลด ปั่นสล็อตผ่านเว็บไซต์ได้ทันที ! สล็อตไม่ต้องทำเทิร์น ถอนได้ไม่อั้น ถอนฟรีไม่มีขั้นต่ำ ไม่ต้องเเจ้งยอด ฝากถอนอัตโนมัติ โอนไว ปลอดภัย 100%
ReplyDeleteNice blog. Thanks. เกมขึ้นยาน
ReplyDeletethank you for writing this post. i found it interesting and well written.
ReplyDeleteข่าวบอล
This is my first visit to your web We are a group of volunteers and new activities in the same specialty. Website gave us helpful data to work.
ReplyDeleteบาคาร่า
เว็บบาคาร่า
บาคาร่าเว็บตรง
Thank you for your good content. เกมรูเล็ตออนไลน์
ReplyDeleteWow It is a great contents that I ever seen.วิเคราะห์บอล
ReplyDeletevery good article Can read and understand. Thank you very much. รีวิวProject Power
ReplyDelete
ReplyDeleteI hope you write more articles like this. I'm your biggest fan.
ข่าวบอล
Thanks for ones marvelous posting. ข่าวฟุตบอลล่าสุด
ReplyDeleteI like your article very much. Can you recommend writing articles for me? The Matrix 4 Resurrection thank you very much.
ReplyDeleteเว็บไซต์ MEGAGAME ได้มีการคิดค้น พัฒนาระบบ ทางเข้าสล็อตเมก้า ออโต้ ที่เน้นการเล่นในรูปแบบอัตโนมัติ ที่คุณสามารถทำรายการฝาก-ถอนได้ด้วยตัวเอง ผ่าน MEGASLOT ทางเข้า ที่สามารถ สมัครเมก้าสล็อตออโต้ โดยไม่ผ่านทาง call center
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteThis is good for me, Thank you. ดูหนังThe Unbearable Weight of Massive Talent
ReplyDeleteHello
ReplyDeleteThank you for your good information website
We also introduce our website
https://smcaino.com/
Have a nice day
#에볼루션카지노 #에볼루션게임
I hope you will continue to do so in the future รีวิวNightmare Alley
ReplyDeleteDon’t grow up, it’s a trap. ดูผลบอลสด
ReplyDeletebest web games online สมัครเล่นเกมป๊อกเด้งออนไลน์
ReplyDeleteThanks for the valuable information, it really helped me. Thanks again for sharing with us. รีวิวGhosts of war
ReplyDeleteThanks for the valuable information, it really helped me. Thanks again for sharing with us. หนังThe Platform
ReplyDeleteThanks for sharing this valuable post
ReplyDeleteBuy SMTP Server
SMTP Relay Service
Bellingham is exceptional. วิเคราะห์บอลลีก
ReplyDeletesmtp server for email marketing and smtp service providers
ReplyDelete