Re: [Veritas-bu] How to know biggest client backup ?

[Jánský Vítězslav]

VTL is just another tape changer for NetBackup. You should use media deassign 
notify + bplabel to relabel unassigned tapes and free allocated space.

V.J.

Odesílatel: veritas-bu-boun...@mailman.eng.auburn.edu 
[veritas-bu-boun...@mailman.eng.auburn.edu] za uživatele O'Connor. Kevin 
(Business Service Centre) [kevin.ocon...@esbi.ie]
Odesláno: 5. prosince 2013 15:37
Komu: 'Anurag Sharma'; veritas-bu; veritas-bu2
Předmět: Re: [Veritas-bu] How to know biggest client backup ?

Hi Anurag,

Might be a foolish question but have you taken into account that Netbackup and 
VTL’s don’t talk to each other too well ?
In other words when Netbackup expires an image sitting on a VTL it doesn’t tell 
the VTL to delete the image from the Disk, this means the VTL can fill up very 
quickly and crash it (as we found out in the early days).

Three things need to happen, the VTL drives need to be small, the Max Mounts on 
each media needs to be set low and then you need to run a long erase against 
Scratchpool media (this is the only way to tell VTL’s to delete the images).
After setting the first two you can script the erases to run every couple of 
days and that will reduce the redundant data on the VTL’s.

If you need more info let me know and I can go into a lot more detail and how 
we’re doing it.

Regards
Kevin

Kevin O’Connor | Storage Management | Service Delivery | IT Services | ESB 
Business Service Centre | www.esb.ie<http://www.esb.ie/>

From: Anurag Sharma [mailto:sharma.anu...@hotmail.com]
Sent: 27 November 2013 7:56P
To: veritas-bu; veritas-bu2
Subject: [Veritas-bu] How to know biggest client backup ?

Hi All,

My query is simple, I have backups going to VTL then duplicated to tape.

Now VTL is filling up badly and need to move some of backups directly to the 
tapes.

Could any one tell me the easiest way to list top 10 backups ( as per their 
backup size ) on VTL storage unit which I can move directly to the tapes for 
the time being.

Regards
Anurag
___
Veritas-bu maillist  -  Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

Re: [Veritas-bu] How to know biggest client backup ?

[O'Connor. Kevin (Business Service Centre)]

Hi Anurag,

Might be a foolish question but have you taken into account that Netbackup and 
VTL's don't talk to each other too well ?
In other words when Netbackup expires an image sitting on a VTL it doesn't tell 
the VTL to delete the image from the Disk, this means the VTL can fill up very 
quickly and crash it (as we found out in the early days).

Three things need to happen, the VTL drives need to be small, the Max Mounts on 
each media needs to be set low and then you need to run a long erase against 
Scratchpool media (this is the only way to tell VTL's to delete the images).
After setting the first two you can script the erases to run every couple of 
days and that will reduce the redundant data on the VTL's.

If you need more info let me know and I can go into a lot more detail and how 
we're doing it.

Regards
Kevin

Kevin O'Connor | Storage Management | Service Delivery | IT Services | ESB 
Business Service Centre | www.esb.ie

From: Anurag Sharma [mailto:sharma.anu...@hotmail.com]
Sent: 27 November 2013 7:56P
To: veritas-bu; veritas-bu2
Subject: [Veritas-bu] How to know biggest client backup ?

Hi All,

My query is simple, I have backups going to VTL then duplicated to tape.

Now VTL is filling up badly and need to move some of backups directly to the 
tapes.

Could any one tell me the easiest way to list top 10 backups ( as per their 
backup size ) on VTL storage unit which I can move directly to the tapes for 
the time being.

Regards
Anurag

An timpeallacht? - Smaoinigh air sula bpriontáileann tú an r-phost seo.
Please consider the Environment before printing this email. 

* ** *** ** * ** *** ** * ** *** ** *
Tá an t-eolas sa ríomhphost seo agus in aon chomhad a ghabhann leis rúnda agus 
ceaptha le haghaidh úsáide an té nó an aonáin ar seoladh chuige iad agus na 
húsáide sin amháin.
Is tuairimí nó dearcthaí an údair amháin aon tuairimí nó dearcthaí ann, agus ní 
gá gurb ionann iad agus tuairimí nó dearcthaí ESB.
Má bhfuair tú an ríomhphost seo trí earráid, ar mhiste leat é sin a chur in iúl 
don seoltóir.
Scanann ESB ríomhphoist agus ceangaltáin le haghaidh víreas, ach ní ráthaíonn 
sé go bhfuil ceachtar díobh saor ó víreas agus ní glacann dliteanas ar bith as 
aon damáiste de dhroim víreas.
Cláraithe an Chomhlachta: http://www.esb.ie/companies


This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed.
Any views or opinions presented are solely those of the author, and do not 
necessarily represent those of ESB.
If you have received this email in error please notify the sender.
Although ESB scans e-mail and attachments for viruses, it does not guarantee 
that either is virus-free and accepts no liability for any damage sustained as 
a result of viruses.
Company Registration Information: http://www.esb.ie/companies

* ** *** ** * ** *** ** * ** *** ** *
___
Veritas-bu maillist  -  Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

Re: [Veritas-bu] How to know biggest client backup ?

[Harpreet]

Hi. 

I am able to directly open it in excel 2010. 

Have a nice day.

> On 29 Nov, 2013, at 10:01 pm, Anurag Sharma  wrote:
> 
> Harpreet,
> 
> You are a genius man, thanks a lot, it worked right away.
> 
> I know I'm being mean but cant it be modified further to export to exce ?
> 
> 
> All please keep a copy of this script it can really help with sizing issues 
> and growth rattans
> 
> Thank you all for reply
> 
> Anurag 
> 
> Date: Fri, 29 Nov 2013 20:56:44 +0800
> Subject: Re: [Veritas-bu] How to know biggest client backup ?
> From: harpreetra...@gmail.com
> To: sharma.anu...@hotmail.com
> CC: mator...@gmail.com; veritas-bu@mailman.eng.auburn.edu; 
> veritas-bu-boun...@mailman.eng.auburn.edu
> 
> Hi Anrag,
>  
> You can try this script. Please change the path accordingly.
> I have tested on Solaris/Linux. it is workiing fine.
>  
> With Warm Regards
> Harpreet
> 
> 
> On Fri, Nov 29, 2013 at 7:01 PM, Anurag Sharma  
> wrote:
> Awesome Anatoly
> Let me try and get back to you.
> 
> 
> Anurag
> 
> > Date: Fri, 29 Nov 2013 13:03:06 +0400
> > Subject: Re: [Veritas-bu] How to know biggest client backup ?
> > From: mator...@gmail.com
> > To: sharma.anu...@hotmail.com
> > CC: veritas-bu@mailman.eng.auburn.edu; 
> > veritas-bu-boun...@mailman.eng.auburn.edu
> 
> > 
> > Anurag,
> > 
> > 1) install opscenter and use included functionality for reporting
> > 
> > 2) use NBU command line,
> > 
> > [root@nbu7 ~]# bpdbjobs -report -gdm
> > 25,17,3,1,1385714991,01,1385714992,nbu7,,,0
> > 24,0,3,0,tmp1,Full,nbu7,nbu7,1385714978,14,1385714992,st1,0,0,0,nbu7,37056,127,100
> > 
> > where 37056 is backup size. So easily scripting could give like
> > clients and their backup size:
> > 
> > # bpdbjobs -report -gdm | awk -F, '{print $7,$17}' | sort
> > 
> > 3) export (File->Export) 'Activity monitor' page of Netback
> > Administration Console to a file and use external tools (speadsheet)
> > to parse it.
> > 
> > Wed, Nov 27, 2013 at 11:55 PM, Anurag Sharma  
> > wrote:
> > > Hi All,
> > >
> > > My query is simple, I have backups going to VTL then duplicated to tape.
> > >
> > > Now VTL is filling up badly and need to move some of backups directly to 
> > > the
> > > tapes.
> > >
> > > Could any one tell me the easiest way to list top 10 backups ( as per 
> > > their
> > > backup size ) on VTL storage unit which I can move directly to the tapes 
> > > for
> > > the time being.
> > >
> 
> ___
> Veritas-bu maillist  -  Veritas-bu@mailman.eng.auburn.edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
> 
> 
> 
> 
> -- 
> *
> With Warm Regards.
> Harpreet Singh Chana
> *
___
Veritas-bu maillist  -  Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

Re: [Veritas-bu] How to know biggest client backup ?

[Anurag Sharma]

Harpreet,

You are a genius man, thanks a lot, it worked right away.

I know I'm being mean but cant it be modified further to export to exce ?


All please keep a copy of this script it can really help with sizing issues and 
growth rattans

Thank you all for reply

Anurag 

Date: Fri, 29 Nov 2013 20:56:44 +0800
Subject: Re: [Veritas-bu] How to know biggest client backup ?
From: harpreetra...@gmail.com
To: sharma.anu...@hotmail.com
CC: mator...@gmail.com; veritas-bu@mailman.eng.auburn.edu; 
veritas-bu-boun...@mailman.eng.auburn.edu

Hi Anrag, You can try this script. Please change the path accordingly.I have 
tested on Solaris/Linux. it is workiing fine. With Warm Regards
Harpreet

On Fri, Nov 29, 2013 at 7:01 PM, Anurag Sharma  
wrote:




Awesome Anatoly
Let me try and get back to you.


Anurag

> Date: Fri, 29 Nov 2013 13:03:06 +0400
> Subject: Re: [Veritas-bu] How to know biggest client backup ?
> From: mator...@gmail.com

> To: sharma.anu...@hotmail.com
> CC: veritas-bu@mailman.eng.auburn.edu; 
> veritas-bu-boun...@mailman.eng.auburn.edu

> 
> Anurag,
> 
> 1) install opscenter and use included functionality for reporting
> 
> 2) use NBU command line,
> 
> [root@nbu7 ~]# bpdbjobs -report -gdm
> 25,17,3,1,1385714991,01,1385714992,nbu7,,,0

> 24,0,3,0,tmp1,Full,nbu7,nbu7,1385714978,14,1385714992,st1,0,0,0,nbu7,37056,127,100
> 
> where 37056 is backup size. So easily scripting could give like
> clients and their backup size:
> 

> # bpdbjobs -report -gdm | awk -F, '{print $7,$17}' | sort
> 
> 3) export (File->Export) 'Activity monitor' page of Netback
> Administration Console to a file and use external tools (speadsheet)

> to parse it.
> 
> Wed, Nov 27, 2013 at 11:55 PM, Anurag Sharma  
> wrote:
> > Hi All,
> >

> > My query is simple, I have backups going to VTL then duplicated to tape.
> >
> > Now VTL is filling up badly and need to move some of backups directly to the
> > tapes.
> >

> > Could any one tell me the easiest way to list top 10 backups ( as per their
> > backup size ) on VTL storage unit which I can move directly to the tapes for
> > the time being.
> >

  

___

Veritas-bu maillist  -  Veritas-bu@mailman.eng.auburn.edu

http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu




-- 
*
With Warm Regards.
Harpreet Singh Chana
*
  ___
Veritas-bu maillist  -  Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

Re: [Veritas-bu] How to know biggest client backup ?

[Harpreet Singh Chana]

Hi Anrag,

You can try this script. Please change the path accordingly.
I have tested on Solaris/Linux. it is workiing fine.

With Warm Regards
Harpreet


On Fri, Nov 29, 2013 at 7:01 PM, Anurag Sharma wrote:

> Awesome Anatoly
> Let me try and get back to you.
>
>
> Anurag
>
> > Date: Fri, 29 Nov 2013 13:03:06 +0400
> > Subject: Re: [Veritas-bu] How to know biggest client backup ?
> > From: mator...@gmail.com
> > To: sharma.anu...@hotmail.com
> > CC: veritas-bu@mailman.eng.auburn.edu;
> veritas-bu-boun...@mailman.eng.auburn.edu
>
> >
> > Anurag,
> >
> > 1) install opscenter and use included functionality for reporting
> >
> > 2) use NBU command line,
> >
> > [root@nbu7 ~]# bpdbjobs -report -gdm
> > 25,17,3,1,1385714991,01,1385714992,nbu7,,,0
> >
> 24,0,3,0,tmp1,Full,nbu7,nbu7,1385714978,14,1385714992,st1,0,0,0,nbu7,37056,127,100
> >
> > where 37056 is backup size. So easily scripting could give like
> > clients and their backup size:
> >
> > # bpdbjobs -report -gdm | awk -F, '{print $7,$17}' | sort
> >
> > 3) export (File->Export) 'Activity monitor' page of Netback
> > Administration Console to a file and use external tools (speadsheet)
> > to parse it.
> >
> > Wed, Nov 27, 2013 at 11:55 PM, Anurag Sharma 
> wrote:
> > > Hi All,
> > >
> > > My query is simple, I have backups going to VTL then duplicated to
> tape.
> > >
> > > Now VTL is filling up badly and need to move some of backups directly
> to the
> > > tapes.
> > >
> > > Could any one tell me the easiest way to list top 10 backups ( as per
> their
> > > backup size ) on VTL storage unit which I can move directly to the
> tapes for
> > > the time being.
> > >
>
> ___
> Veritas-bu maillist  -  Veritas-bu@mailman.eng.auburn.edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
>
>


-- 
*
With Warm Regards.
Harpreet Singh Chana
*


Net_Backup_Total_Report.sh
Description: Bourne shell script
___
Veritas-bu maillist  -  Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

Re: [Veritas-bu] How to know biggest client backup ?

[Anurag Sharma]

Awesome Anatoly
Let me try and get back to you.


Anurag

> Date: Fri, 29 Nov 2013 13:03:06 +0400
> Subject: Re: [Veritas-bu] How to know biggest client backup ?
> From: mator...@gmail.com
> To: sharma.anu...@hotmail.com
> CC: veritas-bu@mailman.eng.auburn.edu; 
> veritas-bu-boun...@mailman.eng.auburn.edu
> 
> Anurag,
> 
> 1) install opscenter and use included functionality for reporting
> 
> 2) use NBU command line,
> 
> [root@nbu7 ~]# bpdbjobs -report -gdm
> 25,17,3,1,1385714991,01,1385714992,nbu7,,,0
> 24,0,3,0,tmp1,Full,nbu7,nbu7,1385714978,14,1385714992,st1,0,0,0,nbu7,37056,127,100
> 
> where 37056 is backup size. So easily scripting could give like
> clients and their backup size:
> 
> # bpdbjobs -report -gdm | awk -F, '{print $7,$17}' | sort
> 
> 3) export (File->Export) 'Activity monitor' page of Netback
> Administration Console to a file and use external tools (speadsheet)
> to parse it.
> 
> Wed, Nov 27, 2013 at 11:55 PM, Anurag Sharma  
> wrote:
> > Hi All,
> >
> > My query is simple, I have backups going to VTL then duplicated to tape.
> >
> > Now VTL is filling up badly and need to move some of backups directly to the
> > tapes.
> >
> > Could any one tell me the easiest way to list top 10 backups ( as per their
> > backup size ) on VTL storage unit which I can move directly to the tapes for
> > the time being.
> >
  ___
Veritas-bu maillist  -  Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

Re: [Veritas-bu] How to know biggest client backup ?

[Anatoly Pugachev]

Anurag,

1) install opscenter and use included functionality for reporting

2) use NBU command line,

[root@nbu7 ~]# bpdbjobs -report -gdm
25,17,3,1,1385714991,01,1385714992,nbu7,,,0
24,0,3,0,tmp1,Full,nbu7,nbu7,1385714978,14,1385714992,st1,0,0,0,nbu7,37056,127,100

where 37056 is backup size. So easily scripting could give like
clients and their backup size:

# bpdbjobs -report -gdm | awk -F, '{print $7,$17}' | sort

3) export (File->Export) 'Activity monitor' page of Netback
Administration Console to a file and use external tools (speadsheet)
to parse it.

Wed, Nov 27, 2013 at 11:55 PM, Anurag Sharma  wrote:
> Hi All,
>
> My query is simple, I have backups going to VTL then duplicated to tape.
>
> Now VTL is filling up badly and need to move some of backups directly to the
> tapes.
>
> Could any one tell me the easiest way to list top 10 backups ( as per their
> backup size ) on VTL storage unit which I can move directly to the tapes for
> the time being.
>
___
Veritas-bu maillist  -  Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

Re: [Veritas-bu] How to know biggest client backup ?

[Anurag Sharma]

Any other opinions please ?
 
From: sharma.anu...@hotmail.com
To: veritas-bu@mailman.eng.auburn.edu; veritas-bu-boun...@mailman.eng.auburn.edu
Date: Thu, 28 Nov 2013 01:25:49 +0530
Subject: [Veritas-bu] How to know biggest client backup ?




Hi All,

My query is simple, I have backups going to VTL then duplicated to tape.

Now VTL is filling up badly and need to move some of backups directly to the 
tapes.

Could any one tell me the easiest way to list top 10 backups ( as per their 
backup size ) on VTL storage unit which I can move directly to the tapes for 
the time being.

Regards
Anurag

___
Veritas-bu maillist  -  Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu   
  ___
Veritas-bu maillist  -  Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu