Re: DBA WARNING - Recovery doc errors
Date: Sat, 19 Mar 94 18:38:28 -0500
Message-ID: <pw7soRc.rshunter_at_delphi.com>
OMT demo account <omt_at_pt4427.pto.ford.com> writes:
>Problem: A user deletes a few thousand rows from a table that other
> users share. You can't just restore the table for one
> at the expense of the rest. You need a seperate copy to
> restore so you can pull the rows and insert them into the
> production table.
>
This sounds like exactly the sort of situation you could guard against
using Oracle7 Server and triggers; the before-change or delete copy of
each row can be journalled automatically to another table that you could
periodically truncate after backups.
Recovery of complex multiuser, multiple activity situations, especially
if sequence numbers are involved, from user or programmer/developer
errors, can be a pain otherwise.
Received on Sun Mar 20 1994 - 00:38:28 CET