Solved

Update  V$RMAN_BACKUP_JOB_DETAILS view

Posted on 2014-02-25
15
2,014 Views
Last Modified: 2014-03-05
When attempting  a 11.2 upgrade is run in message that says there is a backup job running and gives the option to continue.  I did continue but I would prefer getting rid of the condition that causes the message.   Basically the V$RMAN_BACKUP_JOB_DETAILS
view is showing a status of 'RUNNING'.  There is some dbms_???? that will make changes to the underlying table to end that, but I've forgotten.  Anyone recall what that dbms_??? is?
0
Comment
Question by:xoxomos
  • 8
  • 5
  • 2
15 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39887568
>>There is some dbms_???? that will make changes to the underlying table to end that, but I've forgotten.

Make packages change status' and various objects/columns/rows.  As for a generic package that changes anything you want, sorry, never heard of it and doubt it exists.

>>run in message that says there is a backup job running and gives the option to continue

If it says a backup is running, there is likely a backup running.

Maybe you should stop the backup?  Maybe turn off the schedule long enough to perform the upgrade.
0
 

Author Comment

by:xoxomos
ID: 39887611
The status of 'running', I believe is due to perhaps the database being taken down because the 'running' is from several days ago.  A couple 'completed' show up after if I look in the history.
I found a blog earlier this month where the author also ran into this situation while upgrading and posted the solution, dbms_???, but I did not think to save. :-(
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39887669
Can you bounce the database?

See if the session might still be running and kill it.

There is some information here that might help you with that:
https://community.oracle.com/message/10708623

It looks at command_id in v$rman_backup_job_details then gets the sid from v$rman_status with the command_id.

Then uses sid in v$ssession to get the serial# to issue the kill command.
0
 

Author Comment

by:xoxomos
ID: 39887783
Thanks, yes, i saw that and I may use it if needed, but the solution I saw before
involved basically using some dbms_ that basically truncated the table underlying that
 v$rman_backup_job_details  view.
0
 

Author Comment

by:xoxomos
ID: 39887794
I do believe a bounce would resolve the problem though, but since there will be only a four hour window i'd like to find that solution again just in case bounce did not resolve.
0
 
LVL 37

Expert Comment

by:Geert Gruwez
ID: 39888322
you could also query the table v$backup_async_io
select trunc(bytes/total_bytes*100, 2) percent_done, filename, status
from v$backup_async_io where status = 'IN PROGRESS';

Open in new window


if you see the percent_done changing when repeatedly querying then a backup is running
in v$session you can find which process is doing the backing up

avoiding a backup at the time for upgrade is your best option
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39888630
>>I saw before involved basically using some dbms_ that basically truncated the table underlying that   v$rman_backup_job_details  view.

I do not doubt that something exists that would purge the backup logs but it could also purge the entries from the RMAN catalog.

If you can find the reference again, I would take a look at it for you but I would be very careful it.

You can always reach out to Oracle Support and ask how to stop that specific job.  They are the only ones that would be able to guarantee that any system tweak would be 100% safe.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:xoxomos
ID: 39889849
Nopes, bouncing the database does not work.  When I start dbua after bouncing i'm still getting that message.  :-(
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39889861
If tracking down the SID and trying to kill the session doesn't work, I am sort of out of ideas.

I would then suggest working with Oracle Support.
0
 
LVL 37

Expert Comment

by:Geert Gruwez
ID: 39891307
edited ... removed comment
0
 

Accepted Solution

by:
xoxomos earned 0 total points
ID: 39893980
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmtroub.htm#BRADV89865

Contains actions relevant to the RMAN job as well as error messages generated by RMAN, the database server, and the media vendor. RMAN error messages have an RMAN-xxxxx prefix. Normal action descriptions do not have a prefix.
Note that you can execute the following PL/SQL to remove all entries from V$RMAN_STATUS:
SYS.DBMS_BACKUP_RESTORE.resetCfileSection(28);
The preceding function removes all job-related entries. No rows will be visible until new backup jobs are shown in V$RMAN_BACKUP_JOB_DETAILS.
0
 

Author Comment

by:xoxomos
ID: 39893984
Finally figured I should look in my console logs.

SQL> select start_time, status from v$rman_backup_job_details where status = 'RUNNING';

START_TIM STATUS
--------- -----------------------
25-JAN-14 RUNNING
01-FEB-14 RUNNING

SQL>
SQL>
SQL> execute sys.dbms_backup_restore.resetCfileSection(28);

PL/SQL procedure successfully completed.

SQL> select start_time, status from v$rman_backup_job_details where status = 'RUNNING';

no rows selected
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39894668
Sorry we couldn't be more help.  Feel free to accept your last post as the answer.
0
 

Author Comment

by:xoxomos
ID: 39895414
Apology refused :-)    :-)
 I should have thought to look at my console logs days ago instead of browser history :-(
 I will accept the last part though because in this case there is actually no session actually running so none of those solutions would apply in this case.  Somehow a bit just did not get set the correct way somewhere for some at present unknown reason.
I should
0
 

Author Closing Comment

by:xoxomos
ID: 39905905
In this case there is actually no session actually happening, no process to be cancelled so none of those solutions would apply in this case.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to take different types of Oracle backups using RMAN.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now