Veritas-bu

[Veritas-bu] CMD Line

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

The problem here is that you can't restore by tape number nor backup-id.
You can only restore by path/class/sched/etc.  If you're going to do that,
then you can use bplist to identify the files rather than try to restore
them.  bplist takes most of the same command-line elements.
 
-M

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


This is not going to be an easy process I see. It may be easier just to
initiate a restore of a known file that was backed up and let Netbackup tell
me what files it backed up from that day for a particular client. 
 
Don

-----Original Message-----
From: Donaldson, Mark [mailto:Mark.Donaldson AT experianems DOT com]
Sent: Wednesday, March 26, 2003 15:04
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_01C2F3E7.5FC360F0
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=830232922-26032003><FONT face=Arial color=#0000ff size=2>The 
problem here is that you can't restore by tape number nor backup-id.&nbsp; You 
can only restore by path/class/sched/etc.&nbsp; If you're going to do that, 
then 
you can use bplist to identify the files rather than try to restore them.&nbsp; 
bplist takes most of the same command-line elements.</FONT></SPAN></DIV>
<DIV><SPAN class=830232922-26032003><FONT face=Arial color=#0000ff 
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=830232922-26032003><FONT face=Arial color=#0000ff 
size=2>-M</FONT></SPAN></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> O'Shea, Don 
  [mailto:Don.OShea AT emergis DOT com]<BR><B>Sent:</B> Wednesday, March 26, 
2003 3:14 
  PM<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=002001022-26032003><FONT face=Arial color=#0000ff 
size=2>This 
  is not going to be an easy process I see. It may be easier just to initiate a 
  restore of a known file that was backed up and let Netbackup tell me what 
  files it backed up from that day for a particular client. </FONT></SPAN></DIV>
  <DIV><SPAN class=002001022-26032003><FONT face=Arial color=#0000ff 
  size=2></FONT></SPAN>&nbsp;</DIV>
  <DIV><SPAN class=002001022-26032003><FONT face=Arial color=#0000ff 
  size=2>Don</FONT></SPAN></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> Donaldson, Mark 
    [mailto:Mark.Donaldson AT experianems DOT com]<BR><B>Sent:</B> Wednesday, 
March 26, 
    2003 15:04<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_01C2F3E7.5FC360F0--

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