A wierd RMAN problem. Even wierder than Mladen
- From: "Weaver, Walt" <wweaver@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 6 Mar 2004 13:51:19 -0700
Okay, it's not really as wierd as Mladen, but I'm having problems figuring it
out.
We're running 8.1.7.4 on RedHat 7.3, a VALinux 4450 with 2GB RAM, disk is an
EMC, RAID10 exactly like Gaja says it's supposed to be.
It's a backend database server supporting customer websites running our
product. We have five other database servers doing the same thing and they are
fine.
There are approximately 100 customers on the machine. Average load according to
top is 0.50, there is very little load on the machine.
But, recently (the last few days) when RMAN starts its backup process Oracle
exceeds its max# of processes (500) in about a minute. RMAN actually runs for
about ten minutes before this happens but it happens on a regular basis now.
This morning I kicked RMAN off manually and watched things happening on the
machine. I monitored v$session and kept doing a ps-efll|grep oracle to see what
unix processes were being created. v$session showed just a SYSTEM process (me)
and 4-8 SYS processes (RMAN). But, ps showed a ton of LOCAL=NO processes, which
indicated customers were connecting to the server. But, when I queried
v$session the only connections were me and RMAN.
I killed the RMAN job and everything returned to normal.
So, why would I see so many LOCAL=NO processes but nothing in v$session? Could
it be a listener thing? What could RMAN possibly be doing?
We're using Veritas NetBackup to communicate with RMAN and write everything
directly to tape. The process is identical to how we're doing things on the
other five servers, although they serve fewer customers (8-10, but they're big
customers).
Right now I don't have a clue as to why this is happening. Has anyone else seen
this sort of thing with RMAN? Got any ideas?
Okay, I have to head to the airport now and fly to Idaho. For fun. I'm not
going to worry about this until I get back in a few hours. But, if anyone has
any thoughts on this I'd sure appreciate hearing'em.
Thanks,
--Walt Weaver
Bozeman, Montana
Other related posts:
