Takılan RMAN session’larını kill etme

         Rman sessionları Media Layer katmanından cevap alamadığında kill etmek için CTRL+C işe yaramayabilir. Bu durumda session’i kill etmek için aşağıdaki sorgu ile process id değeri bulunup kill edilir.

oracle@hostname:/oracle/product/11.2.0.3/db/lib>rman target / debug trace=/tmp/rman.log

Recovery Manager: Release 11.2.0.3.0 - Production on Tue Aug 12 09:23:54 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN-06006: connected to target database: DBNAME (not mounted)

RMAN>  connect catalog username/pass@rcatdb

RMAN-06008: connected to recovery catalog database

RMAN> run

2> {

3> set until scn 11812341070106;

4> allocate channel t1 type 'SBT_TAPE' parms 'ENV=(NSR_CLIENT=targethostname,NSR_SERVER=backupserverhostname.ttnet.local)';

5> RESTORE CONTROLFILE;

6> RELEASE channel t1;

7> }

TRACE Çıktısı

DBGRPC:           EXITED krmqgns with status 1

DBGRPC:           krmxpoq - returning rpc_number: 17 with status: STARTED40 for channel t1

DBGRPC:           krmxr - sleeping for 10 seconds

DBGRPC:           ENTERED krmqgns

DBGRPC:            krmqgns: looking for work for channel default (krmqgns)

DBGRPC:            krmqgns: commands remaining to be executed: (krmqgns)

DBGRPC:            CMD type=IRESTORE cmdid=1 status=STARTED

DBGRPC:                  1 STEPstepid=1 cmdid=1 status=STARTED devtype=SBT_TAPE bs.stamp=855302866 step_size=0 Bytes

DBGRPC:                      1 DON_F stepid=2 satisfied=TRUE

DBGRPC:            krmqgns: no work found for channel default (krmqgns)

DBGRPC:             (krmqgns)

Kill İşlemi

sqlplus / as sysdba

SQL> COLUMN EVENT FORMAT a17

SQL> COLUMN SECONDS_IN_WAIT FORMAT 999

SQL> COLUMN STATE FORMAT a10

SQL> COLUMN CLIENT_INFO FORMAT a30

SQL> set linesize 200

SELECT 'kill -9 '||p.SPID, s.EVENT, s.SECONDS_IN_WAIT AS SEC_WAIT,

       sw.STATE, s.CLIENT_INFO

FROM   V$SESSION_WAIT sw, V$SESSION s, V$PROCESS p

WHERE  sw.EVENT LIKE '%MML%'

AND    s.SID=sw.SID

AND    s.PADDR=p.ADDR;

'KILL-9'||P.SPID                 EVENT               SEC_WAIT STATE      CLIENT_INFO

-------------------------------- ----------------- ---------- ---------- ------------------------------

kill -9 6866                     Backup: MML resto         36 WAITING    rman channel=t1

                                         re backup piece

SQL>

Unix command

oracle@hostname:/tmp> kill -9 6212

Eğer bu bilgi bulunamıyor ise ve database ‘in kapatılmasında sakınca yok ise (Restore testleri yapılıyor ise) DB açilip kapatılabilir.