In this post I will show you an error received during an oracle database restore:
RMAN> connect target *
connected to target database: P34 (DBID=490508274, not open)
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-19921: maximum number of 128 rows exceeded
connected to target database: P34 (DBID=490508274, not open)
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-19921: maximum number of 128 rows exceeded
Solution:
Check out ps command to see any other rman command connected and if not required kill it.
$ ps -aef|grep rman
orap34 2093242 2506988 0 13:49:25 pts/3 0:10 rman target /
orap34 2904212 2613458 0 14:07:43 pts/4 0:00 grep rman
$ kill -9 2093242
Leave a comment