Question: I am getting the
RMAN ORA-19921 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-19921: maximum
number of 64 rows exceeded
How to I correct this ORA-19921 error?Answer:
This ORA-19921 error could be due to
bug 8264365, Also see
MOSC Note 943571.1. The oerr utility says this on the ORA-19921 error
ORA-19921:
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.
You cam run this query to count the open number of RMAN
sessions. The other RMAN scripts show other details on
currently-running RMAN sessions:
select
count(*)
from
v$rman_output;
COUNT(*)
----------
19665
--
********************************************
select
session_key,
input_type,
status,
to_char(start_time,'dd/mm/yy hh24:mi') start_time,
to_char(end_time,'dd/mm/yy
hh24:mi') end_time,
round((end_time-start_time)*1440,2)
"minutes"
from
v$rman_backup_job_details
where
input_type='DB INCR'
order by
session_key desc;
--
***********************************************
