Re: Incremental backup on Oracle?

In article <39mlsl$q5h_at_hk.super.net>, wmlee_at_ha.org.hk (Lee Wai Man) writes:
> Sorry about the invisible message. Let me try it one more time:
>
> Hi everybody, I am trying to find out if it is feasible to do
> on-line incremental backup of the Oracle database, like the
> "dump transaction" command in Sybase? In other words, can I
> do a full database backup at the beginning of the month and
> then backup only the control files and the archived redo-logs
> in the subsequent days, and still be able to restore the
> database up to the most updated archived redo-log when there
> is a media failure? (say if I only have the full backup and a
> whole bunch of control files and archived redo-logs)
> If you have any idea, I would appreciate if you can post the
> procedures in detail.
>
> Thanks.
>
>
> Wai-man

Actually, it sounds like you've described the process pretty well.

I described our backup/recover process in reasonable detail in an earlier item in this newsgroup (#20963).

I think that the only difference that you would have would be that you would periodically backup your control file and copy the archived log files off to tape.

-- 
Bob Swisshelm                | swisshelm_at_Lilly.com     | 317 276 5472
Eli Lilly and Company        | Lilly Corporate Center  | Indianapolis, IN 46285