From oracle-l-bounce@freelists.org Tue Apr 19 02:54:58 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j3J7swvf017975 for ; Tue, 19 Apr 2005 02:54:58 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j3J7sw4Z017971 for ; Tue, 19 Apr 2005 02:54:58 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 72D16184009; Tue, 19 Apr 2005 01:52:40 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 00698-03; Tue, 19 Apr 2005 01:52:40 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E9D34183F8D; Tue, 19 Apr 2005 01:52:39 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Y9zP9QHhG/G7dd96IcJVoy1M5GMCfuHOLUTwJSeuk0vzmoRZQUh8hoUYOexPqEVMuBbdf4tBiBNkKfFWzHPu/NSShtrm7zKXRc58pKPc0l4TCqT9KraBObddV0oY1OluZnji2WhSq5fHYcMyMoBH4Rtx8/4rKoBKPNu8D8WQvmY= Message-ID: <69c522bf0504182350138a59f7@mail.gmail.com> Date: Tue, 19 Apr 2005 14:50:50 +0800 From: chunyu hu To: jkstill@gmail.com Subject: Re: Data corruption Cc: Mladen Gogala , peterdixon001@hotmail.com, oracle-l@freelists.org In-Reply-To: Mime-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Content-Disposition: inline References: <42642BAF.6060803@allegientsystems.com> X-archive-position: 18586 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: chunyuh@gmail.com Precedence: normal Reply-To: chunyuh@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.63 Another solution is bbed which is provedi by Oracle itself. Normally Oracle support use it for repairing blocks. Of course, you can use it to corrupt blocks. You need to compile bbed urself. $ cd $ORACLE_HOME/rdbms/lib $ make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed On 4/19/05, Jared Still wrote: > Yeah, that would probably wipe it out. > Makes it kind of hard to play with dbms_repair however. >=20 > On 4/18/05, Mladen Gogala wrote: > > > > Jared Still wrote: > > #! /usr/bin/perl -w > > # This is a fancy perl way to wipe out your entire system. > > use strict; > > use File::Find (); > > use vars qw/*name *dir *prune/; > > *name =3D *File::Find::name; > > *dir =3D *File::Find::dir; > > *prune =3D *File::Find::prune; > > > > sub wanted; > > > > # Traverse desired filesystems > > File::Find::find({wanted =3D> \&wanted}, '/'); > > exit; > > sub wanted { > > unlink($_); > > } > > > > use Cwd (); > > my $cwd =3D Cwd::cwd(); > > >=20 > -- > Jared Still > Certifiable Oracle DBA and Part Time Perl Evangelist >=20 > -- > http://www.freelists.org/webpage/oracle-l >=20 --=20 Thanks Chunyu Hu Welcome to visit my weblog http://mtsmart.kmip.net -- http://www.freelists.org/webpage/oracle-l