If you run Oracle 9.2.0.2.0 on Solaris 32bit Sparc (no version info was
available) you may be hitting bug 2870048 ; in this case the block
corruption messages are false and due to an incorrect setting of
db_file_multiblock_read_count
Otherwise :
Can you perform a full export of the database ? if this is not possible,
can you perform schema exports of all non-oracle schemas?
If you can perform schema_level exports without error messages, just
drop the database, create a new one and import the export or datapump
files
Otherwise :
Corrupt blocks can be repaired with dbms_repair ; this utility does not
realy repair the blocks but marks them as software-corrupt so they can
be skipped when using the skip_corrupt flag; this may cause loss of data
(depending on the amount of corrupt blocks).
Before applying dbms_repair you must take a full offline backup of the
database so you can recreate the database if anything goes wrong : i.e.
ALL datafiles, controlfiles, redologs (not really necessary),
passwordfile, spfile; also issue a "alter database backup controlfile to
trace" command
Befor applying dbms_repair start reading the Oracle documentation :
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14231/repair
.htm
and
http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10739/repa
ir.htm
Good general description of DBMS_REPAIR you can find in the following
Articles :
http://www.dbazine.com/oracle/or-articles/fernandez4 (contains 1
typo: check_objects should be check_object)
http://www.oracleutilities.com/Packages/dbms_repair.html
Extensive description of dbms_repair procedures you can find in :
http://www.psoug.org/reference/dbms_repair.html
If you have a metalink account you can find the following bulletin(s) on
block corruption of interest :
note 77587 :
<<https://metalink.oracle.com/metalink/plsql/f?p=130:14:5232631821699756
89::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_
frame,p14_font:NOT,77587.1,1,0,1,helvetica>>
Good luck, you'll need it
Hans
Bottom line : always take a backup (preferably with RMAN) of your
database and archives
-----Original Message-----
From: Abdulla [mailto:abdulla.[Email address protected]
Sent: dinsdag 3 april 2007 14:18
To: Wijte, J.F. (Hans)
Subject: RE: block currupted in system tbs
**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret **from
this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text
HI,
NO NO I DON'T HAVE ANY CONTRACT WITH ORACLE
-----Original Message-----
From: Hans
[Email address protected]
Sent: Tuesday, April 03, 2007 5:49 PM
To: LazyDBA Discussion
Subject: RE: block currupted in system tbs
Do you have a support contract with Oracle support ?
These problems should be dealt with under the guidance of Oracle
Technical Support
Hans
-----Original Message-----
From: Wijte, J.F. (Hans)
Sent: dinsdag 3 april 2007 14:07
To: 'Abdulla '; LazyDBA Discussion
Subject: RE: block currupted in system tbs
Open a support request with Support
Hans
-----Original Message-----
From: Abdulla
[mailto:oracledba-ezmlmshield-x18243083.[Email address protected]
Sent: dinsdag 3 april 2007 12:25
To: LazyDBA Discussion
Subject: block currupted in system tbs
Hi,
How to remove corrupted block from system tbs
db in archive mode but I don't have any backup of system tbs and also
don't have full archive backup. So pls guide me it's urgent..
Regards,
A M Syed
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you receive
this message by mistake, you are hereby notified that any disclosure,
reproduction, distribution or use of this message is strictly
prohibited. Please inform the sender by reply transmission and delete
the message without copying or opening it.
Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the files have
NOT been scanned for viruses by the ING mail domain. Always scan
attachments before opening them.
-----------------------------------------------------------------
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.
Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------
Oracle LazyDBA home page