Re: Manual Switch of Logfile

The 2 command don't have the same effect.

ALTER SYSTEM SWITCH LOGFILE
means

    stop using current logfile group X and switch to the next one in the online redo-log structure
It works in ARCHIVELOGMODE and in NOARCHIVELOGMODE (because it works on online structures)

ALTER SYSTEM ARCHIVE LOG CURRENT
means

    stop using current logfile group X, switch to the next one in the online redo-log structure and archive the group X to the destination specified (by parameters or by command line)
It works only in ARCHIVELOGMODE

--
I hope this helps

Eugenio
remove _nospam from reply address

Opinions are mine and do not necessarily reflect those of my company

=======================================================
mikea_at_best.com wrote in message <8hpoat$3qm$1_at_nnrp1.deja.com>...


>This may be a dumb question, but I noticed that there are two methods

>to force a logfile switch:

>

>1) ALTER SYSTEM SWITCH LOGFILE;

>

>and

>

>2) ALTER SYSTEM ARCHIVE LOG CURRENT;

>

>Why are there two different commands to do the same thing?

>

>Thanks!!!

>Mike

>

>

>Sent via Deja.com http://www.deja.com/

>Before you buy.