Hi All,
I need to know, if there is possibility to find the file_id or file name for any particular block number. I actually hit following error and need to find the datafile for which this block sits and then find the backup set in that particular backup window and validate it , if there are any corruption.
Following block number , I need to know the datafile 1797089. I did try to use dba_extents , but it returned no rows.
ORA-19502: write error on file "df_dbname_959382536_129018_1", block number 1797089 (block size=8192)
ORA-27030: skgfwrt: sbtwrite2 returned error
Thanks in advance.