2010/09/17

How to Kill RMAN Backup Sessions

You can identify the Oracle session ID for an RMAN channel by looking in the RMAN log for messages with the format shown in the following example:

channel ch1: sid=15 devtype=SBT_TAPE
You can kill the session using a SQL ALTER SYSTEM KILL SESSION statement. The serial# can be obtained by querying V$SESSION.

1 comment:

Santosh said...

I was struggling to kill rman sessions and I find this query very helpful.