[NERDug-list] Colleague AIX/UniData Backup Question

[Jeffrey Butera]

Hi Andrew

The best way to manage this is using files system snapshots in that it results in the shortest downtime.  We do the following:

1. dbpause and wait 2 second to allow unidata transactions in flight to complete.

2. Take snapshot of filesystem using O/S tools. Takes about 2 seconds.

3. Issue dbresume to resume unidata. Total downtime is under 5 seconds.

4. Perform backup from snapshot.

5. Trash snapshot.


Jeffrey Butera, PhD
Associate Director for Application and Web Services 
Information Technology 
Hampshire College
413-559-5556

> On Sep 16, 2015, at 12:51 PM, Andrew Crawford <abcrawford at berklee.edu> wrote:
> 
> Hi there,
> 
> 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.
> 
> 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.
> 
> Thanks in advance,
> 
> Andrew Crawford
> Director for Systems Architecture and Management
> Berklee College of Music
> Boston, MA
> Office - (617) 747-6295
> Cell - (617) 480-1221
> _______________________________________________
> NERDug-list mailing list
> NERDug-list at lists.hampshire.edu
> https://lists.hampshire.edu/mailman/listinfo/nerdug-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.hampshire.edu/pipermail/nerdug-list/attachments/20150916/77887b8f/attachment.html>