Re: RMAN job doesnt exit

What is I the “wchan” column when you check with ps?

On Wed, Jan 17, 2018 at 4:11 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. ​
>
>
> --
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Principal Consultant at Pythian
Pythian Blog http://www.pythian.com/blog/author/still/ Github: https://github.com/jkstill

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