Re: Question Regarding switching logfiles

From: Tanel Poder <tanel_at_@peldik.com>
Date: Sun, 13 Apr 2003 21:02:21 +0300
Message-ID: <3e99a561$1_2@news.estpak.ee>

Hi!

> >> What exactly is the difference between the following two commands:
> >>
> >> alter system switch logfile

[snip]
> >> alter system archive log current
> >
> > Causes the current log to be archived, and happens to also induce a
> > log switch. Not a meaningful command if you're not in archive log
> > mode.

[snip]

> Very subtle difference between the 2 commands.

Only when doing online backup, one should always rely on archive log current when considering a backup done - when archive log current completes, it is quaranteed, that the log is shipped to all mandatory locations. Alter system switch logfile is asynchronous in that sense..

Tanel. Received on Sun Apr 13 2003 - 13:02:21 CDT