Re: Partial Database Recovery

Luis-
Backup current database.
Restore from a backup.
Recover to a point where the deleted table exists. Export the table.
Restore from current backup.
Import the 'lost' table.

John Steinbach

Luis Santos wrote:

> Hello all!
>
> Is it possible to do a partial tablespace recovery? Let's
> suppose that one user accidently drop a table. The table are located
> in tablespace A. Then, I recover from last backup then datafile of
> tablespace A and recover it until one minute before the drop.
>
> I got the information that this is only possible with a FULL
> tablespace recovery, when I restore ALL datafiles... If I restore just
> one tablespace datafile I can just do FULL recovery.
>
> I think this is a bad implementation of recovery, and I really
> can't believe this limitation is true...
>
>
>
>
>
> Best Regards,
> --
> Luis Santos
> Banco InterAtlântico
> Path: news.panix.com!panix!cam-news-hub1.bbnplanet.com!su-news-hub1.bbnplanet.com!news.bbnplanet.com!logbridge.uoregon.edu!news.uoregon.edu!news.unisys.com.br!not-for-mail
> From: lsantos_at_pobox.com (Luis Santos)
> Newsgroups: comp.databases.oracle.server
> Subject: Partial Database Recovery
> Date: Wed, 17 Sep 1997 19:53:02 GMT
> Organization: Banco InterAtlântico
> Lines: 22
> Message-ID: <342229de.11605833_at_news.centroin.com.br>
> Reply-To: lsantos_at_pobox.com,lsantos_at_bancointeratlantico.com.br
> NNTP-Posting-Host: riopm03p21.unisys.com.br
> Mime-Version: 1.0
> Content-Type: text/plain; charset=ISO-8859-1
> Content-Transfer-Encoding: 8bit
> X-Newsreader: Forte Agent 1.5/32.451
>
> Hello all!
>
> Is it possible to do a partial tablespace recovery? Let's
> suppose that one user accidently drop a table. The table are located
> in tablespace A. Then, I recover from last backup then datafile of
> tablespace A and recover it until one minute before the drop.
>
> I got the information that this is only possible with a FULL
> tablespace recovery, when I restore ALL datafiles... If I restore just
> one tablespace datafile I can just do FULL recovery.
>
> I think this is a bad implementation of recovery, and I really
> can't believe this limitation is true...
>
>
>
>
>
> Best Regards,
> --
> Luis Santos
> Banco InterAtlântico
Received on Wed Sep 17 1997 - 00:00:00 CDT