On Wed, 29 May 2002, Dave Morgan wrote: > You do not need to archive the log files. > > Alter system switch logfile does not return until > the logfile is written to disk.
This is demonstrably untrue, and incredibly easy to disprove. Try it yourself! SQL> select group#, sequence#, archived, status, first_time from v$log order by sequence#; GROUP# SEQUENCE# ARC STATUS FIRST_TIME ---------- ---------- --- ---------------- ---------------- 5 54283 YES INACTIVE 2002-05-29:16:13 4 54284 YES INACTIVE 2002-05-29:17:15 1 54285 NO CURRENT 2002-05-29:17:17 SQL> alter system switch logfile; System altered. SQL> select group#, sequence#, archived, status, first_time from v$log order by sequence#; GROUP# SEQUENCE# ARC STATUS FIRST_TIME ---------- ---------- --- ---------------- ---------------- 1 54284 YES INACTIVE 2002-05-29:17:15 2 54285 NO ACTIVE 2002-05-29:17:17 3 54286 NO CURRENT 2002-05-29:17:26 -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).