Re: corrupted block

dd if=$HOME/.profile of=/u01/oradata/PROD/blahblah01.dbf bs=8192 seek=10

or

sqlplus "/ as sysdba"
spool /u01/oradata/PROD/blahblah01.dbf
...
spool off

it doesn't take much!

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, February 26, 2003 2:14 PM

>
> That's the cutest corruption I've ever seen -
> it looks like someone has been practising
> there C programming with "How to write direct
> to an Oracle data file without using Oracle"
>
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Coming soon one-day tutorials:
> Cost Based Optimisation
> Trouble-shooting and Tuning
> Indexing Strategies
> (see http://www.jlcomp.demon.co.uk/tutorial.html )
>
> ____UK_______March 19th
> ____USA_(FL)_May 2nd
>
>
> Next Seminar dates:
> (see http://www.jlcomp.demon.co.uk/seminar.html )
>
> ____USA_(CA, TX)_August
>
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: 26 February 2003 19:14
>
>
> > Here you go:
> >
> > ***
> > Corrupt block relative dba: 0x0240000a (file 9, block 10)
> > Bad header found during buffer read
> > Data in bad block -
> > type: 32 format: 0 rdba: 0x20202020
> > last change scn: 0x2020.20202020 seq: 0x20 flg: 0x20
> > consistency value in tail: 0x20202020
> > check value in block header: 0x2020, block checksum disabled
> > spare1: 0x20, spare2: 0x20, spare3: 0x2020
> > ***
> > Reread of rdba: 0x0240000a (file 9, block 10) found same corrupted
> data
> >
> >
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jonathan Lewis
> INET: jonathan_at_jlcomp.demon.co.uk
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
-- 
Author: Tim Gorman
  INET: Tim_at_SageLogix.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).