On Aug 2, 9:59 am, Stefan Wetter <swet..._at_arcor.de> wrote:
> Hello!
>
> Can someone please explain to me what exacly is the difference between
> the two commands:
>
> ALTER SYSTEM ARCHIVE LOG CURRENT;
> ALTER SYSTEM SWITCH LOGFILE;
>
> Thank you!
> Stefan
You did RTFM?
Anyway, the latter command forces Oracle to switch from one online
redolog file to the next one.
As a result of that, the oldest online redolog might need to be
archived.
The former command archives the most recent unarchived redo logfile.
--
Sybrand Bakker
Senior Oracle DBA
Received on Thu Aug 02 2007 - 03:25:36 CDT
