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> </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. No
"man" page, no entry in the SAG. </SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=383173922-26032003></SPAN></FONT> </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.
</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=383173922-26032003></SPAN></FONT> </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 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> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=383173922-26032003>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?</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=383173922-26032003></SPAN></FONT> </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> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=383173922-26032003>bpflist: [-l | -L | -U] [-v]<BR> [-M
master_server...]<BR> [-d mm/dd/yyyy hh:mm:ss][-e mm/dd/yyyy
hh:mm:ss]<BR> [-ut <unixtime for start and end
date>]<BR> [-st sched_type]<BR> [-class
class_name][-client client_name]<BR> [-keyword "keyword
phrase"][-pattern fullpath]<BR> [-ct
class_type]<BR> [-user name][-group name][-raw
mode]<BR> [-backupid
name][-force_print]<BR>
[-psep path_separator_character]<BR> [-malgo match_algorithm
(0 1 2 or 3)]<BR> [-rl recursion_level
(0..999)]<BR> [-option <list
of:<BR> NONE ONE_PASS NO_HSHAKE
GET_ALL_FILES<BR> INCLUDE_TIR
ONLY_TIR
ONLY_DIRS FILESYSTEM_ONLY<BR>
ONE_CONNECT INCLUDE_RAW_INCR INCLUDE_BITMAP
INCLUDE_FSMAP<BR> INCLUDE_EDI
IGNORE_CASE INCLUDE_EFI>]<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> </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> </DIV>
<DIV><SPAN class=425193509-26032003><FONT face=Arial color=#0000ff
size=2>1. 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> <using Mark's example with bpimmedia should
work></FONT></SPAN></DIV>
<DIV><SPAN class=425193509-26032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=425193509-26032003><FONT face=Arial color=#0000ff
size=2>2. 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> </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> </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> </DIV>
<DIV><SPAN class=425193509-26032003><FONT face=Arial color=#0000ff
size=2>David</FONT></SPAN></DIV>
<DIV> </DIV>
<P><FONT
size=2><><><><><><><><><><><><><><><><><><><><><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, 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> </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> bpimmedia -mediaid <tapenum></FONT></SPAN></DIV>
<DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </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> bpimmedia -mediaid <tapenum> | awk '$1=="IMAGE" {print
$4}'</FONT></SPAN></DIV>
<DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </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> bpimagelist -backupid <bpid> | awk '$1=="IMAGE" {print
$24}'</FONT></SPAN></DIV>
<DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </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/<clientname>/<timestamp>/<db_file>
(from above).</FONT></SPAN></DIV>
<DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff
size=2>This will get you files in an image. <EM>A problem is that an
image can span tapes, so this listing may include files on other
tapes.</EM> 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> </DIV>
<DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff
size=2>Here's an (unix-based) example:</FONT></SPAN></DIV>
<DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff
size=2>$ bpimmedia -mediaid 000010 | awk '$1=="IMAGE" {print
$4}'<BR>backup00.lodo.in.exactis.com_1047999896<BR>$ 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>$ 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><snip></FONT></SPAN></DIV>
<DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=514143519-26032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </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> </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--
|