Re: Recover from a deleted table

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 16 Jan 2001 09:34:19 -0000
Message-ID: <9414j4$hit$1@soap.pipex.net>

Well you can recover a tablespace to a specific point in time. There are conditions where this would involve no data loss (for example read only tablespaces). However this functionality was only introduced in Oracle 8.1 (I believe It could be 8.0.5 but I don't have the docs for that version. It is NOT available for a 7.3.4 database.

As the original poster says the options depend somewhat on your backup strategy. You state that you have the archive logs so what you could do is recreate the database elsewhere and then perform timebased recovery on this copy database. At this point export from the copy database and impot into the original production database. If you don't have the necessary backups to do this then you would have to import from an old export, prior to dropping the table. This may, and probably will, involve data loss. If you can get hold of a copy of the backup and recovery course notes this very scenario is covered in them. There used to be excellent documentation at Howard Rogers site on geocities but this seems to have gone AWOL.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Andreas Goldammer" <agoldammer_at_viega.de> wrote in message
news:3a63ec8e$0$8787$73bec562_at_personalnews.de.uu.net...


>

> "dgdss" <dgdss_at_hotmail.com> schrieb im Newsbeitrag

> news:CsN86.300358$_5.67854298_at_news4.rdc1.on.home.com...

> > You could recover the tablespace the table was in, up to the point in

 time


> > of the deletion. It depends on your Backup plan, are u using archiving ?

> > have you even been backing up the DB ?

> > "Afonso Pedrosa" <jpedrosa_at_hospitalfeira.min-saude.pt> wrote in message

> > news:93v9gs$nou$1_at_venus.telepac.pt...

> > > Can anyone tell me if there is a way to recover from a deleted table

 without


> > > recriating a 7.3.4 oracle database

> > > in another machine with the backup(with archives)?

> > >

> > >

> >

> >

> Think you can't recover a tablespace with "point-in-time". The ORACLE

> documentation 8.0.x shows this option only for the database. This makes

> sense, bacause the point-in-time recovery of a single tablespace would

> leave the database in an inconsistent state.

>

> Please tell me if I'm wrong.

>

>

Received on Tue Jan 16 2001 - 03:34:19 CST