Monday, January 9, 2012

RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row

One of my RMAN backup generated below Warnings, here is the detailed description and solution. I hope it helps other users.

Error:

RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row
RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows
ORACLE error from target database:
ORA-00604: error occurred at recursive SQL level 3
ORA-04031: unable to allocate 4120 bytes of shared memory ("shared pool","select name,password,datats#...","Typecheck","kgghteInit")
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_BACKUP_RESTORE"

Cause & Solution:

The RMAN not able to update V$RMAN_STATUS or V$RMAN_OUTPUT due to associated error message. When you receive RMAN-06900 and RMAN-06901error, you need to look for associated error messages to find the root cause of the error message.

In this case, ORA-04031 is the associated error message

ORA-04031: unable to allocate 4120 bytes of shared memory
*Cause: More shared memory is needed than was allocated in the shared pool.
*Action: If the shared pool is out of memory, either use the dbms_shared_pool package to pin large packages, reduce your use of shared memory, or increase the amount of available shared memory by increasing the value of the INIT.ORA parameters "shared_pool_reserved_size" and “shared_pool_size". If the large pool is out of memory, increase the INIT.ORA parameter "large_pool_size".

I have seen many users complaining about error ORA-19921. If you receive this error close some of existing connections or unused RMAN connections.

If your oracle version > 10.2.0.4 then you might be hitting below bugs. These bugs fixed in 10.2.0.4 and higher versions.

ORA-19921: maximum number of 64 rows exceeded - oracle Bug 465973.
ORA-19921: maximum number of 128 rows exceeded - oracle Bug 8264365

Regards,
Satishbabu Gunukula
http://www.oracleracexpert.com

24 comments:

  1. I would think most of DBAs now are using spfile as opposed to init.ora! I see you refering to init.ora file..the old way?

    ReplyDelete
    Replies
    1. Please note that ora-04031 is a standard error, which still have INIT.ORA parameter info. You may get this error when you are using init.ora or spfile for your database.

      I am just referring the parameter file.

      Hope this helps,

      Regards,
      Satishbabu Gunukula

      Delete
  2. This comment has been removed by a blog administrator.

    ReplyDelete
  3. Congratulations! this blog is very interesting and has information most important we invite you to visit our blog
    fireboy and watergirl 4
    Geometry Dash 2.0

    ReplyDelete
  4. The blog or and best that is extremely useful to keep I can share the ideas. Age Of War 2
    Big Farm | Slitherio | Tank Trouble
    Of the future as this is really what I was looking for, I am very comfortable and pleased to come here. Thank you very much.
    Happy Wheels | Goodgeme Empire | Slither.io

    ReplyDelete
  5. Thanks for sharing such a nice article. It is really useful to me and all people. One think in my mind came while reading that it is not wasting of time.
    happy wheels
    return man 3
    friv4school

    ReplyDelete
  6. Your blog posts are more interesting and impressive. I think there are many people like and visit it regularly, including me.I actually appreciate your own position and I will be sure to come back here.
    hotmail login l login hotmai l hotmail log in l hotmail sign in l hotmail sign up

    ReplyDelete
  7. This blog is so nice to me. I will continue to come here again and again. Visit my link as well. Good luck
    cara menggugurkan kandungan

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

    ReplyDelete
  9. I am looking for my memories through the stories, the narrative of people. I feel it is difficult but I will try.
    povaup

    ReplyDelete
  10. I like the post format as you create user engagement in the complete article. It seems round up of all published posts. Thanks for gauging the informative posts.
    cara menggugurkan kandungan

    ReplyDelete
  11. Thanks for the best blog.it was very useful for me.keep sharing such ideas in the future as well. Thanks for giving me the useful information. I think I need it!

    www.happywheelsy8.com

    ReplyDelete
  12. This is also a very good post which I really enjoyed reading. It is not everyday that I have the possibility to see something
    www.baixar-whatsapp.com.br

    ReplyDelete
  13. Information from this blog is very useful for me, am very happy to read this blog Kindly visit us @ Christmas Gift boxes | Wallet Box

    ReplyDelete
  14. Choose the best fitness band under 5000 to get your fitness track on routine. Choose from wide range of variety. best fitness band in india under 5000

    ReplyDelete
  15. Apply for dancing jobs, singing jobs, modelling jobs, acting jobs, musicians jobs, writers jobs, bloggers jobs, influencers jobs in India. modeling jobs

    ReplyDelete
  16. Overwhelm your parents this Christmas with the amazing unique gifts from the best unique gifts. Get variety of options. gifts for grandpa

    ReplyDelete
  17. Grab some latest and amazing Indian news here. All the viral, trending and upcoming news without any delay. trending topics in india

    ReplyDelete
  18. Get your hand on the Best motivational, inspirational, success, attitude, love, good morning, life, funny, sad, and other thoughts in Hindi. hindi motivational quotes

    ReplyDelete
  19. Die Technologie entwickelt sich schneller denn je und schneller als Sie denken. Diese aufkommende Technologie wird unsere Lebensweise verändern

    ReplyDelete