Re: rman block recovery

From: ddf <oratune_at_msn.com>
Date: Wed, 11 Apr 2012 14:52:01 -0700 (PDT)
Message-ID: <e0e642cf-e687-4fe0-9349-a2a17399cba9_at_h12g2000yqi.googlegroups.com>

On Apr 11, 10:07 am, zigzag..._at_yahoo.com wrote:
> On Wednesday, April 11, 2012 11:44:13 AM UTC-4, zigz..._at_yahoo.com wrote:
> > I have a database which has database block corruption. I had a successful rman backup of Sunday.
> > Monday and Tuesday rman backup failed saying
> > ORA-19566: exceeded limit of 0 corrupt blocks for file F:\EM…….
>
> > Then I modified rman script to skip  up to 5 corrupt blocks..
> > set maxcorrupt for datafile 'F:\......' to 5;
>
> > Now my rman backup is successful on Wednesday…
>
> > Now, I want to repair blocks using rman’s block recover command:
> > recover datafile 19 block  321, 322, 385, 513, 577 restore
> > My questions are:
> > a. Will rman automatically start with Sunday’s successful back and then apply archived logs.. or
> > Will it start with Wednesday’s backups and then it won’t be able to recover corrupted blocks…
> > b. How to force rman block recover to start from Sunday’s backup … (Do I have to mark Wedensday's backup as invalid in rman catalog ...
>
> My version of database is 10.2.0.4 on Windows 2003 R2.- Hide quoted text -
>
> - Show quoted text -

What level backups are these? RMAN will take the most recent level 0 backup, recover the blocks from that then apply changes to those blocks from the most recent cumulative level 1 backup until the blocks are considered recovered.

David Fitzjarrell Received on Wed Apr 11 2012 - 16:52:01 CDT