RMAN-06900 RMAN-06901 ORA-19921

今天使用rman时,碰到1个小故障,报错如下:

$ rman target / nocatalog

Recovery Manager: Release 10.2.0.5.0 - Production on Wed Aug 23 10:38:29 2017

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

connected to target database: QUERY (DBID=2814110869)
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

using target database control file instead of recovery catalog

故障原因是因为系统中有多个rman进程

$ ps -ef | grep rman
  oracle 15546 15360 254 20:00:04 ?        873:16 rman target / nocatalog
  oracle  8793  8611 255  Aug 18  ?        5668:35 rman target / nocatalog
  oracle 29303 29168 252  Aug 21  ?        2310:37 rman target / nocatalog
  oracle 12763 12576 253  Aug 20  ?        3745:04 rman target / nocatalog
  oracle 12943 12775  0 10:39:42 pts/te    0:00 grep rman
  oracle 25752 25568 255  Aug 19  ?        5182:46 rman target / nocatalog

杀掉这些挂起的进程后,rman就可以正常使用了

关于紫砂壶

感悟技术人生
此条目发表在ORA-分类目录,贴了标签。将固定链接加入收藏夹。