Re: testing recovery

  • From: Eric Grancher <eric@xxxxxxxxxxx>
  • To: Dennis Williams <oracledba.williams@xxxxxxxxx>
  • Date: Wed, 14 Sep 2011 19:03:07 +0200

Dennis,
yes it is based on RMAN, it basically retrieves a control file, the launches
a restore and a recover
There is a full documentation in the project.
Do not hesitate to contact Ruben via the SourceForge project.

cheers
Eric

On Wednesday, 14 September 2011, Dennis Williams wrote:

> Eric,
>
> This project sounds interesting. Is it based on RMAN?
>
> Dennis
>
> On Wed, Sep 14, 2011 at 4:33 AM, Eric Grancher 
> <eric@xxxxxxxxxxx<javascript:_e({}, 'cvml', 'eric@xxxxxxxxxxx');>
> > 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@xxxxxxxxxxxxxxx<javascript:_e({}, 'cvml', 
>> 'Brian.Zelli@xxxxxxxxxxxxxxx');>>
>> 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.
>> > --
>> > //www.freelists.org/webpage/oracle-l
>> >
>> >
>> >
>>
>>
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>>
>


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


Other related posts: