Re: incremental backups

If you are using Oracle 8, you could use RMAN for incremental physical backups.
You could (as always) use exp for incremental logical backups (mark the distinction).
Source control only exists in client products like Developer 2000, both for PVCS and Tuxedo.
Didn't work with that though.

Hth,

Sybrand Bakker, Oracle DBA

<nwsread_at_cloudband.com> wrote in message news:37b6f036_at_glitch.nildram.co.uk...
> Hi, i am wondering what facilities oracle has
> for incremental backups. This is backups only of what
> has changed since the previous backup so that it would
> happen very quickly. Instead of backing up the whole
> database which would take a long time.
> My reason for this question is that if we have bugs
> in our code where say we are updating the wrong rows, we could
> recover from much of our destruction by restoring from backups,
> and if incremental backups were possible they could be done more
> often then full backups.
>
> What would be optimal however is some type of table
> version control similiar to what cvs does with src files, where
> we could restore the table to any state depending on timestamp
> or user tag.
>
>
>
Received on Sun Aug 15 1999 - 15:57:52 CDT