Home » RDBMS Server » Backup & Recovery » Block corruption in system datafile (10.2.0.4/OCFS2/RHEL4.7)
Block corruption in system datafile [message #536977] Sun, 25 December 2011 05:52 Go to next message
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
Re: Block corruption in system datafile [message #536981 is a reply to message #536977] Sun, 25 December 2011 06:22 Go to previous messageGo to next message
Michel Cadot
Messages: 65848
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
Re: Block corruption in system datafile [message #536982 is a reply to message #536981] Sun, 25 December 2011 06:26 Go to previous messageGo to next message
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.
Re: Block corruption in system datafile [message #536985 is a reply to message #536982] Sun, 25 December 2011 07:59 Go to previous message
Michel Cadot
Messages: 65848
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check your io subsystem logs.

Regards
Michel
Previous Topic: begin backup/end backup
Next Topic: recovery window issue
Goto Forum:
  


Current Time: Fri Oct 19 23:22:03 CDT 2018