Oracle Study case--rman ORA-19921 error

Oracle Study case--rman ORA-19921 error

System environment:

Operating system: AIX5.3

Oracle:oracle 10GR2

Error phenomena:

The following error occurred when the database was connected via Rman:

[11:01:51 [email protected]: ~] $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 rows exceeded

Workaround:

Check under OS status: [[email protected]:~]$ 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 tar Get/Original is Rman already running. Just kill it right away. [[email protected] ~]$ kill-9 20237 problem solved.

This article is from the "Tianya blog," Please make sure to keep this source http://tiany.blog.51cto.com/513694/1605831

Oracle Study case--rman ORA-19921 error