5 Replies Latest reply: Nov 28, 2012 12:26 AM by user301482 RSS

    V$RMAN_BACKUP_JOB_DETAILS view showing rman status running

    user12194321
      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
          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
            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
              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
                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
                  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