Re: rman block recovery
From: joel garry <joel-garry_at_home.com>
Date: Wed, 11 Apr 2012 16:38:32 -0700 (PDT)
Message-ID: <818fb1bb-2182-41de-9979-ad5166b0ea06_at_qg3g2000pbc.googlegroups.com>
On Apr 11, 2:52 pm, ddf <orat..._at_msn.com> wrote:
> 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
Date: Wed, 11 Apr 2012 16:38:32 -0700 (PDT)
Message-ID: <818fb1bb-2182-41de-9979-ad5166b0ea06_at_qg3g2000pbc.googlegroups.com>
On Apr 11, 2:52 pm, ddf <orat..._at_msn.com> wrote:
> 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
The 10.2 docs seem to say only full backups and archived logs are used: http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmconc2.htm#BRADV118 I think it is different in 11. I have no real experience with this.
There are examples of, for example, tags or time: http://docs.oracle.com/cd/B19306_01/backup.102/b14194/rcmsynta010.htm#RCMRF108
jg
-- _at_home.com is bogus. http://www.itpro.co.uk/640018/oracle-reveals-raft-of-xeon-e5-based-sun-serversReceived on Wed Apr 11 2012 - 18:38:32 CDT