Re: Database BackUp

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

Hi,

before you intend to backup the archive logs be sure that they aren't in use, means that oracle just doesn't write the newest one. Some OS allow (as oracle support told me) to read (and backup) such incomplete log files.
To be sure that all online redologs are archived switch logfiles <number of logfiles +1> times (ALTER SYSTEM SWITCH LOGFILE; ) and then backup the archives.

-- 
Regards

Matthias Gresz    :-)