OraFAQ Forum: Backup & Recovery » Block corruption in system datafile

Home » RDBMS Server » Backup & Recovery » Block corruption in system datafile (10.2.0.4/OCFS2/RHEL4.7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Block corruption in system datafile [message #536977]

Sun, 25 December 2011 05:52

nazimsk
Messages: 2
Registered: August 2010
Location: Dubai

Junior Member

Hi Folks,
I have noticed a block corruption issue in my RAC database.
Its an index , how to recover a corrupted index in system datafile.

SELECT tablespace_name, segment_type, owner, segment_name
FROM dba_extents WHERE file_id = 5
3 and 147551 between block_id AND block_id + blocks - 1;

TABLESPACE_NAME SEGMENT_TYPE OWNER
------------------------------ ------------------ ------------------------------
SEGMENT_NAME
--------------------------------------------------------------------------------
SYSTEM INDEX SYS
I_COL1

We are using OCFS2 and O/S is RHEL 4.7.

Any suggestions ?

Regards,Nazim

Report message to a moderator

Re: Block corruption in system datafile [message #536981 is a reply to message #536977]

Sun, 25 December 2011 06:22

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Drop and recreate the index, of course in exclusive and restricted session mode.

Regards
Michel

Report message to a moderator

Re: Block corruption in system datafile [message #536982 is a reply to message #536981]

Sun, 25 December 2011 06:26

nazimsk
Messages: 2
Registered: August 2010
Location: Dubai

Junior Member

I ran the below query to resolve the issue

run {blockrecover datafile 5 block 147551;}

Is there any to prevent from these errors. This is the second time in 3 months.

Report message to a moderator

Re: Block corruption in system datafile [message #536985 is a reply to message #536982]

Sun, 25 December 2011 07:59

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Check your io subsystem logs.

Regards
Michel

Report message to a moderator

Previous Topic:	begin backup/end backup
Next Topic:	recovery window issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 14:15:30 CDT 2024