Re: Backup

Of course, having a recent export of the table would be ideal, but, if you don't have one there is one other way I can think of. If you have another box available (development server?) with enough resources
recover the database on that server up the to point in time just before the bad update/deletes occurred. Get the rows you need from the table and put them back
into your production table (sqlldr, manually, database link insert...however).
It is not easy, but it can be done.

M.Landa

S Chavali wrote:

> Priya Pattada wrote:
>
> > Hello,
> >
> > I have a question, if a user on the system accidently updated or
 deleted
> > the wrong rows of a table and signed off the system, what type of
 backup
> > would the DBA need for recovery? The rows that were updated wrongly
 need
> > to be got back without losing any other rows that have been updated
 and
> > commited by other users
> > during the same period of time.
> >
> > Thank you in advance for your help.
> > Priya
>
> As far as I know, this is impossible using recovery. Recovery to a
> point in
> time involves recovering the whole database and cannot be done for
> just a
> table.
> --
> Hope this helps !
> Regards,
> Srini
> (to reply via email, please change "nospam" to "chavali" in my email
> address
> - :-) )
Received on Wed Feb 04 1998 - 00:00:00 CST