Veritas-bu

[Veritas-bu] CMD Line

2003-03-26 15:03:47
Subject: [Veritas-bu] CMD Line
From: Mark.Donaldson AT experianems DOT com (Donaldson, Mark)
Date: Wed, 26 Mar 2003 13:03:47 -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_01C2F3D2.CFF16260
Content-Type: text/plain;
        charset="iso-8859-1"

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_01C2F3D2.CFF16260
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><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></BODY></HTML>

------_=_NextPart_001_01C2F3D2.CFF16260--

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