Re: Backup

In article <34D90320.B1A86009_at_iname.com>, S Chavali <nospam_at_iname.com> 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.

In some installations, I have put in a redundant backup consisting of spooling out the contents of every table into flat ascii files. Then you can just grep or edit for the rows that you need when the operators go "oops." They then think you are like unto a demigod. This can be quite "fun" when combined with integrity.

>--
>Hope this helps !
>Regards,
>Srini
>(to reply via email, please change "nospam" to "chavali" in my email address
>- :-) )
>
>

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry@eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the @#%*& DBA!