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