Re: Q:Recover until a CHKPoint ?

From: Lun Wing San (Oracle) <wslun_at_qrcsun.qrc.org>
Date: 1997/01/30
Message-ID: <32F0C5DB.7A2B@qrcsun.qrc.org>#1/1

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 Thu Jan 30 1997 - 00:00:00 CST