Re: DB block corruption question

It sounds as if you have 2 issues:

1. notification that block corruption has occurred.
2. recovery of the affected block(s).

Perhaps your environment might want to support more than one standby database, with the log apply process having a longer delay on one or more standby databases?

Are you using rman to perform your physical backups? It checks blocks while backing them up.

Are you creating hot backups via a user-scripted routine? the dbv utility can be used to check blocks in datafile copies.

Are you using exp or expdp to create dumps? Those utilities also perform block checking.

hth.
-bdbafh Received on Thu Apr 27 2006 - 16:02:30 CDT