Re: RMAN backup validate
From: Ray Stell <stellr_at_vt.edu>
Date: Mon, 16 Mar 2015 10:11:29 -0400
Message-ID: <5506E491.4040903_at_vt.edu>
On 3/14/15 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?
Along with the other ideas presented here, another report I use is REPORT NEED BACKUP. You can use this to determine which database files need backup under a specific retention policy. Also, this is a way for check if a data file in the backupset has been changed by an unrecoverable operation. I accidentally found that a java developer (or his IDE, rather) had created tables with the "unrecoverable" option this way. I guess the data wasn't that important :)
Date: Mon, 16 Mar 2015 10:11:29 -0400
Message-ID: <5506E491.4040903_at_vt.edu>
On 3/14/15 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?
Along with the other ideas presented here, another report I use is REPORT NEED BACKUP. You can use this to determine which database files need backup under a specific retention policy. Also, this is a way for check if a data file in the backupset has been changed by an unrecoverable operation. I accidentally found that a java developer (or his IDE, rather) had created tables with the "unrecoverable" option this way. I guess the data wasn't that important :)
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 16 2015 - 15:11:29 CET