Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Data corruption

Re: Data corruption

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 18 Apr 2005 13:33:48 -0700
Message-ID: <bf4638050418133357a92a12@mail.gmail.com>


>
> #corrupt one block
> dd conv=notrunc if=/dev/zero of=/u01/oradata/dv03/corrupt.dbf bs=8192
> seek=10 count=1
>
>

This bit will actually work better if you use something other than /dev/zero to wipe out a block.

I used a file of 1048576 'Y' characters.

If you use /dev/zero, the table just disappears from the file, though still in the DD.
( Oracle initializes its files with chr(0))

perl -e 'for ($i=1;$i<=2**20;$i++){print "Y"}' >| yes.txt

dd conv=notrunc if=yes.txt of=/u01/oradata/dv03/corrupt .dbf bs=8192 seek=10 count=1

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 18 2005 - 16:37:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US