SYSTEM TS Corruption - Zero Blocks
667113Dec 11 2008 — edited Dec 3 2010One of our production instances use operating system level COPY as backup method. When we tried to implement rman backups, we came to know there are some zero blocks in system tablespace. after doing a DBV on the datafile noted by rman, we found there are 12 corrupt/zero pages in system03.dbf.
We cannot go to a backup and roll forward, because we dont know since when this system03 is corrupt. The only option that comes to mind is a full export and rebuild of the database. This is an oracle applications db and pretty critical. The size is around 300GB. We cant afford that much downtime on production.
Any ideas ? so far we didnt have any reported issues due to this corruption. The corrupted object in SYS.IDL_UB1$.
++DBV LOG :-++
DBVERIFY: Release 10.2.0.3.0 - Production on Thu Dec 11 11:00:26 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
DBVERIFY - Verification starting : FILE = system03.dbf
Page 191938 is influx - most likely media corrupt
Corrupt block relative dba: 0x00c2edc2 (file 3, block 191938)
Fractured block found during dbv:
Data in bad block:
type: 0 format: 2 rdba: 0x00c2edc2
last change scn: 0x0000.00000000 seq: 0x1 flg: 0x05
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x00000000
check value in block header: 0xea00
computed block checksum: 0x1
Page 191939 is marked corrupt
Corrupt block relative dba: 0x00c2edc3 (file 3, block 191939)
Completely zero block found during dbv:
Page 191940 is marked corrupt
Corrupt block relative dba: 0x00c2edc4 (file 3, block 191940)
Completely zero block found during dbv:
Page 191941 is marked corrupt
Corrupt block relative dba: 0x00c2edc5 (file 3, block 191941)
Completely zero block found during dbv:
Page 191942 is marked corrupt
Corrupt block relative dba: 0x00c2edc6 (file 3, block 191942)
Completely zero block found during dbv:
Page 191943 is marked corrupt
Corrupt block relative dba: 0x00c2edc7 (file 3, block 191943)
Completely zero block found during dbv:
Page 191944 is marked corrupt
Corrupt block relative dba: 0x00c2edc8 (file 3, block 191944)
Completely zero block found during dbv:
Page 191945 is marked corrupt
Corrupt block relative dba: 0x00c2edc9 (file 3, block 191945)
Completely zero block found during dbv:
Page 191946 is marked corrupt
Corrupt block relative dba: 0x00c2edca (file 3, block 191946)
Completely zero block found during dbv:
Page 191947 is marked corrupt
Corrupt block relative dba: 0x00c2edcb (file 3, block 191947)
Completely zero block found during dbv:
Page 191948 is marked corrupt
Corrupt block relative dba: 0x00c2edcc (file 3, block 191948)
Completely zero block found during dbv:
Page 191949 is influx - most likely media corrupt
Corrupt block relative dba: 0x00c2edcd (file 3, block 191949)
Fractured block found during dbv:
Data in bad block:
type: 0 format: 0 rdba: 0x00000000
last change scn: 0x0000.00000000 seq: 0x0 flg: 0x00
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x00000001
check value in block header: 0x0
block checksum disabled
DBVERIFY - Verification complete
Total Pages Examined : 256000
Total Pages Processed (Data) : 128521
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 52973
Total Pages Failing (Index): 0
Total Pages Processed (Other): 493
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 74001
Total Pages Marked Corrupt : 12
Total Pages Influx : 2
Highest block SCN : 1191398275 (1.1191398275)
Edited by: Lakshmi Pavuluri on Dec 11, 2008 11:30 AM