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

12 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. I am looking for my memories through the stories, the narrative of people. I feel it is difficult but I will try.
    povaup

    ReplyDelete
  4. 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
  5. 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
  6. 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
  7. Apply for dancing jobs, singing jobs, modelling jobs, acting jobs, musicians jobs, writers jobs, bloggers jobs, influencers jobs in India. modeling jobs

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

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

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