Oracle Study之案例--RMAN ORA-19921错误
系统环境:
操作系统: AIX5.3
Oracle: Oracle 10gR2
错误现象:
数据库在通过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
解决方法:
在OS状态下查下: [oracle@aix217:~]$ ps -ef | grep rman oracle 20210 15308 0 16:16 pts/2 00:00:00 grep rman oracle 20237 19585 0 10:27 pts/1 00:00:10 rman target / 原来是rman已经在运行。 直接杀掉。 [oracle@node2 ~]$ kill -9 20237 问题解决。
转载于:https://blog.51cto.com/tiany/1605831