Database bad block, what to do?

in the DBA's work, what to do with the Oracle database bad block, I would like to introduce a thought:

1. Check that the data block is damaged:

• When the database is backed up using Rman;

• When the table is analyzed by the Analyze command;

• When the data file is verified by the DBV tool;

• When accessing a data file through a SQL command.

2. Database bad block, recovery, block media recovery requirements meet the following conditions:

• The log mode of the database must be an archive mode, and the state of the database service is open or mount;

• You must have a 0 or full backup of the database, and the backup file is available.

• The flashback function of the database must be enabled;

• The database archive log must be kept intact.

3. Perform bad block media recovery

• Rman target/recover datafile 7 block 3

• Rman target/recover datafile 7 block 3 from Backupset 10;

This article is from the Internet + DBA blog, so be sure to keep this source http://kingdba.blog.51cto.com/801693/1717341

Database bad block, what to do?