Re: Oracle block corruption, restore and roll forward

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Thu, 4 Nov 2004 02:19:25 +1100
Message-ID: <4188f6e6$0$24942$afc38c87@news.optusnet.com.au>

"Dusan Bolek" <pagesflames_at_usa.net> wrote in message news:1e8276d6.0411030648.6ae1d70e_at_posting.google.com...
> "Howard J. Rogers" <hjr_at_dizwell.com> wrote in message
> news:<41884f24$0$32593$afc38c87_at_news.optusnet.com.au>...
>
>> Otherwise, the only thing I can think of is that you didn't restore froma
>> suffcieintly old backup, and that the corruption was in the backup you
>> just
>> restored from. In which case (a) why don't you verify your backups using
>> DBVerify (dbv) -because then you would have known of the problem in your
>> backup set. And (b) how about restoring from a much older backup and
>> recovering that?
>
> ... and also how about using RMAN utility for future backups to ensure
> that something like this (unnoticed corrupted backup set) wouldn't
> happen again?

Excellent point.

Regards
HJR Received on Wed Nov 03 2004 - 09:19:25 CST