| Datablock corruption on PA-RISC plataform [message #308881] |
Tue, 25 March 2008 16:22  |
jfgomez
Messages: 3
Registered: March 2008
|
Junior Member |
|
|
Hi Gurus,
For some time ago (approximately 2 months) we have been having constant problems of corruption in datablocks one of our Oracle databases. We have open an SR with Oracle Support but we have not even solved anything. This database is mounted on a platform PA-RISC 8900 with an HP-UX 11.11 Operating System. I would want to ask if some of you has passed you a similar case having corruption in datablocks with this platform. Thank you very much by your aid.
P.S Now we have 2 databases (9.2.0.4 and 9.2.0.5) with datablocks corruption problems both in same plataform (PA-RISC 8900) and same operating system (HP-UX 11.11).
|
|
|
|
|
|
| Re: Datablock corruption on PA-RISC plataform [message #309023 is a reply to message #308881] |
Wed, 26 March 2008 04:23  |
jfgomez
Messages: 3
Registered: March 2008
|
Junior Member |
|
|
ALERT LOG
-----------
Mon Mar 24 20:35:10 2008
alter tablespace USERS end backup
Completed: alter tablespace USERS end backup
***
Corrupt block relative dba: 0x03801e07 (file 14, block 7687)
Bad check value found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x03801e07
last change scn: 0x0000.06c3d1f1 seq: 0x1 flg: 0x04
consistency value in tail: 0xd1f10601
check value in block header: 0xa083, computed block checksum: 0x90bd
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x03801e07 (file 14, block 7687) found same corrupted data
...
Tue Mar 25 09:44:29 2008
Starting block media recovery
Media Recovery Log /opt/oracle/oradata/METAD/archiver/METAD_0000002843_0001.arc
Media Recovery Log /opt/oracle/oradata/METAD/archiver/METAD_0000002844_0001.arc
Media Recovery Log /opt/oracle/oradata/METAD/archiver/METAD_0000002845_0001.arc
Media Recovery Log /opt/oracle/oradata/METAD/archiver/METAD_0000002846_0001.arc
Media Recovery Log /opt/oracle/oradata/METAD/archiver/METAD_0000002847_0001.arc
Recovery of Online Redo Log: Thread 1 Group 1 Seq 2848 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata/METAD/datos/log01.rdo
Mem# 1 errs 0: /opt/oracle/oradata/METAD/indices/log01b.rdo
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2849 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata/METAD/indices/log02.rdo
Mem# 1 errs 0: /opt/oracle/oradata/METAD/datos/log02b.rdo
Recovery of Online Redo Log: Thread 1 Group 3 Seq 2850 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata/METAD/rollback/log03.rdo
Mem# 1 errs 0: /opt/oracle/oradata/METAD/temp/log03b.rdo
Completed recovery of file 14, block 7687
Tue Mar 25 09:44:48 2008
Completed block media recovery
DBVERIFY: Release 9.2.0.4.0 - Production on Tue Mar 25 09:27:54 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
DBVERIFY - Verification starting : FILE = /opt/oracle/oradata/METAD/datos/democs_GRA_64_01.dbf
Page 7687 is marked corrupt
***
Corrupt block relative dba: 0x03801e07 (file 14, block 7687)
Bad check value found during dbv:
Data in bad block -
type: 6 format: 2 rdba: 0x03801e07
last change scn: 0x0000.06c3d1f1 seq: 0x1 flg: 0x04
consistency value in tail: 0xd1f10601
check value in block header: 0xa083, computed block checksum: 0x90bd
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
DBVERIFY - Verification complete
Total Pages Examined : 384000
Total Pages Processed (Data) : 265216
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing (Index): 0
Total Pages Processed (Other): 1510
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 117273
Total Pages Marked Corrupt : 1
Total Pages Influx : 0
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
