cancel
Showing results for 
Search instead for 
Did you mean: 

oracle job duration is not correct

hi friends

i use netbackup 7.5 and opscenter for reporting. type of some of policies are oracle database. and they have several channels to do the backup.

when i use job duration report for the policy it sum measure of all channels. for example i know job duration must be 40 hours but becouse of 5 channles it show me 200 hours.

is there a way to count exaclt measure of this kind of policy?

Thanks

Best Regards

9 Replies

You can just look at the

You can just look at the duration of the parent job. Or do the jobs get initiated from the client and there is no parent?

This report explain

This report explain clearly.

job duration in this report from opscenter show job policy duration per channel. and i need whole of job duration not oll channle. the sum of these channle is not actual becouse some of them run at the same time.

 

please guide if have exprience before..

Thanks

 

Policy Name Schedule Name Job Start Time Job End Time Job Duration
ORA-L0-client1 client1-Full  Sep 3, 2015 1:00:00 PM  Sep 4, 2015 8:00:00 PM  31:00:00 
ORA-L0-client1 Default-client1-Full  Sep 3, 2015 1:00:14 PM  Sep 3, 2015 1:02:50 PM  00:02:36 
ORA-L0-client1 Default-client1-Full  Sep 3, 2015 1:02:52 PM  Sep 4, 2015 7:44:40 PM  30:41:48 
ORA-L0-client1 Default-client1-Full  Sep 3, 2015 1:02:52 PM  Sep 4, 2015 3:48:50 PM  26:45:58 
ORA-L0-client1 Default-client1-Full  Sep 3, 2015 1:02:52 PM  Sep 4, 2015 2:29:40 PM  25:26:48 
ORA-L0-client1 Default-client1-Full  Sep 3, 2015 1:02:52 PM  Sep 4, 2015 1:22:30 PM  24:19:38 
ORA-L0-client1 Default-client1-Full  Sep 3, 2015 1:02:53 PM  Sep 3, 2015 6:31:00 PM  05:28:07 
ORA-L0-client1 Default-client1-Full  Sep 3, 2015 1:02:53 PM  Sep 3, 2015 6:14:00 PM  05:11:07 
ORA-L0-client1 Default-client1-Full  Sep 3, 2015 1:02:53 PM  Sep 3, 2015 8:23:00 PM  07:20:07 
ORA-L0-client1 Default-client1-Full  Sep 3, 2015 1:02:53 PM  Sep 3, 2015 5:00:30 PM  03:57:37 
ORA-L0-client1 Default-client1-Full  Sep 3, 2015 5:00:46 PM  Sep 3, 2015 5:01:10 PM  00:00:24 
ORA-L0-client1 Default-client1-Full  Sep 4, 2015 7:44:41 PM  Sep 4, 2015 7:47:00 PM  00:02:19 
ORA-L0-client1 Default-client1-Full  Sep 4, 2015 7:47:05 PM  Sep 4, 2015 7:47:30 PM  00:00:25 

Answer the question.  

Answer the question.
 

parent job may be finished

parent job may be finished sooner than other channel. job duration is one of daily report here. i just can the exdact time by login to client and see time stamp of start and finish backup policy.

Show me the policy you use to

Show me the policy you use to backup this Oracle Client.

 

bppllist "policy name" -U

result of bpplist is in the

result of bpplist is in the attach file

 

Thanks

Try that. Your parent should

Try that. Your parent should not finish before the child jobs.

 

select
NOM_DateDiff(domain_JobArchive.startTime, domain_JobArchive.endTime) as "JobDuration",
domain_JobArchive.policyname as "Policy"
from domain_jobarchive
where
domain_jobarchive.type in (0)
and
domain_jobarchive.policyname like '%B2CArchive-T6K-PH-ORA-L0-b2c%'
and
domain_jobarchive.schedulename like '%B2CArchive-Full%'

hi thanks for the reply I try

hi

thanks for the reply

I try that but it is so difficult that i use for each oracle client and run it for them seprately. i want to make a report that report everything for me.

 

Ok, so just change the

Ok, so just change the domain_jobarchive.policyname like condition to match your requirement. Or add more via the AND statement.