Solved

Update  V$RMAN_BACKUP_JOB_DETAILS view

Posted on 2014-02-25
15
2,154 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 5
  • 2
15 Comments
 
LVL 77

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 77

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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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 77

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
 

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 77

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 77

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
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…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

726 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