Oracle bad block processing record

1. Execute Sql:select COUNT (distinct ID) from BW_FPZXX, with the following error:

Ora-01578:oracle Data Block Corruption (file number 16, block number 195428)
ORA-01110: Data file: '/DISK01/HWXX09.DBF '
01578.00000-"ORACLE data block corrupted (file #%s, Block #%s)"

2. Confirm that the data for Block_no is 195428.

Select Id,rownum,rowid,dbms_rowid.rowid_relative_fno (ROWID) rel_fno,dbms_rowid.rowid_block_number (ROWID)
Blockno from Bw_fpzxx where DBMS_ROWID.ROWID_RELATIVE_FNO (ROWID) =16 and
Dbms_rowid.rowid_block_number (ROWID)
=195428--rownum <8;

/*
1 1100623697598 1 Aaasnhaaqaaavtkaal 16 195428
2 1100623690430 2 aaasnhaaqaaavtkaae 16 195428
3 1100623693502 3 Aaasnhaaqaaavtkaah 16 195428
4 1100623687358 4 Aaasnhaaqaaavtkaab 16 195428
5 1100623695550 5 Aaasnhaaqaaavtkaaj 16 195428
6 1100623691454 6 Aaasnhaaqaaavtkaaf 16 195428
7 1100623698622 7 Aaasnhaaqaaavtkaam 16 195428
8 1100623688382 8 AAASNHAAQAAAVTKAAC 16 195428
9 1100623694526 9 Aaasnhaaqaaavtkaai 16 195428
1100623696574 Aaasnhaaqaaavtkaak 16 195428
1100623692478 Aaasnhaaqaaavtkaag 16 195428
1100623686334 AAASNHAAQAAAVTKAAA 16 195428
1100623689406 Aaasnhaaqaaavtkaad 16 195428
*/

13 pieces of data, blocking the faulty block of data.

3.

Alter system set event= ' 10231 Trace name context forever,level ' Scope=spfile;

4. Execute SQL again

Select COUNT (Distinct ID) from BW_FPZXX;

147467803

Oracle bad block Processing records