Home » RDBMS Server » Backup & Recovery » Datablock corruption on PA-RISC plataform (Oracle RDBMS 9.2.0.4 HP-UX 11.11)
Datablock corruption on PA-RISC plataform [message #308881] Tue, 25 March 2008 16:22 Go to next message
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 #308963 is a reply to message #308881] Wed, 26 March 2008 01:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What do you want from us?
If I say yes, how does this help you?
If I say no but have experience in block corruption, can I help you?

Regards
Michel
Re: Datablock corruption on PA-RISC plataform [message #309023 is a reply to message #308881] Wed, 26 March 2008 04:23 Go to previous messageGo to next message
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



Re: Datablock corruption on PA-RISC plataform [message #309031 is a reply to message #309023] Wed, 26 March 2008 04:50 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It seems the corrupted block does not belong to any segment (table or index) so it is not a problem, next time it will be used it will be reformatted.

Regards
Michel
Previous Topic: Restoration throuh Rman
Next Topic: RMAN restoration to a different location
Goto Forum:
  


Current Time: Sun Dec 04 08:43:02 CST 2016

Total time taken to generate the page: 0.05053 seconds