[oracle@oel6 ~]$ rman target / Recovery Manager: Release 11.2.0.1.0 - Production on Tue Feb 10 15:06:05 2015 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: TESTDB (DBID=2647984357) 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 RMAN>
This is due too many RMAN connections, if there is not going RMAN backup then we can simple kill that processes.
select 'kill -9 ' || b.SPID, a.USERNAME, a.MACHINE, a.LAST_CALL_ET, a.MODULE, a.SID, a.PROCESS, a.EVENT, a.ACTION, a.osuser from v$session a, v$process b where a.PADDR = b.ADDR and module like '%rman%' order by MODULE;
result:
then just kill that processes from operating system
[oracle@oel6 ~]$ kill -9 23285 [oracle@oel6 ~]$ kill -9 23283 [oracle@oel6 ~]$ kill -9 23617 [oracle@oel6 ~]$ kill -9 23646 [oracle@oel6 ~]$ rman target / Recovery Manager: Release 11.2.0.1.0 - Production on Tue Feb 10 15:59:14 2015 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: TESTDB (DBID=2647984357) RMAN>
No comments:
Post a Comment