Re: Question Regarding switching logfiles

From: Rick Anderson <Richard.Anderson_at_oracle.com>
Date: Sat, 12 Apr 2003 11:38:35 GMT
Message-ID: <Xns935B4CA404C9ARichardAndersonoracl@148.87.1.53>

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in news:GxOla.12547$1s1.207381_at_newsfeeds.bigpond.com:

>
> "Chuck" <ccarson_at_echeeba.com> wrote in message
> news:3E977A96.8020307_at_echeeba.com...

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

>
> Causes LGWR to start writing redo to the next log. If you happen to be
> in archive log mode, it happens to also cause the log being switched
> away from to be archived. Works whether in archive log mode or not.

NOTE: In a RAC environment, this switches the *current* instance, only...

>>
>> 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.

NOTE: In a RAC environment, this may cause some or *all* instances to switch logfiles and archive the previous currents...

Very subtle difference between the 2 commands.

>
> Regards
> HJR
Received on Sat Apr 12 2003 - 06:38:35 CDT