RE: DBMS_REPAIR package usage

I do run the dbv against a down database. The same result happened.

If FTP, copy are all okey, it means that the block is not a media corrupted block. It does not stop it from being a software corrupted block. If exp works fine, it only tells us that there is currently no data/object in that "corrupted block".

Oracle support did tell me that if Oracle tried to create or reclaim the corrupted block, it will reformat the block. I cannot find out if it is true of not since it is impossible for me to force Oracle to create an object in those corrupted blocks! (too fragmented!)

Winnie

Mandar Ghosalkar <MandarG_at_gsr-inc.com>@fatcity.com on 03/22/2001 04:21:34 PM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

since does not change datablock u can run it against online datafiles. but it would report blocks as corrupted which are being changed. offline or shutdown is the best way.

if u cant bring it down, try running analyze table validate structure cascade

-Mandar

> -----Original Message-----
> From: Riyaj_Shamsudeen_at_i2.com [mailto:Riyaj_Shamsudeen_at_i2.com]
> Sent: Thursday, March 22, 2001 5:12 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: DBMS_REPAIR package usage
>
>
>
> I would not decide whether a block is corrupted or not, just using dbv
> utility. dbv reports corruption, even when analyze, exp and FTS goes
> through fine without any problem. dbv reported a data
> dictionary corruption
> in our case. We ran analyze, exp and FTS, no problem. But
> still dbv was
> reporting corruption even after the database was down.
>
> Further the database has to be down or the tablespace has to
> be offline
> normal for dbv to work somewhat correctly (?)
>
> Thanks
> Riyaj "Re-yas" Shamsudeen
> Certified Oracle DBA
> i2 technologies www.i2.com
>
>
>
>
> Winnie_Liu_at_in
>
> fonet.com To: Multiple
> recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent by: cc:
>
> root_at_fatcity. Subject:
> DBMS_REPAIR package usage
> com
>
>
>
>
>
> 03/22/01
>
> 04:22 PM
>
> Please
>
> respond to
>
> ORACLE-L
>
>
>
>
>
>
>
>
>
>
>
> To all,
>
> I have a datafile in my production box (a user data
> tablespace), when I run
> dbv against it, it showed that 5 blocks are "influxed"
>
> Page 458784 is influx - most likely media corrupt
> ***
> Corrupt block relative dba: 0x24070020 file=0. blocknum=458784.
> Fractured block found during dbv:
> Data in bad block - type:0. format:0. rdba:0x00000000
> last change scn:0x0000.00000000 seq:0x0 flg:0x00
> consistancy value in tail 0x0003c204
> check value in block header: 0x0, check value not calculated
> spare1:0x0, spare2:0x0, spare2:0x0
>
> We can copy this file to tape, dd this file. On the OS disk
> level, the OS
> does not treat this as corrupted. But it is corrupted on the oracle
> (software) level.
>
> I've checked and can't find any object associate with these 5
> corrupted
> blcok.
>
> That means that there is no data inside those blocks.
>
> Since the tablespace is about 12 GB on a highly active system
> (which only
> got 3 hours maintance window each month), export/import (then drop the
> tablespace)
> which Oracle support suggested is mostly out of the question.
> (Especially,
> it is very hard for me to convince the sysadmin that the blocks are
> corrupted
> as they don't see any I/O error associate with this file and
> the developers
> don't see any problem with the application either!)
>
> I am currently thinking about upgrading this database to
> 8.1.6 to make use
> of the DBMS_REPAIR package to make those blocks as "unusable". But I
> am not sure that if the DBMS_REPAIR package can run against the blocks
> which do not belong to any objects!! Can someone give me some
> guidences?
>
> thanks
>
> Winnie
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Winnie_Liu_at_infonet.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Riyaj_Shamsudeen_at_i2.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mandar Ghosalkar
  INET: MandarG_at_gsr-inc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Winnie_Liu_at_infonet.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).