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

74 comments:

  1. 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
  2. I really like your writing style, great information, thankyou for posting. 토토사이트

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

    ReplyDelete
  4. 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
  5. 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
  6. This is the type of information I’ve long been trying to find. Thank you for writing this information. 릴게임

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

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

    ReplyDelete
  9. 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
  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. pii-email

    ReplyDelete
  11. 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
  12. 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
  13. 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
  14. 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
  15. I like the efforts you have put in this, appreciate it for all the great blog posts. 파워볼게임

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

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

    ReplyDelete
  18. 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
  19. Great articles and great layout. Your blog post deserves all of the positive feedback it’s been getting. www.digitalanalog.in

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

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

    ReplyDelete
  22. 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
  23. 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
  24. I finally found what I was looking for! I'm so happy. 메이저사이트


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


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


    ReplyDelete
  27. 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
  28. 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
  29. 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
  30. I just seen whatever I just hoped for pretty soon in the least. Reasonably unique. https://www.5g999.co/baccarat

    ReplyDelete
  31. 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
  32. 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
  33. 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
  34. 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
  35. 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
  36. 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
  37. 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
  38. 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
  39. 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
  40. 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
  41. This comment has been removed by the author.

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

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

    ReplyDelete

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

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

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

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

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

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

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

    ReplyDelete
  51. If you looking for good article, this one is your answer ผลบอลสด

    ReplyDelete
  52. Like this website, there are articles that we need almost everything. เว็บผลบอล ข่าวฟุตบอล

    ReplyDelete
  53. ผลบอลสด A lot of blog writers nowadays yet just a few have blog posts worth spending time on reviewing.

    ReplyDelete
  54. I like your article very much. Can you recommend writing articles for me? หนัง netflix แนะนํา 2021 เกาหลี

    ReplyDelete
  55. La conducción imprudente en el Condado de Carroll me.ข่าวไอที

    ReplyDelete
  56. thanks a lot for the good language confidently mastering those numbers and.
    สุขภาพ

    ReplyDelete
  57. codermails offer low cost smtp solution here is you can get <a href="https://codermails.in/pricing.html>smtp server for bulk mail</a>

    ReplyDelete