Shulou(Shulou.com)06/01 Report--

The case of Oracle Study-- RMAN ORA-19921 error

System environment:

Operating system: AIX5.3

Oracle: Oracle 10gR2

Error phenomenon:

The following error occurred when the database connected through rman:

[11:01:51 oracle@aix217: ~] $rman target /

Recovery Manager: Release 10.2.0.1.0-Production on Mon Jan 19 11:01:53 2015

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to target database: ZSDB (DBID=3945368821)

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

Solution:

Check in OS: [oracle@aix217:~] $ps-ef | grep rmanoracle 20210 15308 0 16:16 pts/2 00:00:00 grep rmanoracle 20237 19585 0 10:27 pts/1 00:00:10 rman target / it turns out that rman is already running. Just kill it. [oracle@node2] $kill-9 20237 problem solved.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.