Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2013
    Posts
    39
    Provided Answers: 2

    Unanswered: rman backup still shows running

    Hi,

    Since last few days our RMAN BACKUPS is keep failing. When i ran this query i found two records the status shows is still running. And SID is 0. I am not sure how to kill these sessions. I believe these sessions not letting the job to be run. Please suggests where to find them and kill the sessions. Thanks....




    select * from v$RMAN_STATUS where status='RUNNING' ;


    SID RECID STAMP PARENT_RECID PARENT_STAMP SESSION_RECID SESSION_STAMP ROW_LEVEL ROW_TYPE OPERATION STATUS START_TIME OBJECT_TYPE
    0 14563 860893426 14560 860893264 14560 860893264 1 COMMAND BACKUP RUNNING 10/14/2014 DB INCR
    0 14560 860893264 14560 860893264 0 SESSION RMAN RUNNING 10/14/2014




    Version : Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
    Linux 2.6.18-128.el5

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •