Home » RDBMS Server » Backup & Recovery » ora-01578: Oracle data block corruption (file#1, block#134144) (11gR2, 11.2.0.1, Windows server)
ora-01578: Oracle data block corruption (file#1, block#134144) [message #588260] Mon, 24 June 2013 05:33 Go to next message
ishika_20
Messages: 334
Registered: December 2006
Location: delhi
Senior Member
Dear All,

We are facing block corruption error and it's refer to system datafile (SYSTEM01.DBF).
Below is the script through it, we can come to know about the extent.

select segment_name, segment_type from dba_extents
where file_id=1  and 134144 between block_id and block_id+blocks-1;

select owner,index_name,index_type, table_name from dba_indexes
where index_name='I_CDEF3';


How to resolve the problem as it is related to system datafile?

We tried to drop the index but system is not allowing to do.
ORA-00701 - object necessary for warmstarting database cannot be altered.


Kindly suggest.

regards,
Ishika
Re: ora-01578: Oracle data block corruption (file#1, block#134144) [message #588264 is a reply to message #588260] Mon, 24 June 2013 05:54 Go to previous messageGo to next message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
rman target / <<EOF
  block recover datafile 1 block 134144;
  exit;
EOF

Regards
Michel

[Updated on: Mon, 24 June 2013 05:54]

Report message to a moderator

Re: ora-01578: Oracle data block corruption (file#1, block#134144) [message #588269 is a reply to message #588264] Mon, 24 June 2013 06:09 Go to previous messageGo to next message
ishika_20
Messages: 334
Registered: December 2006
Location: delhi
Senior Member
Dear Michel,

This is development database. We dont have RMAN. It's in non-archivelog database.
Please suggest, how can we solve problem of system level index block corruption?

Regards,
Ishika
Re: ora-01578: Oracle data block corruption (file#1, block#134144) [message #588276 is a reply to message #588269] Mon, 24 June 2013 06:32 Go to previous messageGo to next message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Try rebuild.

Regards
Michel
Re: ora-01578: Oracle data block corruption (file#1, block#134144) [message #588283 is a reply to message #588276] Mon, 24 June 2013 07:30 Go to previous messageGo to next message
ishika_20
Messages: 334
Registered: December 2006
Location: delhi
Senior Member
Dear Michel,

You mean to say, i need to re-built database again?

There are no other solution left?

Regards,
Ishika
Re: ora-01578: Oracle data block corruption (file#1, block#134144) [message #588285 is a reply to message #588283] Mon, 24 June 2013 07:46 Go to previous messageGo to next message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, I meant "ALTER INDEX REBUILD"

Regards
Michel
Re: ora-01578: Oracle data block corruption (file#1, block#134144) [message #588359 is a reply to message #588285] Tue, 25 June 2013 05:31 Go to previous messageGo to next message
ishika_20
Messages: 334
Registered: December 2006
Location: delhi
Senior Member
Dear Michel,

We tried to re-built it but system doesn't allow. Atlast, we created new database and import the previous day's backup. This is not the production server. That's why we have taken such steps.

Thanks for your feedback. Next time, i will reply you with error.

Regards,
Ishika
Re: ora-01578: Oracle data block corruption (file#1, block#134144) [message #588362 is a reply to message #588359] Tue, 25 June 2013 05:41 Go to previous message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I hope next time you will SHOW us: copy and paste your SQL*Plus session.

Regards
Michel
Previous Topic: backup utility problems
Next Topic: RMAN-00554: initialization of internal recovery manager package failed
Goto Forum:
  


Current Time: Sun Apr 20 08:01:57 CDT 2014

Total time taken to generate the page: 0.03873 seconds