Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: question to alter system with archivlogs

Re: question to alter system with archivlogs

From: sybrandb <sybrandb_at_gmail.com>
Date: Thu, 02 Aug 2007 01:25:36 -0700
Message-ID: <1186043136.235620.73500@g4g2000hsf.googlegroups.com>


On Aug 2, 9:59 am, Stefan Wetter <swet..._at_arcor.de> wrote:
> Hello!
>
> Can someone please explain to me what exacly is the difference between
> the two commands:
>
> ALTER SYSTEM ARCHIVE LOG CURRENT;
> ALTER SYSTEM SWITCH LOGFILE;
>
> Thank you!
> Stefan

You did RTFM?
Anyway, the latter command forces Oracle to switch from one online redolog file to the next one.
As a result of that, the oldest online redolog might need to be archived.
The former command archives the most recent unarchived redo logfile.

--
Sybrand Bakker
Senior Oracle DBA
Received on Thu Aug 02 2007 - 03:25:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US