Thursday, May 7, 2015

ORA-16038: log 1 sequence# 3541 cannot be archived

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

93 comments:

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

    ReplyDelete
  2. It 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

    ReplyDelete
  3. I really like your writing style, great information, thankyou for posting. 토토사이트

    ReplyDelete
  4. Hi there! Nice post! Please tell us when I will see a follow up! 토토사이트

    ReplyDelete
  5. Nice 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

    ReplyDelete
  6. You 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. 토토사이트

    ReplyDelete
  7. This is the type of information I’ve long been trying to find. Thank you for writing this information. 릴게임

    ReplyDelete
  8. Great articles and great layout. Your blog post deserves all of the positive feedback it’s been getting. 안전놀이터

    ReplyDelete
  9. Great post, you have pointed out some fantastic points , I likewise think this s a very wonderful website. 먹튀검증

    ReplyDelete
  10. Nice 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

    ReplyDelete
  11. Nice 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

    ReplyDelete
  12. I’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

    ReplyDelete
  13. I’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. 먹튀검증

    ReplyDelete
  14. I’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카

    ReplyDelete
  15. i am always looking for some free stuffs over the internet. there are also some companies which gives free samples. Orange County Family Law Lawyer

    ReplyDelete
  16. Thank 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

    ReplyDelete
  17. If you are going for finest contents like I do, simply go
    to see this site every day as it provides quality contents, thanks 우리카지노
    (mm)

    ReplyDelete
  18. I like the efforts you have put in this, appreciate it for all the great blog posts. 파워볼게임

    ReplyDelete
  19. Article writing is also a fun, if you know then you can write otherwise it is complex to write.Look at my site 경마

    ReplyDelete
  20. This is such a great resource that you are providing and you give it away for free. 슬롯머신

    ReplyDelete
  21. Wonderful website. Plenty of helpful information here. 토토

    ReplyDelete
  22. Pretty 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/

    ReplyDelete
  23. Great articles and great layout. Your blog post deserves all of the positive feedback it’s been getting. www.digitalanalog.in

    ReplyDelete
  24. Post writing is also a fun, if you be familiar with after
    that you can write or else it is complicated to write.카지노사이트

    ReplyDelete
  25. That is a very good tip especially to those new to the blogosphere.
    Short but very precise information…카지노사이트핫

    ReplyDelete
  26. 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
  27. 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/

    ReplyDelete
  28. Someone 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

    ReplyDelete
  29. Hello, 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 토토사이트

    ReplyDelete
  30. It'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!!


    ReplyDelete
  31. I finally found what I was looking for! I'm so happy. 메이저사이트


    ReplyDelete
  32. I hope you can help me. I've been thinking about this for a long time, but I'm not getting it resolved.꽁머니


    ReplyDelete
  33. I’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 사설토토

    ReplyDelete
  34. I finally found what I was looking for! I'm so happy. 우리카지노


    ReplyDelete
  35. Thanks 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. 먹튀검증사이트

    ReplyDelete
  36. Many 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. 먹튀사이트

    ReplyDelete
  37. I'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.

    ReplyDelete
  38. As 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.

    ReplyDelete
  39. What an interesting story! I'm glad I finally found what I was looking for 메리트카지노.

    ReplyDelete
  40. It 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.

    ReplyDelete
  41. I 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.

    ReplyDelete
  42. Thanks 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

    ReplyDelete
  43. What 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.

    ReplyDelete
  44. I 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 크레이지슬롯 .

    ReplyDelete
  45. Succeed! 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

    ReplyDelete
  46. It 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

    ReplyDelete
  47. Wonderful 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

    ReplyDelete
  48. I just seen whatever I just hoped for pretty soon in the least. Reasonably unique. https://www.5g999.co/baccarat

    ReplyDelete
  49. I 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

    ReplyDelete
  50. You made some good points there. I did a Google search about the topic and found most people will believe your blog. 메이저사이트

    ReplyDelete
  51. Thanks 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

    ReplyDelete
  52. I’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

    ReplyDelete
  53. This 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

    ReplyDelete
  54. You 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

    ReplyDelete
  55. Hello, 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

    ReplyDelete
  56. Your 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

    ReplyDelete
  57. I 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

    ReplyDelete
  58. I 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

    ReplyDelete
  59. Captivating 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 사설토토사이트

    ReplyDelete
  60. Post writing is also a fun, if you be familiar with after
    that you can write or else it is complicated to write. 사설토토

    ReplyDelete
  61. Many 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. 먹튀검증업체

    ReplyDelete
  62. This comment has been removed by the author.

    ReplyDelete
  63. Extremely 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.메이저사이트모음

    ReplyDelete
  64. This 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

    ReplyDelete
  65. Pretty 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?!

    ReplyDelete
  66. Buying 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. 메이저토토사이트추천

    ReplyDelete
  67. ค่ายสล็อตชั้นนำ เกมสล็อตเเตกง่าย ที่สุดของเกมสล็อต ambbets.com มีให้เล่นอย่างจุใจ เกมสล็อตทั้งเก่า เเละใหม่ รวมครบจบในเว็บไซต์เดียว สล็อตเล่นได้ทุกเกม สล็อตลิขสิทธิ์เเท้ 100% สล็อตเล่นได้ทุกระบบ ไม่ต้องโหลด ปั่นสล็อตผ่านเว็บไซต์ได้ทันที ! สล็อตไม่ต้องทำเทิร์น ถอนได้ไม่อั้น ถอนฟรีไม่มีขั้นต่ำ ไม่ต้องเเจ้งยอด ฝากถอนอัตโนมัติ โอนไว ปลอดภัย 100%

    ReplyDelete
  68. thank you for writing this post. i found it interesting and well written.
    ข่าวบอล

    ReplyDelete
  69. 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
  70. very good article Can read and understand. Thank you very much. รีวิวProject Power

    ReplyDelete

  71. I hope you write more articles like this. I'm your biggest fan.
    ข่าวบอล

    ReplyDelete
  72. I like your article very much. Can you recommend writing articles for me? The Matrix 4 Resurrection thank you very much.

    ReplyDelete
  73. เว็บไซต์ MEGAGAME ได้มีการคิดค้น พัฒนาระบบ ทางเข้าสล็อตเมก้า ออโต้ ที่เน้นการเล่นในรูปแบบอัตโนมัติ ที่คุณสามารถทำรายการฝาก-ถอนได้ด้วยตัวเอง ผ่าน MEGASLOT ทางเข้า ที่สามารถ สมัครเมก้าสล็อตออโต้ โดยไม่ผ่านทาง call center

    ReplyDelete
  74. This comment has been removed by the author.

    ReplyDelete
  75. Hello
    Thank you for your good information website
    We also introduce our website
    https://smcaino.com/
    Have a nice day

    #에볼루션카지노 #에볼루션게임

    ReplyDelete
  76. Thanks for the valuable information, it really helped me. Thanks again for sharing with us. รีวิวGhosts of war

    ReplyDelete
  77. Thanks for the valuable information, it really helped me. Thanks again for sharing with us. หนังThe Platform

    ReplyDelete