Home » RDBMS Server » Backup & Recovery » Corrupted Blocks
Corrupted Blocks [message #286099] Thu, 06 December 2007 08:12 Go to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Hi M

Oracle - 10g release 1
Linux - RHEL AS 3.0

Environemnt - Development Database size 20 GB


i m getting following error while imp
-------------------------------------------------------------
IMP-00003: ORACLE error 604 encountered
ORA-00604: error occurred at recursive SQL level 2
ORA-01578: ORACLE data block corrupted (file # 1, block # 1594)
ORA-01110: data file 1: '/home/oracle/oradata/orcl/system01.dbf'
-------------------------------------------------------------

kindly suggest how can we repair corrupted block.
we dont have any backup.

Regrads

Tarun Mittal

Report message to a moderator

Re: Corrupted Blocks [message #286103 is a reply to message #286099] Thu, 06 December 2007 08:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Metalink notes:

Frequently Encountered Corruption Errors, Diagnostics and Resolution - Reference, note 463479.1

Handling Oracle Block Corruptions in Oracle7/8/8i/9i/10g, note 28814.1

Regards
Michel

Report message to a moderator

Re: Corrupted Blocks [message #286258 is a reply to message #286103] Fri, 07 December 2007 00:56 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member

we have found there is corupption in sys schema & table name is
HIST_HEAD$.

can we drop that table & recreate it


Kindly suggest

Report message to a moderator

Re: Corrupted Blocks [message #286277 is a reply to message #286258] Fri, 07 December 2007 01:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't drop and recreate a SYS table.
Try to remove all statistics in your database (dbms_stats.delete_database_stats with force option) and then truncate the table.

BEWARE! THIS IS NOT SUPPORTED! Call support before.
BEWARE! TAKE A FULL COLD BACKUP BEFORE!

Regards
Michel

Report message to a moderator

Re: Corrupted Blocks [message #286315 is a reply to message #286277] Fri, 07 December 2007 02:48 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Hi M

After deep analysis i come to know in all sys tables it showing corruption.

i do nt have meta link excess

kindly give some suggestion



Regards

Report message to a moderator

Re: Corrupted Blocks [message #286323 is a reply to message #286315] Fri, 07 December 2007 03:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If all SYS tables are corrupted you now have to restore a backup.

Regards
Michel

Report message to a moderator

Re: Corrupted Blocks [message #286335 is a reply to message #286323] Fri, 07 December 2007 03:22 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
but i do nt have backup

Report message to a moderator

Re: Corrupted Blocks [message #286343 is a reply to message #286335] Fri, 07 December 2007 03:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Try to get a full export of your database and recreate a new one.
And next time, take backups.

Regards
Michel

[Updated on: Fri, 07 December 2007 03:29]

Report message to a moderator

Re: Corrupted Blocks [message #286377 is a reply to message #286343] Fri, 07 December 2007 04:11 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
export fail

Report message to a moderator

Re: Corrupted Blocks [message #286381 is a reply to message #286377] Fri, 07 December 2007 04:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post errors and export command you used.

Regards
Michel

[Updated on: Fri, 07 December 2007 04:16]

Report message to a moderator

Re: Corrupted Blocks [message #286387 is a reply to message #286381] Fri, 07 December 2007 04:28 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
exp sys/pass as sysdba file=test.dmp log=test.log buffer=999999 full=y


-----------------------------------------------------------
EXP-00056: ORACLE error 22303 encountered
ORA-22303: type "SYS"."KU$_PROCOBJ_LINES" not found
ORA-00604: error occurred at recursive SQL level 2
ORA-01578: ORACLE data block corrupted (file # 1, block # 1594)
ORA-01110: data file 1: '/home/oracle/oradata/orcl/system01.dbf'
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
----------------------------------------------------------

Report message to a moderator

Re: Corrupted Blocks [message #286390 is a reply to message #286387] Fri, 07 December 2007 04:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Now try to export, schema per schema (only those who own objects).
If you can't then you lose the whole database.

Regards
Michel

Report message to a moderator

Re: Corrupted Blocks [message #289550 is a reply to message #286390] Sun, 23 December 2007 23:59 Go to previous message
d.c.b.a
Messages: 44
Registered: March 2005
Location: China
Member
add STATISTICS=NO option when export.

Report message to a moderator

Previous Topic: RMAN
Next Topic: Logical backup
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 14 22:17:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.