Veritas-bu

[Veritas-bu] bpdbjobs

2002-07-22 19:47:08
Subject: [Veritas-bu] bpdbjobs
From: Mark.Donaldson AT experianems DOT com (Donaldson, Mark)
Date: Mon, 22 Jul 2002 17:47:08 -0600
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_01C231DA.178F6420
Content-Type: text/plain

There's a small fault.  Change this line:


Before:
svrlist=`bperror -columns $cols -U -backstat -by_statcode -hoursago $hours |
\
     awk 'BEGIN {switch=0}
          {if ( $1>0 && $1~/^[0-9][0-9]*$/ ) {switch=1}
           if ( switch==1 && $1!~/^[0-9][0-9]*$/) {print} }'`


After:
svrlist=`bperror -columns $cols -U -backstat -by_statcode -hoursago $hours |
\
     awk 'BEGIN {switch=0}
          {if ( $1>0 && $1~/^[0-9][0-9]*$/ ) {switch=1}
           if ( switch==1 && $1!~/^[0-9][0-9]*$/) {print} }' | sort -u`


The report, by the way, looks like this:


## Problem Summary...
  1   the requested operation was partially successful
                backup00.prod.exactis.com
 85   media read error
                backup00.prod.exactis.com
213   no storage units available for use
                app00.prod.exactis.com
                app01.prod.exactis.com

## Problem Detail by server...

## Client: backup00.prod.exactis.com
    TIME            SERVER/CLIENT                      TEXT
07/19/2002 08:35:53 backup00.prod.infobeat.com backup00.prod.exactis.com
read error
                    on media id 000208, drive index 0, reading header block,
I/O error
07/19/2002 08:35:55 backup00 backup00.prod.exactis.com  from client
                    backup00.prod.exactis.com: ERR - bpbkar exiting because
backup is
                    aborting
07/19/2002 08:35:59 backup00.prod.infobeat.com backup00.prod.exactis.com
backup of
                    client backup00.prod.exactis.com exited with status 85
(media read
                    error)
07/19/2002 18:20:49 backup00 backup00.prod.exactis.com  from client
                    backup00.prod.exactis.com: ERR - Cannot lstat64
                    /u01/oradata/ods1p/ods_x07.dbf. Errno = 6: No such
device or address
<snip>

## Client: app00.prod.exactis.com
    TIME            SERVER/CLIENT                      TEXT
07/19/2002 17:32:48 backup00 app00.prod.exactis.com  All storage units NOT
set for
                    on-demand-only usage are currently unavailable.  Class
Epin_System,
                    sched Incr does not require a specific storage unit.

## Client: app01.prod.exactis.com
    TIME            SERVER/CLIENT                      TEXT
07/19/2002 17:32:50 backup00 app01.prod.exactis.com  All storage units NOT
set for
                    on-demand-only usage are currently unavailable.  Class
Epin_System,
                    sched Incr does not require a specific storage unit.



----Original Message-----
From: Donaldson, Mark [ mailto:Mark.Donaldson AT experianems DOT com
<mailto:Mark.Donaldson AT experianems DOT com> ]
Sent: Monday, July 22, 2002 5:12 PM
To: 'Glancey, John [CNTUS - NON J&J]'; veritas-bu AT mailman.eng.auburn DOT edu
Subject: RE: [Veritas-bu] bpdbjobs


bperror can generate reports for an "-hoursago" value.  I generate a nightly
report set to myself for the previous 24 hours.  Here's the script, the
first part generates a media report, the second part generates a summary of
backup codes (per code) then breaks it down by client.
Here's the script (note - change the mail address)

<snip> 


------_=_NextPart_001_01C231DA.178F6420
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<TITLE></TITLE>

<META content=3D"MSHTML 6.00.2716.2200" name=3DGENERATOR></HEAD>
<BODY>
<P><FONT size=3D2>There's a small fault.&nbsp; Change this =
line:</FONT></P>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px"><FONT size=3D2>
  <P><BR>Before:<BR>svrlist=3D`bperror -columns $cols -U -backstat =
-by_statcode=20
  -hoursago $hours | \<BR>&nbsp;&nbsp;&nbsp;&nbsp; awk 'BEGIN=20
  =
{switch=3D0}<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
{if (=20
  $1&gt;0 &amp;&amp; $1~/^[0-9][0-9]*$/ )=20
  =
{switch=3D1}<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp; if=20
  ( switch=3D=3D1 &amp;&amp; $1!~/^[0-9][0-9]*$/) {print} }'`</P>
  <P><BR>After:<BR>svrlist=3D`bperror -columns $cols -U -backstat =
-by_statcode=20
  -hoursago $hours | \<BR>&nbsp;&nbsp;&nbsp;&nbsp; awk 'BEGIN=20
  =
{switch=3D0}<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
{if (=20
  $1&gt;0 &amp;&amp; $1~/^[0-9][0-9]*$/ )=20
  =
{switch=3D1}<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp; if=20
  ( switch=3D=3D1 &amp;&amp; $1!~/^[0-9][0-9]*$/) {print} }<FONT=20
  color=3D#ff0000><STRONG><FONT color=3D#000000>'</FONT> | sort=20
-u`<BR></P></BLOCKQUOTE></STRONG></FONT></FONT><FONT =
size=3D2><STRONG><FONT=20
color=3D#ff0000></FONT></STRONG>
<P>The report, by the way, looks like this:<BR></P>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
  <P>## Problem Summary...<BR>&nbsp; 1&nbsp;&nbsp; the requested =
operation was=20
  partially=20
  =
successful<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  backup00.prod.exactis.com<BR>&nbsp;85&nbsp;&nbsp; media read=20
  =
error<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  backup00.prod.exactis.com<BR>213&nbsp;&nbsp; no storage units =
available for=20
  =
use<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;=20
  =
app00.prod.exactis.com<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  app01.prod.exactis.com<BR><BR>## Problem Detail by =
server...<BR><BR>## Client:=20
  backup00.prod.exactis.com<BR>&nbsp;&nbsp;&nbsp;=20
  =
TIME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  =
SERVER/CLIENT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  TEXT<BR>07/19/2002 08:35:53 backup00.prod.infobeat.com=20
  backup00.prod.exactis.com&nbsp; read=20
  =
error<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  on media id 000208, drive index 0, reading header block, I/O=20
  error<BR>07/19/2002 08:35:55 backup00 backup00.prod.exactis.com&nbsp; =
from=20
  =
client<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  backup00.prod.exactis.com: ERR - bpbkar exiting because backup=20
  =
is<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  aborting<BR>07/19/2002 08:35:59 backup00.prod.infobeat.com=20
  backup00.prod.exactis.com&nbsp; backup=20
  =
of<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  client backup00.prod.exactis.com exited with status 85 (media=20
  =
read<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  error)<BR>07/19/2002 18:20:49 backup00 =
backup00.prod.exactis.com&nbsp; from=20
  =
client<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  backup00.prod.exactis.com: ERR - Cannot=20
  =
lstat64<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  /u01/oradata/ods1p/ods_x07.dbf. Errno =3D 6: No such device or=20
  address<BR>&lt;snip&gt;<BR><BR>## Client:=20
  app00.prod.exactis.com<BR>&nbsp;&nbsp;&nbsp;=20
  =
TIME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  =
SERVER/CLIENT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  TEXT<BR>07/19/2002 17:32:48 backup00 app00.prod.exactis.com&nbsp; All =
storage=20
  units NOT set=20
  =
for<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  on-demand-only usage are currently unavailable.&nbsp; Class=20
  =
Epin_System,<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  sched Incr does not require a specific storage unit.<BR><BR>## =
Client:=20
  app01.prod.exactis.com<BR>&nbsp;&nbsp;&nbsp;=20
  =
TIME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  =
SERVER/CLIENT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  TEXT<BR>07/19/2002 17:32:50 backup00 app01.prod.exactis.com&nbsp; All =
storage=20
  units NOT set=20
  =
for<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  on-demand-only usage are currently unavailable.&nbsp; Class=20
  =
Epin_System,<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  sched Incr does not require a specific storage =
unit.<BR></P></BLOCKQUOTE>
<P><BR>----Original Message-----<BR>From: Donaldson, Mark [<A=20
href=3D"mailto:Mark.Donaldson AT experianems DOT com">mailto:Mark.Donaldson@exp=
erianems.com</A>]<BR>Sent:=20
Monday, July 22, 2002 5:12 PM<BR>To: 'Glancey, John [CNTUS - NON =
J&amp;J]';=20
veritas-bu AT mailman.eng.auburn DOT edu<BR>Subject: RE: [Veritas-bu]=20
bpdbjobs<BR><BR><BR>bperror can generate reports for an "-hoursago" =
value.&nbsp;=20
I generate a nightly report set to myself for the previous 24 =
hours.&nbsp;=20
Here's the script, the first part generates a media report, the second =
part=20
generates a summary of backup codes (per code) then breaks it down by=20
client.<BR>Here's the script (note - change the mail=20
address)<BR><BR>&lt;snip&gt; </FONT></P></BODY></HTML>

------_=_NextPart_001_01C231DA.178F6420--

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