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

9 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. 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!
    Happy Wheels , FNAF World , Five Nights At Freddy's

    ReplyDelete
  3. This comment has been removed by a blog administrator.

    ReplyDelete
  4. 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
  5. 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
  6. 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