Veritas-bu

[Veritas-bu] CMD Line

2003-03-26 17:57:45
Subject: [Veritas-bu] CMD Line
From: Mark.Donaldson AT experianems DOT com (Donaldson, Mark)
Date: Wed, 26 Mar 2003 15:57:45 -0700
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C2F3EB.1D0CAFB0
Content-Type: text/plain;
        charset="iso-8859-1"

Crud.
 
Just when I thought I found them all, there's another undocumented command.
No "man" page, no entry in the SAG.  
 
Looks like bpflist would work fine for skipping over the last step of
manually parsing the DB files although there's still some filtering
involved.  
 
Still - same caveat as before - it looks like there's no filter of those
fragments of the backupid that are located on other tapes.
 
What's your ultimate goal?  Why try to find files on a specific tape number?
Wouldn't files backed up by client/class/policy usually be better
information?
 
-M
 
bpflist: [-l | -L | -U] [-v]
    [-M master_server...]
    [-d mm/dd/yyyy hh:mm:ss][-e mm/dd/yyyy hh:mm:ss]
    [-ut <unixtime for start and end date>]
    [-st sched_type]
    [-class class_name][-client client_name]
    [-keyword "keyword phrase"][-pattern fullpath]
    [-ct class_type]
    [-user name][-group name][-raw mode]
    [-backupid name][-force_print]
    [-psep path_separator_character]
    [-malgo match_algorithm (0 1 2 or 3)]
    [-rl recursion_level (0..999)]
    [-option <list of:
        NONE ONE_PASS NO_HSHAKE GET_ALL_FILES
        INCLUDE_TIR ONLY_TIR ONLY_DIRS FILESYSTEM_ONLY
        ONE_CONNECT INCLUDE_RAW_INCR INCLUDE_BITMAP INCLUDE_FSMAP
        INCLUDE_EDI IGNORE_CASE INCLUDE_EFI>]


-----Original Message-----
From: David A. Chapa [mailto:david AT datastaff DOT com]
Sent: Wednesday, March 26, 2003 2:39 AM
To: Donaldson, Mark; 'O'Shea, Don'; Veritas-Bu (E-mail)
Subject: RE: [Veritas-bu] CMD Line


why don't you just use bpflist?
 
I'm not in front of an NBU machine right now so I can't give you the exactly
cmd-line, but I would
 
1.  identify the backup IDs (BIDs) that exist on a tape
  <using Mark's example with bpimmedia should work>
 
2.  take those BIDs and run it through bpflist.
 
bpflist -backupid $BID -U
 
I think that should work.
 
David
 

<><><><><><><><><><><><><><><><><><><><>
David A. Chapa
DataStaff, Inc.
312-683-1144
http://www.BackupScripts.com <http://www.backupscripts.com/> 

Co-Author of
Implementing Backup and Recovery:
The Readiness Guide for the Enterprise
published by John Wiley and Sons
A Veritas Solution Series Publication
ISBN:0471227145
--------------------------------------- 

-----Original Message-----
From: veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu]On Behalf Of Donaldson, 
Mark
Sent: Wednesday, March 26, 2003 2:04 PM
To: 'O'Shea, Don'; Veritas-Bu (E-mail)
Subject: RE: [Veritas-bu] CMD Line


Sorry,  this one isn't a simple command-line function - you can get close.
 
You can get images on a tape: 
  bpimmedia -mediaid <tapenum>
 
Filtered to only image ID's:
  bpimmedia -mediaid <tapenum> | awk '$1=="IMAGE" {print $4}'
 
Take the imageid to bpimagelist to get the DB file:
  bpimagelist -backupid <bpid> | awk '$1=="IMAGE" {print $24}'
 
Then go to the DB directly and query the files from there...
/usr/openv/netbackup/db/images/<clientname>/<timestamp>/<db_file> (from
above).
 
This will get you files in an image.  A problem is that an image can span
tapes, so this listing may include files on other tapes.  The fragment
information on bpimmedia could be used to limit to just fragments associated
with this tape number but as of yet, I haven't figured how to cross
reference fragment information to sets of files.
 
Here's an (unix-based) example:
 
$ bpimmedia -mediaid 000010 | awk '$1=="IMAGE" {print $4}'
backup00.lodo.in.exactis.com_1047999896
$ bpimagelist -backupid backup00.lodo.in.exactis.com_1047999896 | awk
'$1=="IMAGE" {print $24}'
Oracle_list1p_1047999896_FULL.f
$ cd /usr/openv/netbackup/db/images/backup00.lodo.in.exactis.com/1047*
$ pwd
/usr/openv/netbackup/db/images/backup00.lodo.in.exactis.com/1047000000
$ zcat Oracle_list1p_1047999896_FULL.f.Z | awk '{print $10}'
/
/u00/
/u00/list1p/
/u00/list1p/arch/
/u00/list1p/arch/list1p_1570.arc
/u01/
<snip>
 
 
-M
 

-----Original Message-----
From: O'Shea, Don [mailto:Don.OShea AT emergis DOT com]
Sent: Wednesday, March 26, 2003 12:24 PM
To: Veritas-Bu (E-mail)
Subject: [Veritas-bu] CMD Line



Does anyone know what the command line command is to execute a report that
would give me exact files backed up to a specific tape. I am trying to do it
through the gui and it takes a long time and I have to do it for a bunch of
tapes. I don't have much time available so I was hoping I could set of a
bunch of instances and pipe it out to a file to distribute to a user.

Thanks, 

Don O'Shea 
BCE Emergis Inc. 
(905)707-4000 Ext 3765 

The information contained herein, including any attachments, is proprietary
and confidential and is intended for the exclusive use of the addressee. It
also may contain privileged information and/or personal information subject
to privacy legislation. The authorized addressee of this information, by its
retention and use, agrees to protect the information contained herein from
loss, disclosure, theft or compromise with at least the same care it employs
to protect its own confidential information. Any dissemination or use of
this information by a person other than the intended recipient is
unauthorized and may be illegal. If you have received this e-mail in error,
please notify us immediately by reply e-mail and destroy all copies.




------_=_NextPart_001_01C2F3EB.1D0CAFB0
Content-Type: text/html;
        charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>CMD Line</TITLE>

<META content="MSHTML 5.50.4923.2500" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN 
class=383173922-26032003>Crud.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN 
class=383173922-26032003></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=383173922-26032003>Just 
when I thought I found them all, there's another undocumented command.&nbsp; No 
"man" page, no entry in the SAG.&nbsp; </SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN 
class=383173922-26032003></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=383173922-26032003>Looks 
like bpflist would work fine for skipping over the last step of manually 
parsing 
the DB files although there's still some filtering involved.&nbsp; 
</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN 
class=383173922-26032003></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=383173922-26032003>Still 
- same caveat as before - it looks like there's no filter&nbsp;of those 
fragments of the backupid that are located on other tapes.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN 
class=383173922-26032003></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN 
class=383173922-26032003>What's 
your ultimate goal?&nbsp; Why try to find files on a specific tape 
number?&nbsp; 
Wouldn't files backed up by client/class/policy usually be better 
information?</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN 
class=383173922-26032003></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN 
class=383173922-26032003>-M</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN 
class=383173922-26032003></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN 
class=383173922-26032003>bpflist: [-l | -L | -U] [-v]<BR>&nbsp;&nbsp;&nbsp; [-M 
master_server...]<BR>&nbsp;&nbsp;&nbsp; [-d mm/dd/yyyy hh:mm:ss][-e mm/dd/yyyy 
hh:mm:ss]<BR>&nbsp;&nbsp;&nbsp; [-ut &lt;unixtime for start and end 
date&gt;]<BR>&nbsp;&nbsp;&nbsp; [-st sched_type]<BR>&nbsp;&nbsp;&nbsp; [-class 
class_name][-client client_name]<BR>&nbsp;&nbsp;&nbsp; [-keyword "keyword 
phrase"][-pattern fullpath]<BR>&nbsp;&nbsp;&nbsp; [-ct 
class_type]<BR>&nbsp;&nbsp;&nbsp; [-user name][-group name][-raw 
mode]<BR>&nbsp;&nbsp;&nbsp; [-backupid 
name][-force_print]<BR>&nbsp;&nbsp;&nbsp; 
[-psep path_separator_character]<BR>&nbsp;&nbsp;&nbsp; [-malgo match_algorithm 
(0 1 2 or 3)]<BR>&nbsp;&nbsp;&nbsp; [-rl recursion_level 
(0..999)]<BR>&nbsp;&nbsp;&nbsp; [-option &lt;list 
of:<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NONE ONE_PASS NO_HSHAKE 
GET_ALL_FILES<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; INCLUDE_TIR 
ONLY_TIR 
ONLY_DIRS FILESYSTEM_ONLY<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
ONE_CONNECT INCLUDE_RAW_INCR INCLUDE_BITMAP 
INCLUDE_FSMAP<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; INCLUDE_EDI 
IGNORE_CASE INCLUDE_EFI&gt;]<BR></SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
  <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma 
  size=2>-----Original Message-----<BR><B>From:</B> David A. Chapa 
  [mailto:david AT datastaff DOT com]<BR><B>Sent:</B> Wednesday, March 26, 2003 
2:39 
  AM<BR><B>To:</B> Donaldson, Mark; 'O'Shea, Don'; Veritas-Bu 
  (E-mail)<BR><B>Subject:</B> RE: [Veritas-bu] CMD Line<BR><BR></FONT></DIV>
  <DIV><SPAN class=425193509-26032003><FONT face=Arial color=#0000ff size=2>why 
  don't you just use bpflist?</FONT></SPAN></DIV>
  <DIV><SPAN class=425193509-26032003><FONT face=Arial color=#0000ff 
  size=2></FONT></SPAN>&nbsp;</DIV>
  <DIV><SPAN class=425193509-26032003><FONT face=Arial color=#0000ff size=2>I'm 
  not in front of an NBU machine right now so I can't give you the exactly 
  cmd-line, but I would</FONT></SPAN></DIV>
  <DIV><SPAN class=425193509-26032003><FONT face=Arial color=#0000ff 
  size=2></FONT></SPAN>&nbsp;</DIV>
  <DIV><SPAN class=425193509-26032003><FONT face=Arial color=#0000ff 
  size=2>1.&nbsp; identify the backup IDs (BIDs) that exist on a 
  tape</FONT></SPAN></DIV>
  <DIV><SPAN class=425193509-26032003><FONT face=Arial color=#0000ff 
  size=2>&nbsp; &lt;using Mark's example with bpimmedia should 
  work&gt;</FONT></SPAN></DIV>
  <DIV><SPAN class=425193509-26032003><FONT face=Arial color=#0000ff 
  size=2></FONT></SPAN>&nbsp;</DIV>
  <DIV><SPAN class=425193509-26032003><FONT face=Arial color=#0000ff 
  size=2>2.&nbsp; take those BIDs and run it through 
bpflist.</FONT></SPAN></DIV>
  <DIV><SPAN class=425193509-26032003><FONT face=Arial color=#0000ff 
  size=2></FONT></SPAN>&nbsp;</DIV>
  <DIV><SPAN class=425193509-26032003><FONT face=Arial color=#0000ff 
  size=2>bpflist -backupid $BID -U</FONT></SPAN></DIV>
  <DIV><SPAN class=425193509-26032003><FONT face=Arial color=#0000ff 
  size=2></FONT></SPAN>&nbsp;</DIV>
  <DIV><SPAN class=425193509-26032003><FONT face=Arial color=#0000ff size=2>I 
  think that should work.</FONT></SPAN></DIV>
  <DIV><SPAN class=425193509-26032003><FONT face=Arial color=#0000ff 
  size=2></FONT></SPAN>&nbsp;</DIV>
  <DIV><SPAN class=425193509-26032003><FONT face=Arial color=#0000ff 
  size=2>David</FONT></SPAN></DIV>
  <DIV>&nbsp;</DIV>
  <P><FONT 
  
size=2>&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;&lt;&gt;<BR>David
 
  A. Chapa<BR>DataStaff, Inc.<BR>312-683-1144<BR><A target=_blank 
  
href="http://www.backupscripts.com/";>http://www.BackupScripts.com</A><BR><BR>Co-Author
 
  of<BR>Implementing Backup and Recovery:<BR>The Readiness Guide for the 
  Enterprise<BR>published by John Wiley and Sons<BR>A Veritas Solution Series 
  
Publication<BR>ISBN:0471227145<BR>---------------------------------------</FONT>
 
  </P>
  <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
    <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma 
    size=2>-----Original Message-----<BR><B>From:</B> 
    veritas-bu-admin AT mailman.eng.auburn DOT edu 
    [mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu]<B>On Behalf Of 
    </B>Donaldson, Mark<BR><B>Sent:</B> Wednesday, March 26, 2003 2:04 
    PM<BR><B>To:</B> 'O'Shea, Don'; Veritas-Bu (E-mail)<BR><B>Subject:</B> RE: 
    [Veritas-bu] CMD Line<BR><BR></FONT></DIV>
    <DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff 
    size=2>Sorry,&nbsp; this one isn't a simple command-line function - you can 
    get close.</FONT></SPAN></DIV>
    <DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff 
    size=2></FONT></SPAN>&nbsp;</DIV>
    <DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff 
    size=2>You can get images on a tape: </FONT></SPAN></DIV>
    <DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff 
    size=2>&nbsp; bpimmedia -mediaid &lt;tapenum&gt;</FONT></SPAN></DIV>
    <DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff 
    size=2></FONT></SPAN>&nbsp;</DIV>
    <DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff 
    size=2>Filtered to only image ID's:</FONT></SPAN></DIV>
    <DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff 
    size=2>&nbsp; bpimmedia -mediaid &lt;tapenum&gt; | awk '$1=="IMAGE" {print 
    $4}'</FONT></SPAN></DIV>
    <DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff 
    size=2></FONT></SPAN>&nbsp;</DIV>
    <DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff 
    size=2>Take the imageid to bpimagelist to get the DB 
    file:</FONT></SPAN></DIV>
    <DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff 
    size=2>&nbsp; bpimagelist -backupid &lt;bpid&gt; | awk '$1=="IMAGE" {print 
    $24}'</FONT></SPAN></DIV>
    <DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff 
    size=2></FONT></SPAN>&nbsp;</DIV>
    <DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff 
    size=2>Then go to the DB directly and query the files from 
    there...</FONT></SPAN></DIV>
    <DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff 
    
size=2>/usr/openv/netbackup/db/images/&lt;clientname&gt;/&lt;timestamp&gt;/&lt;db_file&gt;
 
    (from above).</FONT></SPAN></DIV>
    <DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff 
    size=2></FONT></SPAN>&nbsp;</DIV>
    <DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff 
    size=2>This will get you files in an image.&nbsp; <EM>A problem is that an 
    image can span tapes, so this listing may include files on other 
    tapes.</EM>&nbsp; The fragment information on bpimmedia could be used to 
    limit to just fragments associated with this tape number but as of yet, I 
    haven't figured how to cross reference fragment information to sets of 
    files.</FONT></SPAN></DIV>
    <DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff 
    size=2></FONT></SPAN>&nbsp;</DIV>
    <DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff 
    size=2>Here's an (unix-based)&nbsp;example:</FONT></SPAN></DIV>
    <DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff 
    size=2></FONT></SPAN>&nbsp;</DIV>
    <DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff 
    size=2>$&nbsp;bpimmedia -mediaid 000010 | awk '$1=="IMAGE" {print 
    $4}'<BR>backup00.lodo.in.exactis.com_1047999896<BR>$&nbsp;bpimagelist 
    -backupid backup00.lodo.in.exactis.com_1047999896 | awk '$1=="IMAGE" {print 
    $24}'<BR>Oracle_list1p_1047999896_FULL.f<BR>$ cd 
    /usr/openv/netbackup/db/images/backup00.lodo.in.exactis.com/1047*<BR>$ 
    
pwd<BR>/usr/openv/netbackup/db/images/backup00.lodo.in.exactis.com/1047000000<BR>$&nbsp;zcat
 
    Oracle_list1p_1047999896_FULL.f.Z | awk '{print 
    
$10}'<BR>/<BR>/u00/<BR>/u00/list1p/<BR>/u00/list1p/arch/<BR>/u00/list1p/arch/list1p_1570.arc<BR>/u01/<BR>&lt;snip&gt;</FONT></SPAN></DIV>
    <DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff 
    size=2></FONT></SPAN>&nbsp;</DIV>
    <DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff 
    size=2></FONT></SPAN>&nbsp;</DIV>
    <DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff 
    size=2>-M</FONT></SPAN></DIV>
    <DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff 
    size=2></FONT></SPAN>&nbsp;</DIV>
    <BLOCKQUOTE>
      <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma 
      size=2>-----Original Message-----<BR><B>From:</B> O'Shea, Don 
      [mailto:Don.OShea AT emergis DOT com]<BR><B>Sent:</B> Wednesday, March 
26, 2003 
      12:24 PM<BR><B>To:</B> Veritas-Bu (E-mail)<BR><B>Subject:</B> 
[Veritas-bu] 
      CMD Line<BR><BR></FONT></DIV>
      <P><FONT face=Arial size=2>Does anyone know what the command line command 
      is to execute a report that would give me exact files backed up to a 
      specific tape. I am trying to do it through the gui and it takes a long 
      time and I have to do it for a bunch of tapes. I don't have much time 
      available so I was hoping I could set of a bunch of instances and pipe it 
      out to a file to distribute to a user.</FONT></P>
      <P><FONT face=Arial size=2>Thanks,</FONT> </P>
      <P><FONT face=Arial size=2>Don O'Shea</FONT> <BR><FONT face=Arial 
      size=2>BCE Emergis Inc.</FONT> <BR><FONT face=Arial size=2>(905)707-4000 
      Ext 3765</FONT> </P>
      <P><FONT face=Arial size=2>The information contained herein, including 
any 
      attachments, is proprietary and confidential and is intended for the 
      exclusive use of the addressee. It also may contain privileged 
information 
      and/or personal information subject to privacy legislation. The 
authorized 
      addressee of this information, by its retention and use, agrees to 
protect 
      the information contained herein from loss, disclosure, theft or 
      compromise with at least the same care it employs to protect its own 
      confidential information. Any dissemination or use of this information by 
      a person other than the intended recipient is unauthorized and may be 
      illegal. If you have received this e-mail in error, please notify us 
      immediately by reply e-mail and destroy all 
    
copies.</FONT></P><BR><BR></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C2F3EB.1D0CAFB0--

<Prev in Thread] Current Thread [Next in Thread>