| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How do I corrupt a block
talk to your lead duhveloper..they are usally good at that ;-)
Sunil Nookala
Dell Corp
Austin, TX
-----Original Message-----
Sent: Thursday, May 31, 2001 5:06 PM
To: Multiple recipients of list ORACLE-L
unfortunately i am on NT
I can not use BBED because i don't know the password
is there any other way
> I do not recommend this, but since you are bent on doing this:
> (Hope you are on Unix)
>
> From an earlier post:
>
> Ferenc, try the following:
> dd if=/dev/zero of=myfile bs=4096 oseek=9876 count=100.
> If that doesn't corrupt it, nothing will.
> Happy hunting!
>
> ===
> Mladen Gogala
>
>
>
>
>
> -----Original Message-----
> From: novicedba [mailto:novicedba_at_hotmail.com]
> Sent: Thursday, May 31, 2001 2:16 PM
> To: Multiple recipients of list ORACLE-L
> Subject: How do I corrupt a block
>
>
> hi,
> This may sound funny. I want to know how to corrupt a block. I want to
> test the different methods of identifying block corruption, but I don't
have
> sample data blocks.
> Please help me
>
> novice
>
>
> From another posting:
>
>
>
> Thanks to everyone who responded - this was the solution that worked for
me:
> SVRMGR> select count(*) from ccpinp;
> COUNT(*)
> ----------
> ORA-01578: ORACLE data block corrupted (file # 4, block # 5204)
> ORA-01110: data file 4: '\SV\ALM\ADM\ALMDS1.TSP'
> SVRMGR> select segment_name, segment_type from dba_extents
> 2> where file_id = 4 and 5204 between block_id and block_id + blocks - 1;
> SEGMENT_NAME SEGMENT_TYPE
> --------------------------------------------------------------------------
--Received on Thu May 31 2001 - 16:49:25 CDT
> ---- -----------------
> CCPINP TABLE
> 1 row selected.
> SVRMGR> select index_name from dba_indexes where table_name = 'CCPINP';
> INDEX_NAME
> ------------------------------
> PK_CCPINP
> CCPINP_2
> CCPINP_3
> 3 rows selected.
> SVRMGR> create table temp as select * from ccpinp where 1 = 2;
> Statement processed.
> SVRMGR> insert into temp select /*+ ROWID(CCPINP) */*
> 2> from ccpinp
> 3> where rowid between '00000000.0000.0000' and
> 4> '00001453.FFFF.0004';
> 59 rows processed.
> SVRMGR> insert into temp select /*+ ROWID(CCPINP) */*
> 2> from ccpinp
> 3> where rowid between '00001455.0000.0004' and
> 4> 'FFFFFFFF.FFFF.FFFF';
> ORA-01578: ORACLE data block corrupted (file # 4, block # 5205)
> ORA-01110: data file 4: '\SV\ALM\ADM\ALMDS1.TSP'
> SVRMGR> insert into temp select /*+ ROWID(CCPINP) */*
> 2> from ccpinp
> 3> where rowid between '00001456.0000.0004' and
> 4> 'FFFFFFFF.FFFF.FFFF';
> ORA-01578: ORACLE data block corrupted (file # 4, block # 5206)
> ORA-01110: data file 4: '\SV\ALM\ADM\ALMDS1.TSP'
> SVRMGR> insert into temp select /*+ ROWID(CCPINP) */*
> 2> from ccpinp
> 3> where rowid between '00001457.0000.0004' and
> 4> 'FFFFFFFF.FFFF.FFFF';
> ORA-01578: ORACLE data block corrupted (file # 4, block # 5207)
> ORA-01110: data file 4: '\SV\ALM\ADM\ALMDS1.TSP'
> SVRMGR> insert into temp select /*+ ROWID(CCPINP) */*
> 2> from ccpinp
> 3> where rowid between '00001458.0000.0004' and
> 4> 'FFFFFFFF.FFFF.FFFF';
> 869 rows processed.
>
> And to look at the rows with the corruption, I did the following:
>
> SVRMGR> select inst_id, chart_id, acct_id, attrib_id, rowid
> 2> from ccpinp
> 3> where inst_id >=0 and chart_id >=0 and acct_id >=0 and attrib_id >=0
> 4> and rowid like '00001455.%.0004';
> INST_ID CHART_ID ACCT_ID ATTRIB_ID ROWID
> ---------- ---------- ---------- ---------- ------------------
> 1 3 585 20 00001455.0000.0004
> 1 3 585 30 00001455.0002.0004
> 1 3 585 50 00001455.0004.0004
> 3 rows selected.
> SVRMGR> select inst_id, chart_id, acct_id, attrib_id, rowid
> 2> from ccpinp
> 3> where inst_id >=0 and chart_id >=0 and acct_id >=0 and attrib_id >=0
> 4> and rowid like '00001456.%.0004';
> INST_ID CHART_ID ACCT_ID ATTRIB_ID ROWID
> ---------- ---------- ---------- ---------- ------------------
> 1 3 721 140 00001456.0000.0004
> 1 3 721 150 00001456.0002.0004
> 1 3 721 160 00001456.0005.0004
> 3 rows selected.
> SVRMGR> select inst_id, chart_id, acct_id, attrib_id, rowid
> 2> from ccpinp
> 3> where inst_id >=0 and chart_id >=0 and acct_id >=0 and attrib_id >=0
> 4> and rowid like '00001457.%.0004';
> INST_ID CHART_ID ACCT_ID ATTRIB_ID ROWID
> ---------- ---------- ---------- ---------- ------------------
> 1 3 591 20 00001457.0000.0004
> 1 3 591 30 00001457.0002.0004
> 1 3 591 40 00001457.0004.0004
> 3 rows selected.
>
>
> Have a great weekend!!
> Jeff
>
>
>
>
>
>
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: novicedba INET: novicedba_at_hotmail.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: Sunil_Nookala_at_Dell.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).
 |
 |