Re: Database BackUp

Does this mean if I loose a redo file before it fills up (ie copied to the Archived Directory), I would loose any data that is in the redo file. So does it make sense to force the current redo file to be Archived (is this possible ? ) before the nightly backup.

Paul

John P. Higgins wrote:

> 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 Fri Dec 05 1997 - 00:00:00 CST