Re: testing recovery

From: Eric Grancher <eric_at_grancher.fr>
Date: Wed, 14 Sep 2011 11:33:36 +0200
Message-ID: <CAKU0_hh5mLSczyTeygjiLaw9t+kmHN8bif7DcXQeNx+dkMNS7w_at_mail.gmail.com>

good morning,
regarding this question, at CERN we (Ruben Gaspar) have developed a fully automated recovery validation system and open sourced it, it is available at: http://sourceforge.net/projects/recoveryplat/. It works for 9.2 10.2 and 11.2 on several platforms like Solaris and Linux.

It works from 9.2 to 11.2 on multiple platforms, both with (local or shared like NFS) filesystem and ASM.

Having such a solution is really worth to really validate the backups to identify possible flaws especially when the backup strategy gets quite complex (read-only tablespaces, etc.) and also to have an estimate about the time required to do the real restore/recover.

We use it to validate a number of databases on a regular basis (some on a weekly basis) and also export some in a consistent way for some (at the end of the recovery) for long term archival.

regards,
Eric

On 6 September 2011 20:23, Zelli, Brian <Brian.Zelli_at_roswellpark.org> wrote:

> Ok, we just got hit with a "Are you testing your backups?" from senior
> administration. We sometimes use copies to replace test or dev but they
> want a scheduled plan. The first thing I mentioned was do you have enough
> space(some db's are over a 1T)? Do you have matching hardware sitting
> around that I can drop my db's onto? Licensing $$$$? What do you as a
> community do to satisfy or comply with this?
> ciao,
> Brian
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 14 2011 - 04:33:36 CDT