Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Backup and Recovery Question

Backup and Recovery Question

From: Sanjay Kumar <ora_user_at_hotmail.com>
Date: Thu, 01 Feb 2001 09:10:12 -0800
Message-ID: <F001.002A78D5.20010201091610@fatcity.com>

Hi,
 

I have a situation like this.
 

I found a user dropping a table today at 9 AM but I came to know about that only at 2 PM the same day. I have a backup which was taken the previous day at 4 PM. My database runs in Archivelog mode.
 

I want to restore the table. If I put the database in recovery mode and recover using until time option then I may loose all the transactions that happened between 9 to 2. But I dont want to loose that.
 

I donot have a export.
 

How do I accomplish this?
 

Help Appreciated.
 

Vinay Received on Thu Feb 01 2001 - 11:10:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US