STOP Rman backup job byKilling Process from SQL Prompt

If the Rman job process is running in the foreground on your screen then type ‘ctl+C’, but if its running in the background then you can kill either manually by finding sid/spid or using OEM

To know the rman sid and spid of your running job use the below script

SQL >   SELECT p.SPID, s.sid, s.serial#, sw.EVENT, sw.SECONDS_IN_WAIT AS  SEC_WAIT, sw.STATE, CLIENT_INFO
FROM V$SESSION_WAIT sw, V$SESSION s, V$PROCESS p

WHERE s.client_info LIKE ‘rman%’

AND s.SID=sw.SID

AND s.PADDR=p.ADDR;

SPID      SID      SERIAL#    EVENT                                     SEC_WAIT     STATE        CLIENT_INFO

——-   ——-    ———-    ——————                              ————–    ——–        ——————

1234   5678     98765      control file sequential read                         0     WAITING     rman channel=ORA_DISK_1

SQL >   alter system kill session ’SID, SERIAL#′;

Advertisements
Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: