Re: switch logfile question

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Fri, 30 Mar 2001 20:02:47 +0100
Message-ID: <3ac5a5c0$0$12249$cc9e4d1f@news.dial.pipex.com>

alter system switch logfile will switch the current logfile.

alter system archive log (all/current) will cause manual archiving.

As you indicate you are in archivelog mode the net effect is probably the same, however they are conceptually different commands.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Syltrem" <syltrem_at_videotron.ca> wrote in message
news:JrNw6.1304$Eg1.123028_at_wagner.videotron.net...


> Hi Oracle gurus!

>

> Is there a difference between the 2 statements:

> Alter system archive log current

> Alter system switch logfile

>

> I do the former before I backup my .ARC files. Will the 2 do the exact

 same


> thing?

>

> Thanks!

>

> --

>

> Syltrem

> http://pages.infinit.net/syltrem

>

>

>

Received on Fri Mar 30 2001 - 13:02:47 CST