Can shutdown abort result in block corruption?
572424Apr 13 2007 — edited Apr 17 2007Hi Oracle gurus!
Need your advice re the problem we are seeing.
An appliance type of device running Linux+Oracle 10g is being developed.
After the OS and Oracle are installed from scrath and running for several days, on some systems we see block corruption messages in Oracle alert log - usually 1-2 corrupted blocks.
We are trying to identify what can be the reason for that corruption and are evaluating all possibilities including HW, OS, and Oracle.
One of the suspicious things that I see (as a HW guy) is that every time Oracle is being shut down using abort command (not sure why SW developers decided to do it this way). There are no clean shutdowns in between.
Can aborts potentially lead to block corruption?
Appreciate you help.
***
Tue Apr 10 12:52:51 2007
Completed: ALTER DATABASE OPEN
Tue Apr 10 13:12:02 2007
Shutting down instance (abort)
License high water mark = 59
Instance terminated by USER, pid = 16923
Tue Apr 10 13:15:06 2007
Starting ORACLE instance (normal)
***
Thread 1 advanced to log sequence 83
Current log# 3 seq# 83 mem# 0: /u03/app/oracle/oradata/pndb/redo03.log
Wed Apr 11 03:20:23 2007
Hex dump of (file 15, block 371651) in trace file /u01/app/oracle/admin/pndb/udump/pndb_ora_12567.trc
Corrupt block relative dba: 0x03c5abc3 (file 15, block 371651)
Bad check value found during buffer read
Data in bad block:
type: 6 format: 2 rdba: 0x03c5abc3
last change scn: 0x0000.00302a0b seq: 0x1 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x2a0b0601
check value in block header: 0xc171
computed block checksum: 0x400
Reread of rdba: 0x03c5abc3 (file 15, block 371651) found same corrupted data
Wed Apr 11 03:20:24 2007
Corrupt Block Found
TSN = 9, TSNAME = PN_TABL
RFN = 15, BLK = 371651, RDBA = 63286211
OBJN = 40741, OBJD = 40741, OBJECT = PN_EVENT_SESSION_1, SUBOBJECT =
SEGMENT OWNER = PNADMIN, SEGMENT TYPE = Table Segment
Wed Apr 11 03:27:11 2007
Hex dump of (file 15, block 371651) in trace file /u01/app/oracle/admin/pndb/udump/pndb_ora_12567.trc
Corrupt block relative dba: 0x03c5abc3 (file 15, block 371651)
Bad check value found during buffer read
Data in bad block:
type: 6 format: 2 rdba: 0x03c5abc3
last change scn: 0x0000.00302a0b seq: 0x1 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x2a0b0601
check value in block header: 0xc171
computed block checksum: 0x400
Reread of rdba: 0x03c5abc3 (file 15, block 371651) found same corrupted data
***