Re: RMAN backup validate

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Sat, 14 Mar 2015 14:53:09 -0500
Message-Id: <8BE082CB-5066-4771-B7B3-8AA67CE58253_at_gmail.com>

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

> On Mar 14, 2015, at 2:44 PM, Mladen Gogala (Redacted sender "mgogala_at_yahoo.com" for DMARC) <dmarc-noreply_at_freelists.org> wrote:
>

>> On 03/14/2015 11:26 AM, Chen Zhou wrote:
>> Hi, Everyone,
>> If I ran RMAN Validate copy of database check logical and it returns no corruption, does it mean the image copy is good?

>
> The "CHECK LOGICAL" clause check the structure of the blocks and is meant to be used by backup as in
> "BACKUP DATABASE CHECK LOGICAL". Restore validate reads the backup and checks all checksums. If all is well, the bacjkup is OK.
>

>> I have a large database that is backed up by using incrementally updated image copy.
>> I am wondering how would I know for sure if the backup is still good.
>> Should I recreate the whole backup once in a while?

> That sounds as a good idea if you have resources.
>
>
>
> --
> Mladen Gogala
> Oracle DBA
> http://mgogala.freehostia.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

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

Received on Sat Mar 14 2015 - 20:53:09 CET