Re: Question Regarding switching logfiles

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Sat, 12 Apr 2003 16:52:00 +1000
Message-ID: <GxOla.12547$1s1.207381@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.

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

Regards
HJR
>
>
> Thanks,
> CC
>
>
>
> -----------== Posted via Newsfeed.Com - Uncensored Usenet News
==----------
> http://www.newsfeed.com The #1 Newsgroup Service in the World!
> -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers
=----- Received on Sat Apr 12 2003 - 01:52:00 CDT