defaria.com/blogs/Status/archives/week_2004_06_20.html

   1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
   2    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
   3 <html xmlns="http://www.w3.org/1999/xhtml" id="sixapart-standard">
   4 <head>
   5    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
   6    <meta name="generator" content="Movable Type 5.2.3" />
   7
   8    <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles-site.css" type="text/css" />
   9    <link rel="alternate" type="application/atom+xml" title="Atom" href="http://defaria.com/blogs/Status/atom.xml" />
  10    <link rel="alternate" type="application/rss+xml" title="RSS 2.0" href="http://defaria.com/blogs/Status/index.xml"$>" />
  11
  12    <title>Status for Andrew DeFaria: June 20, 2004 - June 26, 2004 Archives</title>
  13
  14    <link rel="start" href="http://defaria.com/blogs/Status/" title="Home" />
  15    <link rel="prev" href="http://defaria.com/blogs/Status/archives/week_2004_06_13.html" title="June 13, 2004 - June 19, 2004" />
  16    <link rel="next" href="http://defaria.com/blogs/Status/archives/week_2004_06_27.html" title="June 27, 2004 - July  3, 2004" />
  17 </head>
  18 <body class="layout-one-column">
  19    <div id="container">
  20       <div id="container-inner" class="pkg">
  21
  22          <div id="banner">
  23             <div id="banner-inner" class="pkg">
  24                <h1 id="banner-header"><a href="http://defaria.com/blogs/Status/" accesskey="1">Status for Andrew DeFaria</a></h1>
  25                <h2 id="banner-description">Searchable status reports and work log</h2>
  26             </div>
  27          </div>
  28
  29          <div id="pagebody">
  30             <div id="pagebody-inner" class="pkg">
  31                <div id="alpha">
  32                   <div id="alpha-inner" class="pkg">
  33
  34                      <p class="content-nav">
  35                         <a href="http://defaria.com/blogs/Status/archives/week_2004_06_13.html">&laquo; June 13, 2004 - June 19, 2004</a> |
  36                         <a href="http://defaria.com/blogs/Status/">Main</a>
  37                         | <a href="http://defaria.com/blogs/Status/archives/week_2004_06_27.html">June 27, 2004 - July  3, 2004 &raquo;</a>
  38                      </p>
  39
  40
  41
  42
  43                      <h2 class="date-header">June 25, 2004</h2>
  44                      <a id="a000205"></a>
  45                      <div class="entry" id="entry-205">
  46                         <h3 class="entry-header">Finished backup script</h3>
  47                         <div class="entry-content">
  48                            <div class="entry-body">
  49                               <p>The backup script is ready for deployment. It was determined to lock all vobs at once, back them all up then unlock the vobs. I also implemented the 7 days of history option. History is stored under d:\vobstore\backup as numbered directories (0-6 for Sun-Sat). The script now manages that area by first moving the current backup under d:\backup -> d:\vobstore\backup\<current day #> after first clearing out d:\vobstore\backup\<current day #> (if it existed). It was decided to put the history stuff under vobstore because this way we can tell the backup people "Just exclude d:\vobstore but get everything else".</p>
  50
  51 <p>I was experiencing "Access denied" errors irradically until I found out that there may be .being-deleted files as described <a href="http://www-1.ibm.com/support/docview.wss?rs=0&q1=being-deleted&uid=swg21129318&loc=en_US&cs=utf-8&cc=us&lang=en">here</a>. To solve this I implemented exclusions on the xcopy command (/exclude:d:\backup\exclude.strings) which tells xcopy to exclude things in the "c" directory - i.e. the cleartext pool - which Clearcase can easily recreate without data loss. This also has the effect of reducing the backup copy size in some cases significantly (e.g. \ASAP_Docs goes from 2.1 gig down to 1 gig!).</p>
  52
  53 <p>Here's a rough psuedo code of what the script does:</p>
  54
  55 <div id="code">
  56 <pre>
  57 Obtain a list of all vobs
  58 Lock all vobs
  59 foreach @vobs
  60   if d:\vobstore\backup\$current_day\$vob exists then
  61     remove it
  62   end if
  63   move d:\backup\$vob -> d:\vobstore\backup\$current_day\$vob
  64   copy $vob's storage area -> d:\backup\$vob
  65 Next
  66 Unlock all vobs
  67 </pre>
  68 </div>
  69 <p>Cutting out the copying of cleartext pool has reduced the current backup time from 56 minutes (yes it grew) to 33 minutes.</p>
  70
  71 <p>Now, where are we WRT the SQL backup scripts?....</p>
  72
  73                               <p class="entry-footer">
  74                                  <span class="post-footers">Posted by  at  3:37 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000205.html">Permalink</a>
  75
  76
  77                               </p>
  78                            </div>
  79                         </div>
  80                      </div>
  81
  82
  83
  84                      <h2 class="date-header">June 23, 2004</h2>
  85                      <a id="a000202"></a>
  86                      <div class="entry" id="entry-202">
  87                         <h3 class="entry-header">Multisite/backup.pl</h3>
  88                         <div class="entry-content">
  89                            <div class="entry-body">
  90                               <p>Spent some time trying to multisite a test vob (\defaria). Realized that we will have a problem in that we will need a machine (server or client) dedicated to handling the multisite region in order to lock vobs and backup things.</p>
  91
  92 <p>Had a meeting WRT multisite approach. It was determined that will we switch to using a script to make a copy of the vobs and back up from there. Started writing script...</p>
  93
  94                               <p class="entry-footer">
  95                                  <span class="post-footers">Posted by  at  9:21 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000202.html">Permalink</a>
  96
  97
  98                               </p>
  99                            </div>
 100                         </div>
 101                      </div>
 102
 103
 104
 105                      <h2 class="date-header">June 21, 2004</h2>
 106                      <a id="a000204"></a>
 107                      <div class="entry" id="entry-204">
 108                         <h3 class="entry-header">XML</h3>
 109                         <div class="entry-content">
 110                            <div class="entry-body">
 111                               <p>Spent most of the day investigating XML and XSL.</p>
 112
 113                               <p class="entry-footer">
 114                                  <span class="post-footers">Posted by  at  9:29 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000204.html">Permalink</a>
 115
 116
 117                               </p>
 118                            </div>
 119                         </div>
 120                      </div>
 121
 122                   </div>
 123                </div>
 124             </div>
 125          </div>
 126       </div>
 127    </div>
 128 </body>
 129 </html>