Re: RMAN job doesnt exit

From: Dave Herring <gdherri_at_gmail.com>
Date: Thu, 18 Jan 2018 08:04:16 -0600
Message-ID: <CAFN=diAo-uBLXsFrYD-nU2h-PL2bG7-RFxH6b9J9arQFv16zxw_at_mail.gmail.com>



Howard, I ran into something similar a few years ago on 11g where a syntax error was made, leaving off the ending "}" of the run block.

Dave

On Wed, Jan 17, 2018 at 6:09 AM, Howard Latham <howard.latham_at_gmail.com> wrote:

> Oracle 11g
>
> REDHAT LINUX 6. Enterprise.
>
> Bit of a weird one . I have several rman jobs that run daily. Sometimes
> the shell script completes but the rman image still seems to be running
> consuming CPU. The shell script deletes the running lock and a listing
> shows that the backup is complete. The log says backup complete too. I'm
> trying to write a script to kill these 'limbo' jobs and have so far found
> that I can find that there might be a Limbo job if ps -ef | grep rman
> shows there's an rman running but V_$RMAN_STATUS shows no STATUS=RUNNING
> Rman Jobs.
>
> I'd really like to stop this happening rather than fixing it. anyone else
> seen this?
>
>
>
>
> Howard A. Latham
>
> ​DBA in the media. ​
>
>
>

-- 
Dave

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 18 2018 - 15:04:16 CET

Original text of this message