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: recover table after drop

RE: recover table after drop

From: <ddorr.cs_at_clearstream.com>
Date: Mon, 25 Sep 2000 10:55:45 +0200
Message-Id: <10630.117740@fatcity.com>


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_at_md.transnet.de]
> Reply To: ORACLE-L_at_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 <ORACLE-L_at_fatcity.com>
> > 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_at_ccss.sa.cr]
> > > Reply To: ORACLE-L_at_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_at_ccss.sa.cr
> > >
> > >
> =
------------------------------------------------------------------------=
-
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Alexander Ordonez
> > > INET: aordonez_at_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_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).
>=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_at_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_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
Received on Mon Sep 25 2000 - 03:55:45 CDT

Original text of this message

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