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
Subscribe to:
Post Comments (Atom)
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?
ReplyDeletePlease 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.
DeleteI am just referring the parameter file.
Hope this helps,
Regards,
Satishbabu Gunukula
I got good ideas from this amazing blog.
ReplyDeletehappy wheels | friv | girlsgogames | games2girls | happy wheels
This comment has been removed by a blog administrator.
ReplyDeleteCongratulations! this blog is very interesting and has information most important we invite you to visit our blog
ReplyDeletefireboy and watergirl 4
Geometry Dash 2.0
The blog or and best that is extremely useful to keep I can share the ideas. Age Of War 2
ReplyDeleteBig 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
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.
ReplyDeletehappy wheels
return man 3
friv4school
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.
ReplyDeletehotmail login l login hotmai l hotmail log in l hotmail sign in l hotmail sign up
This blog is so nice to me. I will continue to come here again and again. Visit my link as well. Good luck
ReplyDeletecara menggugurkan kandungan
شركة تنظيف خزانات بجدة الجوهرة من افضل شركات تنظيف الخزانات بجدة حيث ان تنظيف خزانات بجدة يحتاج الى مهارة فى كيفية غسيل وتنظيف الخزانات الكبيرة والصغيرة بجدة على ايدى متخصصين فى تنظيف الخزانات بجدة
ReplyDeleteشركة تنظيف خزانات بجدة
شركة كشف تسربات المياه بالدمام
شركة نقل عفش واثاث
I am looking for my memories through the stories, the narrative of people. I feel it is difficult but I will try.
ReplyDeletepovaup
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.
ReplyDeletecara menggugurkan kandungan
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!
ReplyDeletewww.happywheelsy8.com
This is also a very good post which I really enjoyed reading. It is not everyday that I have the possibility to see something
ReplyDeletewww.baixar-whatsapp.com.br
Information from this blog is very useful for me, am very happy to read this blog Kindly visit us @ Christmas Gift boxes | Wallet Box
ReplyDeletenow present in your city cara menggugurkan hamil
ReplyDelete1. manfaat kurma untuk persalinan
2. manfaat buah nanas
3. aktivitas penyebab keguguran
4. apakah usg berbahaya
5. penyebab telat haid
I thank you for the information and articles you provided cara menggugurkan kandungan dan mempercepat haid
ReplyDeleteChoose 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
ReplyDeleteApply for dancing jobs, singing jobs, modelling jobs, acting jobs, musicians jobs, writers jobs, bloggers jobs, influencers jobs in India. modeling jobs
ReplyDeleteOverwhelm your parents this Christmas with the amazing unique gifts from the best unique gifts. Get variety of options. gifts for grandpa
ReplyDeleteGrab some latest and amazing Indian news here. All the viral, trending and upcoming news without any delay. trending topics in india
ReplyDeleteGet your hand on the Best motivational, inspirational, success, attitude, love, good morning, life, funny, sad, and other thoughts in Hindi. hindi motivational quotes
ReplyDeletenike lebron 16
ReplyDeletepg 1
jordan 11
yeezy boost 350
moncler jacket
yeezy 350
yeezy
off white hoodie
giannis antetokounmpo shoes
supreme clothing
Die Technologie entwickelt sich schneller denn je und schneller als Sie denken. Diese aufkommende Technologie wird unsere Lebensweise verändern
ReplyDelete