Message-Id: <10630.117740@fatcity.com> From: ddorr.cs@clearstream.com Date: Mon, 25 Sep 2000 10:55:45 +0200 Subject: RE: recover table after drop This is really a nice demo, but : 1) The user didn't drop a datafile, but a table, which is - AFAIK - NOT recoverable, 2) What you did only worked because, even you've removed the file on = unix, the file (and data it contains) was still here as Oracle kept it open. Try to shutdown oracle / rm your datafile on unix / startup oracle / do = your recover and come back with the results ... > ---------- > From: Oliver Artelt[SMTP:oli@md.transnet.de] > Reply To: ORACLE-L@fatcity.com > Sent: Saturday, September 23, 2000 22:55 > To: Multiple recipients of list ORACLE-L > Subject: Re: recover table after drop >=20 >=20 > Hi, > I am also fully DISagree with you. OK, archived logs only aint a = solution=20 > because the MTTR is to high, but we can help this guy: >=20 > create tablespace test01 datafile = '/ora/u04/oradata/stock1/test01.dbf' > size=20 > 20 m; >=20 > create user test identified by blabla default tablespace test01 > quota unlimited on test01; >=20 > grant resource,connect to test; >=20 > connect test >=20 > create table test(id number); >=20 > insert into test values(1); >=20 > / >=20 > / >=20 > / >=20 > !rm /ora/u04/oradata/stock1/test01.dbf >=20 > connect internal >=20 > shutdown > ORA-01116: error in opening database file 10 > ORA-01110: data file 10: '/ora/u04/oradata/stock1/test01.dbf' > ORA-27041: unable to open file >=20 > alter tablespace temp01 offline; >=20 > alter database datafile '/ora/u04/oradata/stock1/test01.dbf' offline; >=20 > alter database create datafile '/ora/u04/oradata/stock1/test01.dbf'; >=20 > recover datafile '/ora/u04/oradata/stock1/test01.dbf'; >=20 > alter tablespace test01 online; >=20 > select * from test.test; > =20 > ID > ---------- > 1 > 1 > 1 > 1 >=20 > qed. >=20 > oli. >=20 >=20 > On Sat, 23 Sep 2000, Ajay Kothari wrote: > > I am also fully agree with you that Archived Logs doesn't give = instant > > solution for this kind of problem. > > > > Ajay > > = _______________________________________________________________________ > > Keep smiling !!! Visit us at www.lipidata.com > > ----- Original Message ----- > > To: Multiple recipients of list ORACLE-L > > Sent: Thursday, September 21, 2000 05:10 PM > > > > > > > > Archived logs are useless if you don't have a good old backup to = start > > from. I'm afraid you're stuck ... :-( > > > > > ---------- > > > From: Alexander Ordonez[SMTP:aordonez@ccss.sa.cr] > > > Reply To: ORACLE-L@fatcity.com > > > Sent: Thursday, September 21, 2000 01:16 > > > To: Multiple recipients of list ORACLE-L > > > Subject: recover table after drop > > > > > > > Hi DBA's > > > > I need help for recovery table after drop, i don't have backup, > exists > > > > > > any > > > > > > > forms???? > > > > only have a archivelog.... > > > > > > > > any idea????????????? > > > > > > > = ------------------------------------------------------------------------= - > > > > > > > Lic. Alexander Ord=F3=F1ez Arroyo > > > > Administrador Tru64Unix > > > > Caja Costarricense del Seguro Social > > > > Divisi=F3n de Inform=E1tica Soporte T=E9cnico > > > > Telefono: 295-2004, San Jos=E9, Costa Rica > > > > Aordonez@ccss.sa.cr > > > > > > > = ------------------------------------------------------------------------= - > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Alexander Ordonez > > > INET: aordonez@ccss.sa.cr > > > > > > 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@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). >=20 > --=20 > --- >=20 > Oliver Artelt, System- und Datenbankadministration > --------------------------------------------------------------- > cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg > telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 > email: oli@cubeoffice.de # web: http://www.cubeoffice.de > --------------------------------------------------------------- > --=20 > Please see the official ORACLE-L FAQ: http://www.orafaq.com > --=20 > Author: Oliver Artelt > INET: oli@md.transnet.de >=20 > 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@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L