Re: recover table after drop

Hi,
I am also fully DISagree with you. OK, archived logs only aint a solution because the MTTR is to high, but we can help this guy:

create tablespace test01 datafile '/ora/u04/oradata/stock1/test01.dbf' size 20 m;

create user test identified by blabla default tablespace test01 quota unlimited on test01;

grant resource,connect to test;

connect test

create table test(id number);

insert into test values(1);

/

/

/

!rm /ora/u04/oradata/stock1/test01.dbf

connect internal

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

alter tablespace temp01 offline;

alter database datafile '/ora/u04/oradata/stock1/test01.dbf' offline;

alter database create datafile '/ora/u04/oradata/stock1/test01.dbf';

recover datafile '/ora/u04/oradata/stock1/test01.dbf';

alter tablespace test01 online;

select * from test.test;  

        ID

         1
         1
         1
         1

qed.

oli.

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óñez Arroyo
> > > Administrador Tru64Unix
> > > Caja Costarricense del Seguro Social
> > > División de Informática Soporte Técnico
> > > Telefono: 295-2004, San José, 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).

-- 
---

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