// representative 这个1578一般 会伴随ORA-1110出现，一旦ORACLE读取到存在损坏的块就会报出:SQL> select * from scott.emp;select * from scott.emp ERROR at line 1:ORA-01578: ORACLE data block corrupted (file # 11, block # 34) 这里的FILE#是 RFN ORA-01110: data file 6:'/hom...
Database mounted. ORA-01578: ORACLE data block corrupted (file # 11, block # 2) ORA-01110: data file 1198: '/tmp/RPrbcor.dbf' SVRMGR> ( Recovery does not fail if a corrupt block is encountered - the block is skipped over and recovery continues. Warnings are written to the user trac...
The AFN is provided by the error ORA-1110 produced right after the ORA-1578. In the next example the AFN is 5 and BL is 34. SQL> select * from scott.dept_view; select * from scott.dept_view * ERROR at line 1: ORA-01578: ORACLE data block corrupted (file # 11, block # 34) ...
从以上的错误ORA-1110获取数据文件号,它表示绝对文件号(AFN),并运行下一个查询来识别受影响的Lob段: select owner, segment_name, segment_type from dba_extents where file_id = 10 and 2532 between block_id and block_id + blocks – 1;
ORA-1110 error. 2. Determine which rollback segment contains the corrupt block: SELECT segment_type, segment_name FROM dba_extents WHERE file_id=ANDBETWEEN block_id and block_id+blocks-1 ; 3. Find the SEGMENT_ID (USN) and STATUS of this rollback segment: ...
ORA-1110 error. SELECT segment_type, owner, segment_name FROM dba_extents WHERE file_id=ANDBETWEEN block_id and block_id+blocks-1 ; Assuming this is a rollback segment and you are in NOARCHIVELOG mode then you may want to try and salvage any data from the database ...
The AFN is provided by the error ORA-1110 produced right after the ORA-1578. In the next example the AFN is 5 and BL is 34. SQL> select * from scott.dept_view; select * from scott.dept_view * ERROR at line 1: ORA-01578: ORACLE data block corrupted (file # 11, block # 34) ...
The AFN is provided by the error ORA-1110 produced right after the ORA-1578. In the next example the AFN is 5 and BL is 34. SQL> select * from scott.dept_view; select * from scott.dept_view * ERROR at line 1: ORA-01578: ORACLE data block corrupted (file # 11, block # 34) ...
从以上的错误ORA-1110获取数据文件号,它表示绝对文件号(AFN),并运行下一个查询来识别受影响的Lob段: select owner, segment_name, segment_type from dba_extents where file_id = 10 and 2532 between block_id and block_id + blocks – 1;