[plug] Disaster recovery utilities for *nix

[Anne Busby]

CSAM is transaction based.  We are looking at log shipping however the
recovery process would be manual (ie replay logs and reinitialize app and
domain settings) and in the event of a disaster (given the client has little
*nix skills) are seeking a more 'automated' process (off the shelf might be
better term).

On 1/24/07, Bernd Felsche <bernie at innovative.iinet.net.au> wrote:
>
> "Anne Busby" <anne.busby at gmail.com> writes:
>
> >I have been asked the following :
>
> >Has anyone come across a Business Continuity Solution for CSAM (ie
> Pronto).
> >We need to minimize both down time and potential data loss that might
> occur
> >during a time of 'disaster'  We are looking at VM'ing and snap shot
> copying
> >across dark fibre however are under the impression that the platform we
> have
> >(P-Series IBM) wont support VM.  Is there a native unix/linux DR
> mechanism
> >we can use?
>
> >What do people use ???
>
> On a transaction-based system; transaction log transfers (or
> mirrors) for the database(s). This can usually be done as often as
> once a minute. Using something like rsync makes it possible to
> have the backup at a remote location; connected at low bandwidth.
> 128kbps has historically been used successfully on other RDBMS with
> about 100 users on the MRP/DRP application. There was ample residual
> bandwidth to have about 20 of those 100 users interact with the
> (ChUI) application over the same link.
>
> You need to find out if CSAM is transaction-based, and if so, how to
> transfer/backup the logs.
>
> If it's not transaction-based, then there are much bigger problems
> lurking within a business database environment. It won't be a
> cataclysmic disaster; but more like an insidious cancer on the data.
> --
> /"\ Bernd Felsche - Innovative Reckoning, Perth, Western Australia
> \ /  ASCII ribbon campaign | "If we let things terrify us,
> X   against HTML mail     |  life will not be worth living."
> / \  and postings          | Lucius Annaeus Seneca, c. 4BC - 65AD.
>
> _______________________________________________
> PLUG discussion list: plug at plug.org.au
> http://www.plug.org.au/mailman/listinfo/plug
> Committee e-mail: committee at plug.linux.org.au
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.plug.org.au/pipermail/plug/attachments/20070131/27d12d2d/attachment.html>