Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Whats the difference between....
While their purposes are different, when you are in ARCHIVELOG mode the
effect is the same for both commands, i.e. the current redo log file is
archived and the next redo log file becomes the current log.
However, under NOARCHIVELOG mode, the ALTER SYSTEM SWITCH LOGFILE command will cause the current redo log file to be switched to the next log group, but no archiving will take place. The ALTER SYSTEM ARCHIVE LOG CURRENT command will fail because you cannot archive the current redo log file in NOARCHIVELOG mode; even though you can archive the older, non-current redo files.
Hope this helps.
John.
Fred Dinage wrote in message <7tkb00$sk1$1_at_pheidippides.axion.bt.co.uk>...
>alter system archive log current
>
>and
>
>alter system switch logfile
>
>
>dont they both just switch logfiles?
>
>Cheers
>
>Fred Dinage
>
>
Received on Sun Oct 10 1999 - 21:51:18 CDT