Hai

I have a tape drive that holds my databse backups.For a few days its not happening.I tried a maual command to backup to tape and was hung.Next i gave the command to do a backup to disk and am getting the enqueue error.

waiting for snapshot controlfile enqueue
RMAN-08512: waiting for snapshot controlfile enqueue
RMAN-08512: waiting for snapshot controlfile enqueue
RMAN-08512: waiting for snapshot controlfile enqueue
RMAN-08512: waiting for snapshot controlfile enqueue

now when i take the enque jobs from the v$enqueue_lock ,i see the first job is waiting since the tape drive is faulty.

How can i cancel the first job.

Please help me.

Micky