Re: testing recovery
Date: Tue, 06 Sep 2011 21:14:32 +0200
Message-ID: <4E667118.3060007_at_gmx.net>
We are doing at least one-two test recovery per year. Sometimes a scenario we choose, sometimes our manager does: time for disaster recovery beginning with OS install on new host - duplicate database to test - simple / pitr recovery for non-Oracle-DBAs - repair broken Oracle installation - time for complete recovery of large DB - ...
In most cases we use an empty host (very new or very old) and a small dedicated test db for this purpose.
A short backup-restore test is also part of the installation process for new Oracle servers.
The "ordinary" scenarios (pitr because customer broke something) occur frequently enough in production and don't have to be tested. Restore only failed once... so far... ( ;-) )
Regards
Ingrid
On 06.09.2011 20:23, Zelli, Brian 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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 06 2011 - 14:14:32 CDT