Message-Id: <10756.127721@fatcity.com> From: dgoulet@vicr.com Date: Mon, 29 Jan 2001 10:29:44 -0500 Subject: Re:Datafile corrupted I'm afraid your stuck with having to restore your last good backup. ____________________Reply Separator____________________ Subject: Datafile corrupted Author: Beatriz =3D?iso-8859-1?Q?Mart=3DEDnez=3D20Jim=3DE9nez?=3D Date: 1/29/2001 2:40 AM Hello all people, Well, I am going to expose what happens to me. I have tried to make a backup of my database, it's in NOARCHIVELOG mode. After starting it (without opening it) I have run the RMAN utility and I get an error, saying that my datafile system01.dbf is corrupted. So, after that, I run the DBverify utility to know more details of this corruption. And now, I know I have 30 corrupted pages, but I don't know what could I do with them. I have read something about the DBMS_REPAIR package, but I don't know how to use it because it repairs corrupt blocks only in tables and indexes, and there is nothing about files. Could somebody tell me whether I could mend it, or, on the contrary, it is a imposible task (It would be impossible for me if it were difficult to make...)? A lot of thanks in advance, Beatriz Hello all people,
 Well, I am going= to expose what happens to me. I have tried to make a backup of my database, it´s in NOARCHIVELOG mode.
 After starting i= t (without opening it) I have run the RMAN utility and I get an error, sayi= ng that my datafile system01.dbf is
 corrupted. So, a= fter that, I run the DBverify utility to know more details of this corruption.= And now, I know I have 30
 corrupted pages,= but I don´t know what could I do with them. I have read something about= the DBMS_REPAIR package, but I
 don´t know= how to use it because it repairs corrupt blocks only in tables and indexes, and there is nothing about files.
 Could somebody t= ell me whether I could mend it, or, on the contrary, it is a imposible task (It would be impossible for me if it
 were difficult t= o make...)?
 A lot of thanks = in advance, Beatriz begin:vcard = n:Mart=EDnez Jim=E9nez;Beatriz = x-mozilla-html:FALSE url:www.cidaut.es org:Fundaci=F3n CIDAUT;Departamento Inform=E1tica adr:;;Parque Tecnol=F3gico de Boecillo;Boecillo;Vallodolid;47151;Espa=F1a= version:2.1 email;internet:beamar@cidaut.es