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@xxxxxxxxx>
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.