Re: RMAN backup validate
Date: Sat, 14 Mar 2015 16:45:43 -0400
Message-ID: <55049DF7.1050800_at_yahoo.com>
On 03/14/2015 03:53 PM, Andrew Kerber wrote:
> You should also do a full restore periodically to verify the validity of your recovery plan. At least every 6 months.
>
> Sent from my iPad
>
Not really, if there is a standby DB. Standby is usually the first line of defense and can be deployed really quickly. Frequently, the first line of defense is RAC, which demotes backup to the third and last line of defense, or even 4th line of defense, if snapshots are used. Probability of having to restore from backup is normally minuscule, roughly the same as the probability that New York City will be hit by a major hurricane. That never happens. Well, almost never.
My point is that validating backups using "restore validate" is normally sufficient. Restore database, especially in case of a multi-tb database, can take days and consume quite a lot of resources, which is quite expensive, both in terms of resources and work. If the database configuration is properly protected with RAC and standby in a location far, far away, there is usually no need for a pilgrimage to the Iron Mountain and restoring from tape.
-- Mladen Gogala Oracle DBA http://mgogala.freehostia.com -- http://www.freelists.org/webpage/oracle-lReceived on Sat Mar 14 2015 - 21:45:43 CET