Re: testing recovery

From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Wed, 14 Sep 2011 11:59:21 -0500
Message-ID: <CAGRGHjwKb3-UeqYUjC-B7fZu9pAYFd3s3F2oTDYFWfzF34WQgQ_at_mail.gmail.com>



Eric,
This project sounds interesting. Is it based on RMAN?

Dennis

On Wed, Sep 14, 2011 at 4:33 AM, Eric Grancher <eric_at_grancher.fr> wrote:

> 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
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 14 2011 - 11:59:21 CDT

Original text of this message