Re: Q:Recover until a CHKPoint ?

From: Frank Kobylanski <frank_kobylanski_at_purina-mills.com>
Date: 1997/01/31
Message-ID: <5csreo$hsb$1@newsin-1.starnet.net>#1/1

Look for Oracle document 105867.682. This describes how to recover a dropped table from a full db backup. It basically entails recreating the db off to the side (preferably on another machine), restoring the necessary files (system, rollback and the ts that the table resides in) and then export the table that you want.

It can take awhile and it may take a few attempts to get it right but it works like a champ.

HTH Frank
"Lun Wing San (Oracle)" <wslun_at_qrcsun.qrc.org> wrote:

>Pere Juanola wrote:
>>
>> If a user deletes a tables, or drops it, how can I restore this tables
>> from a previous Full Backup (I'm doing daily backup) ?
>>
>> It is possible to recover the database until a Checkpoint (the one
>> before the deletion of the table) ?
>>
>> I have the database in ARCHIVER mode.

> You can do it by using INCOMPLETE RECOVERY. You can recover the database until a
>SCN.

>---
>Name : Lun Wing San
>Title : Oracle Application Developer of Hong Kong Productivity Council
> Oracle Database Administrator and System Administrator of QRC
>Phone : (852)27885841
Received on Fri Jan 31 1997 - 00:00:00 CST