Re: RMAN backup validate
From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Sat, 14 Mar 2015 16:24:16 -0500
Message-Id: <BECC0B70-6DB1-4C96-81AD-172A41844CBF_at_gmail.com>
Depends on your environment and circumstances. RAC is not HA unless the storage itself is replicated outside your data center. Logical corruption can require restores to an earlier point in time. Basically if you have an rman backup, you should have a tested plan for using it or there is no point in taking it.
>
> 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-l
>
>
Date: Sat, 14 Mar 2015 16:24:16 -0500
Message-Id: <BECC0B70-6DB1-4C96-81AD-172A41844CBF_at_gmail.com>
Depends on your environment and circumstances. RAC is not HA unless the storage itself is replicated outside your data center. Logical corruption can require restores to an earlier point in time. Basically if you have an rman backup, you should have a tested plan for using it or there is no point in taking it.
Sent from my iPad
> On Mar 14, 2015, at 3:45 PM, Mladen Gogala (Redacted sender "mgogala_at_yahoo.com" for DMARC) <dmarc-noreply_at_freelists.org> wrote:
>
>> 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-l
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Mar 14 2015 - 22:24:16 CET