> On Fri, 7 May 1999, Mio Mio wrote:

> Mr. Ari Kaplan:
> 
> Hi. I believe this is the first time for me to email you personally.
> We don't have much knowledge in Oracle administration much more with backup
> and recovery procedure so I though I should seek your expert advise.
> 
> We really need help at this point in time. 
> We have just made the mistake of updating several tables with the wrong set
> of data a while ago.
> The wrong update was done on a production database. As such it will
> definitely have big implications.
> 
> Is it still possible for us to _restore_ all those data?
> What we have is a full database backup done 3 days ago.
> 
> Please advise.
> 
> Thanks in advance.
> 
> Mio-Nino P. Marquez
Mio Nino,

The answer to your question depends on how you were backing up the
database. If you were using exports, then you can truncate or drop the
tables that need recovering and import the data just for those tables.

If your full backup was successful, you can recover the database in full
up to the point that you took the backup. If you are in ARCHIVELOG mode
and have all archived redo logs, then you can recover until ANY point
after your full backup.

Before you try anything, I recommend shutting down the database and making
another FULL backup of your current data, just in case.

Best regards and best of luck,

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 280+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             www.arikaplan.com                                 <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page x.htm"> Back to Ari Kaplan's Home Page