RMAN error maximum number of 128 rows exceeded
Has anybody seen this before? if so, how can it be fixed.
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
ORACLE error from target database:
ORA-19921: maximum number of 128 rows exceeded
SQL> select count(*) from V$RMAN_STATUS;
SQL> select count(*) from V$RMAN_OUTPUT;
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.
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.
May want to check Bug 8264365.
Click Here to Expand Forum to Full Width