Re: Question on Backup and Recovery Software comments.

On Mon, 17 May 1999, Sybrand Bakker wrote:
>
> Backup only protects against power outage, disk failure etc.
> As during backup the database is being considered as a logical whole, it
> doesn't protect against users.
> If someone accidentally drops a table or deletes a few rows, and you don't
> have exports, you will be forced to recover them using point in time
> recovery, which can be very time-consuming, and will block everyone from
> using the database.

Consider that in the event of a logical corruption or an "oops," a user could recover the database in a separate location or with a different SID from the running production system. The user could even recover only the tablespace with the problem segments, plus the rollback and system tablespaces, saving space over restoring the whole database. The problem segments could then be exported and imported into the running production system. That way the user gets both point-in-time transactional coherence, and the whole database doesn't need to be taken down for recovery.

--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah Received on Mon May 17 1999 - 00:40:07 CDT