I just learned ADRCI and ran show incidents and show problems and got these two lines.
ORA-01578: ORACLE data block corrupted (file # 1, block # 6954)
ORA-01110: data file 1: '/u01/app/oracle/oradata/orcl/system01.dbf'
After searching, I found this statement to see what specific object needs fixing.
SELECT tablespace_name, segment_type, owner, segment_name FROM dba_extents WHERE file_id = 1 and 6954 between block_id AND block_id + blocks - 1;
| TABLESPACE_NAME SEGMENT_TYPE | OWNER | SEGMENT_NAME |
--------------- ------------------ -------- ---------------------------------------------------------------------------------
| SYSTEM | TABLE | SYS | SYS_FBA_BARRIERSCN |
I don't have archive log mode enabled nor backup. Yes it sucks.
Questions:
- Will i still be able to fix this? If so, how and what else I can do. The instance is still running fine.
- I don't understand this part "dba_extents WHERE file_id = 1 and 6954 between block_id AND block_id + blocks - 1;". Can you guys please explain.
Thanks.