Re: Database BackUp

From: John P. Higgins <jh33378nospam_at_deere.com>
Date: 1997/12/03
Message-ID: <34863B71.7D2D@deere.com>#1/1

Yes, but with a few additions.

Oracle logs all transactions into the redo logs. When one log is filled, Oracle switches to the next log file. When the last file is filled, Oracle switches back to the first.

This is where the ARCHIVELOG mode comes in. If you set this mode, Oracle guarantees not to overwrite the redo log files until they have been copied to an archival directory. It is this directory that you would backup nightly.

Paul Short wrote:
>
> Hi
>
> Using Sybase I can back up the transaction log which contains changes
> since my last full backup. I need this because the database is to big to
> do all full backup on weekdays.
>
> Are the redo files a similar concept in oracle, i.e. if I backup all the
> tablespaces on the weekend and the redo files on weekdays and I need to
> recover the database I would recover the backed up tablespaces and then
> copy back the redo files.
>
> Thanks
Received on Wed Dec 03 1997 - 00:00:00 CST