[NERDug-list] Colleague AIX/UniData Backup Question

[Andrew Crawford]

Thanks, Jeff. Have you ever had issues with unmounting the snapshots or
recovery from snapshots?

To the larger community - is anyone using the snapshot functionality with
AIX 7.1? We had significant difficulty with snapshots using earlier
versions of AIX, where the nightly snapshots would not unmount correctly,
and would persist into the work day. This caused performance problems and
ultimately lead to our current backup configuration. It would be good to
hear from folks who have had success with our particular version of AIX.

Thanks,

Andrew Crawford
Director for Systems Architecture and Management
Berklee College of Music
Boston, MA
Office - (617) 747-6295
Cell - (617) 480-1221

On Wed, Sep 16, 2015 at 1:34 PM, Jeffrey Butera <jbutera at hampshire.edu>
wrote:

> 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/20150917/279b3a0d/attachment.html>