Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN/Alert_log questions

Re: RMAN/Alert_log questions

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 23 Dec 2004 16:08:41 -0800
Message-ID: <1103846921.583447.35400@z14g2000cwz.googlegroups.com>


As someone else pointed out, you don't have block corruption just rman re-reading a block. You might want to consider putting into place a periodic rman "backup validate check logical database" command "if you are able to" (depends on size of databases and open windows of opportunity to run these commands without impacting system throughput), followed by a check of v$database_block_corruption.

The oracle product documentation is still somewhat weak in this area. Try on a test system forcing bad blocks ( dd is what you use on unix to do this ) and do some experimentation to make sure you know what you are looking at and how to address it. Depending on hardware and dasd configuration these types of areas are (thankfully) usually pretty rare (depends). Received on Thu Dec 23 2004 - 18:08:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US