Re: DMON problem, missing archived log as well.

I forgot to mention...you can 'manually' stop dmon by setting: dg_broker_start=false

goran

On 11/10/06, Norman Dunbar <norman.dunbar_at_environment-agency.gov.uk> wrote:
>
>
> Afternoon all,
>
> we have a 9204 database running on Windows 2000 with a standby.
>
> There is a huge performance problem on the primary and I've tracked it
> down to one of the oracle processes eating up most of the CPU on the
> box.
>
> The session that is hogging the CPU is DMON. The alert log shows that
> it tried to archive log 44419 first of all to the standby (remote)
> location and at some point in doing so, an Oracle 600 error was
> detected. ([kcrrupirfs.20][0][0] for which there is one mention on
> Metalink's ora-600 lookup tool. That is for an OCFS problem on Windows
> 2003 server and we are not using OCFS on this box.
>
> The trace file is corrupt - notepad cannot open it, Wordpad gets to 3%
> then resets to 0% over and over. WinZip was able to compress it, but
> aborts (just disappears) when you try to view with internal viewer.
>
> The remote standby database shows no record of sequence 44419, but the
> alert log shows numerous attempts to fetch the gap of 44419-44419. This
> failed.
>
> V$LOG shows that there are 20 groups and 14 is at sequence 44419, it
> has not bee archived. The current group is 20. I suspect when we get
> back to group 14 again, we will simply hang waiting to archive sequence
> 44419. Thankfully, we only get through about 2 or 3 groups in a day and
> there won't be much, if anything running over the weekend.
>
> DMGRL allows me to connect to the primary and says 'connected' but sits
> there without giving me a prompt back. Not much help there !
>
> Obviously, being Windows, even though I have identified the thread that
> is DMON and can see the resources etc that it uses (performance manager
> utility) I cannot kill it like I could on Windows - if I wanted to that
> is.
>
> I've never come across anything like this before, my colleagues here
> have not either, Google has no info that I can find and neither does
> Metalink. I am wondering if :
>
> (a) I can simply shutdown the database (abort or whatever) and restart
> it and hopefully everything will work again. I knows I should archive
> log group 14 ASAP.
>
> (b) Anyone knows how to kill a thread on Windows rather than the whole
> Oracle process.
>
> (c) Anyone has seen anything like this in the past, and if so, what did
> you do ?
>
>
> I know the ora-600 is an SR problem, and it will be dealt with, but
> come Monday, I'm going to be a little busy trying to get this problem
> sorted out and I'd like some more information form those who know, if at
> all possible before I go in shutting stuff down etc.
>
>
> Thanks.
>
>
> Cheers,
> Norman.
>
> Norman Dunbar.
> Contract Oracle DBA.
> Rivers House, Leeds.
>
> Internal : 7 28 2051
> External : 0113 231 2051
>
>
> Information in this message may be confidential and may be legally
> privileged. If you have received this message by mistake, please notify the
> sender immediately, delete it and do not copy it to anyone else.
>
> We have checked this email and its attachments for viruses. But you should
> still check any attachment before opening it.
>
> We may have to make this message and any reply to it public if asked to
> under the Freedom of Information Act, Data Protection Act or for
> litigation. Email messages and attachments sent to or from any Environment
> Agency address may also be accessed by someone other than the sender or
> recipient, for business purposes.
>
> If we have sent you information and you wish to use it please read our
> terms and conditions which you can get by calling us on 08708 506 506. Find
> out more about the Environment Agency at www.environment-agency.gov.uk
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l