<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div><span style="color: rgba(0, 0, 0, 0.701961); -webkit-composition-fill-color: rgba(130, 98, 83, 0.0980392); text-decoration: -webkit-letterpress;">Hi Andrew</span><div style="color: rgba(0, 0, 0, 0.701961); -webkit-composition-fill-color: rgba(130, 98, 83, 0.0980392); text-decoration: -webkit-letterpress;"><br></div><div style="color: rgba(0, 0, 0, 0.701961); -webkit-composition-fill-color: rgba(130, 98, 83, 0.0980392); text-decoration: -webkit-letterpress;">The best way to manage this is using files system snapshots in that it results in the shortest downtime. We do the following:</div><div style="color: rgba(0, 0, 0, 0.701961); -webkit-composition-fill-color: rgba(130, 98, 83, 0.0980392); text-decoration: -webkit-letterpress;"><br></div><div style="color: rgba(0, 0, 0, 0.701961); -webkit-composition-fill-color: rgba(130, 98, 83, 0.0980392); text-decoration: -webkit-letterpress;">1. dbpause and wait 2 second to allow unidata transactions in flight to complete.</div><div style="color: rgba(0, 0, 0, 0.701961); -webkit-composition-fill-color: rgba(130, 98, 83, 0.0980392); text-decoration: -webkit-letterpress;"><br></div><div style="color: rgba(0, 0, 0, 0.701961); -webkit-composition-fill-color: rgba(130, 98, 83, 0.0980392); text-decoration: -webkit-letterpress;">2. Take snapshot of filesystem using O/S tools. Takes about 2 seconds.</div><div style="color: rgba(0, 0, 0, 0.701961); -webkit-composition-fill-color: rgba(130, 98, 83, 0.0980392); text-decoration: -webkit-letterpress;"><br></div><div style="color: rgba(0, 0, 0, 0.701961); -webkit-composition-fill-color: rgba(130, 98, 83, 0.0980392); text-decoration: -webkit-letterpress;">3. Issue dbresume to resume unidata. Total downtime is under 5 seconds.</div><div style="color: rgba(0, 0, 0, 0.701961); -webkit-composition-fill-color: rgba(130, 98, 83, 0.0980392); text-decoration: -webkit-letterpress;"><br></div><div style="color: rgba(0, 0, 0, 0.701961); -webkit-composition-fill-color: rgba(130, 98, 83, 0.0980392); text-decoration: -webkit-letterpress;">4. Perform backup from snapshot.</div><div style="color: rgba(0, 0, 0, 0.701961); -webkit-composition-fill-color: rgba(130, 98, 83, 0.0980392); text-decoration: -webkit-letterpress;"><br></div><div style="color: rgba(0, 0, 0, 0.701961); -webkit-composition-fill-color: rgba(130, 98, 83, 0.0980392); text-decoration: -webkit-letterpress;">5. Trash snapshot.</div><div style="color: rgba(0, 0, 0, 0.701961); -webkit-composition-fill-color: rgba(130, 98, 83, 0.0980392); text-decoration: -webkit-letterpress;"><br></div><br><div style="line-height: 24px; -webkit-tap-highlight-color: rgba(26, 26, 26, 0.296875); -webkit-composition-fill-color: rgba(130, 98, 83, 0.0976563); -webkit-composition-frame-color: rgba(191, 107, 82, 0.496094); ">Jeffrey Butera, PhD</div><div style="line-height: 24px; -webkit-tap-highlight-color: rgba(26, 26, 26, 0.296875); -webkit-composition-fill-color: rgba(130, 98, 83, 0.0976563); -webkit-composition-frame-color: rgba(191, 107, 82, 0.496094); ">Associate Director for Application and Web Services </div><div style="line-height: 24px; -webkit-tap-highlight-color: rgba(26, 26, 26, 0.296875); -webkit-composition-fill-color: rgba(130, 98, 83, 0.0976563); -webkit-composition-frame-color: rgba(191, 107, 82, 0.496094); ">Information Technology </div><div style="line-height: 24px; -webkit-tap-highlight-color: rgba(26, 26, 26, 0.296875); -webkit-composition-fill-color: rgba(130, 98, 83, 0.0976563); -webkit-composition-frame-color: rgba(191, 107, 82, 0.496094); ">Hampshire College</div><div style="line-height: 24px; -webkit-tap-highlight-color: rgba(26, 26, 26, 0.296875); -webkit-composition-fill-color: rgba(130, 98, 83, 0.0976563); -webkit-composition-frame-color: rgba(191, 107, 82, 0.496094); ">413-559-5556</div></div><div><br>On Sep 16, 2015, at 12:51 PM, Andrew Crawford <<a href="mailto:abcrawford@berklee.edu">abcrawford@berklee.edu</a>> wrote:<br><br></div><blockquote type="cite"><div><div dir="ltr"><div>Hi there,</div><div><br></div><div>Here at Berklee we're running AIX version 7.1.0.0 and UniData v7.2.12 as the back-end for our Ellucian Colleague environment. We'd like to better understand what other schools with the same configuration are doing relative to backup/recovery.</div><div><br></div><div>Currently, we're pausing the database on a nightly basis and making a copy (rsync) while UniData is paused, which takes about 3 hours. It would be helpful to understand how other schools, with the same infrastructure back-end, are conducting their backups and the strategies being used to reduce Colleague downtime to a target of 10 seconds.</div><div><br></div><div>Thanks in advance,</div><div><br></div>Andrew Crawford<br>Director for Systems Architecture and Management<br>Berklee College of Music<br>Boston, MA<br>Office - (617) 747-6295<br>Cell - (617) 480-1221</div>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>NERDug-list mailing list</span><br><span><a href="mailto:NERDug-list@lists.hampshire.edu">NERDug-list@lists.hampshire.edu</a></span><br><span><a href="https://lists.hampshire.edu/mailman/listinfo/nerdug-list">https://lists.hampshire.edu/mailman/listinfo/nerdug-list</a></span><br></div></blockquote></body></html>