RMAN-06900，RMAN-06901,ORA-19921：maximum number 错误问题

1、连接到rman中

 

$ rman target/

 

Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 21 10:27:39 2011

 

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

 

connected to target database: oms (DBID=1062573604)

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 row

s

ORACLE error from target database:

ORA-19921: maximum number of 128 rows exceeded

 

2、退出rman，查看进程

RMAN> exit

 

 

Recovery Manager complete.

$ ps -ef|grep rman

  oracle 1773872 2490860   0 10:27:55  pts/2  0:00 grep rman

  oracle 2961704       1  82 20:56:00      - 360:13 rman target/

 

3、原来还有rman的进程在运程，kill进程

$ kill 2961704

 

4、重新进入

$ rman target/

 

Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 21 10:28:18 2011

 

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

 

connected to target database: oms (DBID=1062573604)

 

RMAN>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12778571/viewspace-700360/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12778571/viewspace-700360/