Re: RMAN backup validate

From: Chen Zhou <oracle.unknowns_at_gmail.com>
Date: Sun, 15 Mar 2015 09:16:18 -0700
Message-ID: <CAJUY3dSC-hx6RYHYfyxVUxqO+=n_6eJ3R2EmPNdRY4AVHa4QFQ_at_mail.gmail.com>

Hemant,
I used "VALIDATE COPY OF DATABASE CHECK LOGICAL". I wanted to verify that the image copy of the database is good.
Thank you,
Chen

On Sun, Mar 15, 2015 at 8:27 AM, Hemant K Chitale <hemantkchitale_at_gmail.com> wrote:

>
> *Exactly* what commands are you running ? What version are you running ?
>
>
> As these tests in 10.2.0.4 show :
> http://hemantoracledba.blogspot.com/2010/03/misinterpreting-restore-database.html
>
> RESTORE DATABASE VALIDATE checks database file backupsets.
> You need to run RESTORE ARCHIVELOG ... VALIDATE as well to check the
> ArchiveLog Backupsets.
>
>
> Hemant K Chitale
>
> On Sat, Mar 14, 2015 at 11:26 PM, Chen Zhou <oracle.unknowns_at_gmail.com>
> 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?
>> 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?
>> Thank you for your thoughts.
>> Chen
>>
>
>
>
>
>
>

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

Received on Sun Mar 15 2015 - 17:16:18 CET