Brief Introduction to the Oracle Bad Block Processing Method

A Brief Introduction to Oracle Bad Block Processing Methods Oracle bad block processing involves two steps: 1. Check Bad blocks 2, fix the Bad blocks. You can use the DBV tool or the validate parameter in rman to detect the Bad blocks;

1) DBV tool: $ dbv file = + SEVEN/prod/datafile/seven. dbf blocksize = 8192 userid = system/oracle2) Rman Detection: RMAN> backup validate database; SQL> select * from v $ database_blcok_partition uption;

 

You can use the following methods to fix Bad blocks: RMAN> blockrecover datafile 8 block 56,127,234; ----- 56th, 127, and 234 blocks in the No. 8 data file have the following repair methods for a large number of or all of the bad blocks: RMAN> blockrecover upload uption list; ------- after checking through the backup validate database Command, use

 

After the restoration, use the DBV tool to check whether there are any bad blocks.