Wednesday, April 29, 2020

ORA-19815: WARNING: db_recovery_file_dest_size of 128849010 bytes is 99.03% used, and has 14136528 remaining bytes available.

You will receive ORA-19815 is reaching maximum size of flash backup recovery area (FRA) and note that this limitation will be managed by db_recovery_file_dest_size parameter

If you got this error as one time then you might be running adhoc load or some batch job. Also you will get below message in alert.log file. Please follow one of the choice to fix the issue.

ORA-19815: WARNING: db_recovery_file_dest_size of 128849010 bytes is 99.03% used, and has 14136528 remaining bytes available.
2020-02-21T11:31:19.892420-07:00

************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.

In case if you archive logs are going to FRA then you should run RMAN backups and delete the unnecessary files to avoid Database hung or CRASH situation.

RMAN> backup archivelog all delete input;

If the Flash recovery area is 100% then you might receive below error when starting up the database

Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 9789
Session ID: 321 Serial number: 3


Pls make sure you follow below steps to add more space to flash recovery area (FRA)

SQL> startup mount;
SQL> alter system set db_recovery_file_dest_size=<size>G scope=both;
Replace <size> with a number larger than the current and ensure is sufficient space in the destination
SQL> alter database open;


To see what FRA has run below command

SQL> select * from v$flash_recovery_area_usage;
FILE_TYPE            PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES     CON_ID
-------------------- ------------------ ------------------------- --------------- ----------
CONTROL FILE                          0                         0               0          0
REDO LOG                              0                         0               0          0
ARCHIVED LOG                          0                         0               0          0
BACKUP PIECE                          0                         0               0          0
IMAGE COPY                            0                         0               0          0
FLASHBACK LOG                     99.76                         0             192          0
FOREIGN ARCHIVED LOG                  0                         0               0          0
AUXILIARY DATAFILE C                  0                         0               0          0

In my case I am using for FLASHBACK LOG, these logs are different from redo logs or undo. They are a separate, optional recording of database activity.

These logs are automatically deleted when FRA is our of space and logs is not needed for recvoery within the window specified in DB_FLASHBACK_RETENTION_TARGET parameter

To determine the disk quota and current disk usage in the flash recovery area, query the view
V$RECOVERY_FILE_DEST.

Thanks & Regards,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

49 comments:

  1. Get Packers and Movers Jaipur List of Top Reliable, 100% Affordable, Verified and Secured Service Provider. Get Free ###Packers and Movers Jaipur Price Quotation instantly and Save Cost and Time. Packers and Movers Jaipur ✔ ✔ ✔ Reviews and Compare Charges for household Shifting, Home/Office Relocation, ***Car Transportation, Pet Relocation, Bike SHifting @ Packers And Movers Jaipur

    ReplyDelete
  2. Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!
    Sattamatka

    ReplyDelete
  3. Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!
    Sattamatka

    ReplyDelete
  4. Hello there, simply was aware of your blog through Google, and located that it’s really informative. win915

    ReplyDelete
  5. Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work! Bandar Slot

    ReplyDelete
  6. Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work! Bandar Slot

    ReplyDelete
  7. Products seems to be original. I can feel the originality form photos. Lsm99

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

    ReplyDelete
  9. Products seems to be original. I can feel the originality form photos. Lsm99

    ReplyDelete
  10. first-rate knowledge, restructure everybody mind merely reference assign assist to to it Situs IDN Poker

    ReplyDelete
  11. first-rate knowledge, restructure everybody mind merely reference assign assist to to it Situs IDN Poker

    ReplyDelete
  12. Products seems to be original. I can feel the originality form photos. design merchandise

    ReplyDelete
  13. Products seems to be original. I can feel the originality form photos. design merchandise

    ReplyDelete
  14. This will open a window containing the HTML source code of the page. Inspect an HTML Element: Right-click on an element basic HTML CODE

    ReplyDelete
  15. This will open a window containing the HTML source code of the page. Inspect an HTML Element: Right-click on an element basic HTML CODE

    ReplyDelete
  16. Products seems to be original. I can feel the originality form photos. 토토

    ReplyDelete
  17. Products seems to be original. I can feel the originality form photos. 토토

    ReplyDelete
  18. اقوى الخدمات الخاصة بأعمال نقل العفش مع الفك والتركيب في الرياض يقدمها موقع خدماتي الذي يضم افضل شركة نقل عفش بالرياض التي تقدم خدماتها بمنتهى الاحترافية والدقة معتمدين على فريق عمل مدرب جيدا ونجارين متخصصين لتقديم خدمات شركات نقل الاثاث بالرياض باحترافية عالية وجودة غير مسبوقة

    ReplyDelete
  19. exciting publicize. i have Been questioning more or less this count number, as a end result thanks for posting. pretty cold publication.It 's in fact very fine and useful say.thank you 먹튀검증 안전놀이터 스포츠중계 꽁머니 먹튀검증 토토사이트 안전놀이터 꽁머니

    ReplyDelete
  20. exciting publicize. i have Been questioning more or less this count number, as a end result thanks for posting. pretty cold publication.It 's in fact very fine and useful say.thank you 먹튀검증 안전놀이터 스포츠중계 꽁머니 먹튀검증 토토사이트 안전놀이터 꽁머니

    ReplyDelete
  21. Hello there, simply was aware of your blog through Google, and located that it’s really informative. Click Here
    Click Here
    Click Here

    ReplyDelete
  22. Hello there, simply was aware of your blog through Google, and located that it’s really informative. Click Here
    Click Here
    Click Here

    ReplyDelete
  23. I like this post,And I figure that they having a great time to peruse this post,they might take a decent site to make an information,thanks for sharing it to me ผลบอล

    ReplyDelete
  24. Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I’ll be subscribing to your feed and I hope you post again soon. Big thanks for the useful info. ผลบอล

    ReplyDelete
  25. FDA Advisory Committee Against Pfizer Vaccine Emergency Approval The reason is that?

    "If the vaccination criteria had been over 18, I wouldn't have objected."

    On the 11th (local time) , Dr. Achana Chatterge, a member of the Vaccine and Biological Drug Advisory Committee, an expert advisory body of the US Food and Drug Administration ( FDA ), explained the reason why he opposed the approval of the emergency use of Pfizer vaccine.

    The day before, the advisory committee held a meeting and advised the FDA to "approve the emergency use of the COVID- 19 vaccine jointly developed by Pfizer and German Bioentech for US citizens over the age of 16. " The advisory committee's recommendation is a necessary process for FDA to actually approve. As a result of the meeting over 8 hours, 17 people agreed, 1 abstained, and 4 opposed. Dr. Chatterge, an infectious disease expert and dean of the Chicago Medical School, is one of four who objected. He said in an interview with CNBC that day , " I totally agree with the Pfizer vaccine for adults over the age of 18 , " he said. "But I don't think the approval criteria should be included until the age of 16 or 17. " 18 우리카지 https://www.topseom.com/topseom

    ReplyDelete
  26. Those who were numbered by the tribe of Asher were forty and one thousand and five hundred.
    All those born of the sons of Naphtali , according to their families and tribes, who were twenty years old or older and who could go into battle, were numbered according to their name.
    < a href="https://reel114.com/" target="_blank">릴게임

    ReplyDelete
  27. Packers and Movers Bangalore - Reliable and Verified Household Shifting Service Providers Give Reasonable ###Packers and Movers Charges. Cheap and Best Office Relocation Compare Quotation for Assurance for Local and Domestic House Shifting and Get estimates today to save upto 20%, ***Read Customer Reviews - @ Packers And Movers Bangalore

    ReplyDelete
  28. Thank you so much for providing good quality information. 먹튀검증업체 I think it would not have been easy to collect this information and organize it in an easy to understand way. I'll add it to my bookmarks so I can visit it often! And I will share it with my acquaintances. And there is a lot of useful information on our website too, so please take a look and take a look. Then have a good day. 먹튀검증

    ReplyDelete
  29. I seriously love your website.. Excellent colors & theme.
    Did you create this amazing site yourself? Please reply back as I’m attempting to create my own site
    and want to know where you got this from or just what the theme is named.
    Cheers!서양야동

    ReplyDelete
  30. First of all, thank you for your post. 먹튀검증 Your posts are neatly organized with the information I want, so there are plenty of resources to reference. I bookmark this site and will find your posts frequently in the future. Thanks again ^^

    ReplyDelete
  31. Greetings! Very helpful advice in this particular article! It’s the little changes which will make the largest changes. Thanks for sharing 먹튀검증

    ReplyDelete
  32. When I read an article on this topic, 먹튀검증커뮤니티 the first thought was profound and difficult, and I wondered if others could understand.. My site has a discussion board for articles and photos similar to this topic. Could you please visit me when you have time to discuss this topic?

    ReplyDelete
  33. 훌륭한 기사입니다. 읽기에 매우 흥미롭다. 나는 그런 좋은 기사를 읽는 것을 정말 좋아한다. 고마워요! 계속 흔들어요.사설토토사이트

    ReplyDelete
  34. Regardless of the subject, we are ready to deliver high-quality custom writing orders to consumers upon their first write my essay for me request. cheap dishwashers under 200

    ReplyDelete
  35. I have just found this website while searching over the internet, you have posted valuable information which i like reading Slotxo

    ReplyDelete
  36. I know this web site offers quality depending articles or reviews and other information,
    is there any other site which offers such data in quality?

    my web-site: 오피

    ReplyDelete
  37. I have just found this website while searching over the internet, you have posted valuable information which i like reading먹튀검증업체

    ReplyDelete
  38. CASINO EN DIRECT - TOPSEOM
    LIVE MAXIM MAXIM MAXIM MAXIM a été atteint
    Baccarat vivant, noir, orge, nouvelle expérience.

    LIVE카지노

    온라인바카라

    우리카지노

    바카라사이트

    카지노사이트

    ReplyDelete
  39. Will really appreciate the writer's choice for choosing this excellent article appropriate to my matter.Here is deep description about the article matter which helped me more 오피

    ReplyDelete
  40. Adapted to new systems and processes well and seeks out training to enhance knowledge, skills and abilities.
    야한소설

    ReplyDelete
  41. Not that I am complaining, but slow loading instances times will sometimes affect your placement in google and could damage your high-quality score if advertising and marketing with Adwords. Well I am adding this RSS to my e-mail and can look out for a lot more of your respective fascinating content. 대딸방

    ReplyDelete
  42. I want to to thank you for this great read!! I certainly enjoyed every little bit of it. I have you bookmarked to check out new stuff you post… 스포츠마사지

    ReplyDelete
  43. You are my inhalation, I have few web logs and very sporadically run out from to post 출장마사지 .

    ReplyDelete
  44. Your content is nothing short of brilliant in many ways. I think this is engaging and eye-opening material. Thank you so much for caring about your content and your readers. click here

    ReplyDelete
  45. From some point on, I am preparing to build my site while browsing various sites. It is now somewhat completed. If you are interested, please come to play with keonhacai !

    ReplyDelete
  46. Great post I would like to thank you for the efforts you have made in writing this interesting and knowledgeable article. click here

    ReplyDelete