Block Corruption

▣ Block Corruption 징후

▶ ORA-01578 : "Oracle data block corrupted (file # %s, block # %s)";

▶ alert.log에서 확인 가능

   

▣ Corruption 처리

▶ Check the alert log and operating system logfile

▶ Use available diagnostic tools to find out the type of corruption => dbv, exp

▶ Determine whether the error persists by running checks multiple times

▶ Recover data from the corrupted object if necessary => BMR

   

▣ Corruption-Related Features

▶ 물리적 에러

순서	Feature	Corruption Detected	Repairs Corruption
0	DB_BLOCK_CHECKSUM	Physical	False
1	ORA-01578
2	DBVERIFY	Physical	False
3	Exp	Physical	False
4	Block media recovery	None	True

※ DB_BLOCK_CHECKSUM : 물리적인 오류시 에러발생 - 파라미터

   

▶ 논리적 에러

순서	Feature	Corruption Detected	Repairs Corruption
0	DB_BLOCK_CHECKING	Logical	False
1	논리적 에러
2	ANALYZE	Logical	False
3	Rebuild
4	Flashback	Logical	True

※ DB_BLOCK_CHECKING : 기본값 False

   

▣ Table Move

   

▣ Rebuild 할 index가 많을 경우