Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: switch logfile vs. archive log current

RE: switch logfile vs. archive log current

From: Hemant K Chitale <>
Date: Thu, 20 Mar 2003 22:01:13 +0800
Message-Id: <>

No, it is not necessary to switch or archive the log file at every tablespace. I, too, run the switch and archive commands _after_ the last tablespace.

At 10:26 AM 19-03-03 -0800, you wrote:

>I use switch logfile exclusively within my hot backups (because at the time
>I wrote the scripts I was unaware of the difference) but also check V$LOG to
>make sure the archive write is complete before proceeding with the backup.
>I has worked fine on my 8.x production database for the last 4+ years
>(including daily recoveries to build a Reporting instance).
>I do have a question though. What is the purpose of switching the logfile
>for each tablespace? I do it once, after all of the tablespaces have been
>backed up. Am I missing something?
>Mike Hand
>Polaroid Corp.
>-----Original Message-----
>Sent: Wednesday, March 19, 2003 11:49 AM
>To: Multiple recipients of list ORACLE-L
>A "switch logfile" isn't mandatory and an "archive log current" is highly
>The "switch logfile" command would return immdiately and would not
>wait for the archiver to complete archiving the log. The "archive log
>would return only after the archiver has completed it's job.
>You must backup the archivelogs from the first one generated
>after the first "alter tablespace begin backup" to the first one
>after the last "alter tablespace end backup". You are also
>backing up the controlfile which is also highly recommended.
>I normally use a combination of multiple "switch logfile", "archive log"
>commands and
>a Unix "sleep" command and then exclude the last archivelog from the backup
>just to be safe.
>Please see the official ORACLE-L FAQ:
>Author: Hand, Michael T
>Fat City Network Services -- 858-538-5051
>San Diego, California -- Mailing list and web hosting services
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: (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).

Hemant K Chitale
My personal web site is : Received on Thu Mar 20 2003 - 08:01:13 CST

Original text of this message