cancel
Showing results for 
Search instead for 
Did you mean: 

oracle job duration is not correct

kms11
Level 3

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 9

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

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?

kms11
Level 3

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 

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Answer the question.
 

kms11
Level 3

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.

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

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

 

bppllist "policy name" -U

kms11
Level 3

result of bpplist is in the attach file

 

Thanks

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

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%'

kms11
Level 3

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.

 

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

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