This discussion is archived
5 Replies Latest reply: Nov 27, 2012 10:26 PM by user301482 RSS

V$RMAN_BACKUP_JOB_DETAILS view showing rman status running

user12194321 Newbie
Currently Being Moderated
Hi,

There is no rman session running in the database but still V$RMAN_BACKUP_JOB_DETAILS shows status as running
select SID,username, opname,to_char(START_TIME,'dd mm yyyy hh:mm:ss'),TOTALWORK, sofar, (sofar/totalwork) * 100 done,TIME_REMAINING/3600/24,
to_char(sysdate + TIME_REMAINING/3600/24,'dd mm yyyy hh:mm:ss') end_at
from v$session_longops
where totalwork > sofar
AND opname NOT LIKE '%aggregate%'
AND opname like 'RMAN%'SQL>   2    3    4    5    6
  7  ;

no rows selected


SQL> select sid, CLIENT_INFO ch, seq#, event, state from v$session where program like '%rman%';

no rows selected


SQL> select SESSION_KEY,SESSION_RECID,START_TIME,END_TIME,STATUS from V$RMAN_BACKUP_JOB_DETAILS where START_TIME > sysdate-3;

SESSION_KEY SESSION_RECID START_TIM END_TIME  STATUS
----------- ------------- --------- --------- -----------------------
       2853          2853 20-NOV-12 20-NOV-12 COMPLETED
       2862          2862 22-NOV-12           RUNNING
       2864          2864 22-NOV-12 22-NOV-12 COMPLETED
please can anyone shed some light on it

Thanks
  • 1. Re: V$RMAN_BACKUP_JOB_DETAILS view showing rman status running
    mseberg Guru
    Currently Being Moderated
    Hello;

    Might depend upon your version.

    BUG 8677212 - BACKUP INFORMATION FOR SOME DATABASES SHOWS INCORRECTLY.

    See MOS note 849722.1

    Best Regards

    mseberg
  • 2. Re: V$RMAN_BACKUP_JOB_DETAILS view showing rman status running
    user12194321 Newbie
    Currently Being Moderated
    Hi

    Thanks for the inputs

    My oracle version is 11.2.0.2

    Thanks
  • 3. Re: V$RMAN_BACKUP_JOB_DETAILS view showing rman status running
    efierro Newbie
    Currently Being Moderated
    1. RMAN session info may not appear in v$session_longops.
    2. I am not sure the filter "program like '%rman%'" would brinig back rman sessions, have you confirmed that? in other words have you used that query before to check that rman backups are running?
  • 4. Re: V$RMAN_BACKUP_JOB_DETAILS view showing rman status running
    user301482 Newbie
    Currently Being Moderated
    Hi,

    Is there a solution for this yet?

    I am having a similar problem with a backup that stopped when the NFS share became unavailable. The backup job still appears in v$backup_job_details but I cannot find and any related sessions. I want to remove the job so it does not appear in backup reports indefintely. I am also concerned about other orphaned sessions related to the job.

    I am using oracle database 11.2.0.3 on OL5.8


    C
  • 5. Re: V$RMAN_BACKUP_JOB_DETAILS view showing rman status running
    user301482 Newbie
    Currently Being Moderated
    Fixed.

    In my solution I grabbed the command id from the details view and then matched that with the sid in the status view
    SQL> select session_key, command_id, status, time_taken_display from v$rman_backup_job_details where command_id='2012-11-27T22:30:37';
    
    SESSION_KEY COMMAND_ID                        STATUS
    ----------- --------------------------------- -----------------------
    TIME_TAKEN_DISPLAY
    --------------------------------------------------------------------------------
            602 2012-11-27T22:30:37               RUNNING WITH ERRORS
    16:32:53
    
    
    SQL> select sid from v$rman_status where COMMAND_ID='2012-11-27T22:30:37';
    
           SID
    ----------
             4
             4
    
    SQL>
    then I made sure I was sys, before grabbing the session info and killing the session
    SQL> select user from user_users;
    
    USER
    ------------------------------
    SYS
    
    SQL>
    SQL> select sid,serial#,inst_id from gv$session  where sid=4 and serial#=3;
    
           SID    SERIAL#    INST_ID
    ---------- ---------- ----------
             4          3          2
    
    SQL> alter system kill session '4,3,@2' immediate;
    
    System altered.
    
    SQL> 
    let me know if this worked for you.

    hope this helps, C

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points