09-01-2015 10:43 PM
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
09-02-2015 04:16 AM
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?
09-05-2015 12:51 AM
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 |
09-05-2015 09:19 PM
Answer the question.
09-06-2015 09:12 PM
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.
09-07-2015 03:35 AM
Show me the policy you use to backup this Oracle Client.
bppllist "policy name" -U
09-07-2015 05:25 AM
result of bpplist is in the attach file
Thanks
09-07-2015 05:57 AM
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%'
09-16-2015 04:40 AM
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.
09-16-2015 08:10 AM
Ok, so just change the domain_jobarchive.policyname like condition to match your requirement. Or add more via the AND statement.