DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: RMAN error maximum number of 128 rows exceeded

  1. #1
    Join Date
    Feb 2009
    Posts
    91

    RMAN error maximum number of 128 rows exceeded

    Has anybody seen this before? if so, how can it be fixed.


    RMAN>
    connected to target database: OTATEST (DBID=3130218754)
    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 row
    s
    ORACLE error from target database:
    ORA-19921: maximum number of 128 rows exceeded


    SQL> select count(*) from V$RMAN_STATUS;

    COUNT(*)
    ----------
    560

    SQL> select count(*) from V$RMAN_OUTPUT;

    COUNT(*)
    ----------
    32834

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Code:
    oerr ora 19921
    19921, 00000, "maximum number of %s rows exceeded"
    // *Cause:  The maximum number of rows in the V$RMAN_STATUS or V$RMAN_OUTPUT
    //          table has been exceeded.
    // *Action: Close some of existing and unused RMAN connections and sessions.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Feb 2009
    Posts
    91
    I read the error description.

    In my case there is only one full backup at a time running, hence it does not make any sense. That is why I posted the question.

  4. #4
    Join Date
    Apr 2006
    Posts
    377
    May want to check Bug 8264365.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width