修复 block corruption

select dbms_rowid.rowid_relative_fno(t.rowid),dbms_rowid.rowid_block_number(t.rowid) from test t;
select * from dba_extents t where t.FILE_ID=4 and 131 between t.BLOCK_ID and t.BLOCK_ID+t.BLOCKS-1;
select * from dba_data_files t where t.TABLESPACE_NAME='USERS';

RMAN> validate datafile 4;
C:\Users\qiang>dbv file=D:\APP\QIANG\ORADATA\TEST\DATAFILE\O1_MF_USERS_79WD155G_.DBF

select * from v$database_block_corruption;

--使用rman进行块恢复:

RMAN> blockrecover datafile 4 block 131 from backupset;

--块恢复后, 执行BLOCKRECOVER CORRUPTION LIST，会自动按照V$DATABASE_BLOCK_CORRUPTION进行修复(耗时较长):

RMAN> BLOCKRECOVER CORRUPTION LIST;

--这个时候再访问v$database_block_corruption就看不到详细的坏块信息了:

SQL> select * from v$database_block_corruption;
no rows selected