Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: switch logfile vs. archive log current
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.
Hemant
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
>recommended.
>The "switch logfile" command would return immdiately and would not
>wait for the archiver to complete archiving the log. The "archive log
>current"
>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.
>Hemant
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Hand, Michael T
> INET: HANDM_at_polaroid.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (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 : http://hkchital.tripod.com
Received on Thu Mar 20 2003 - 08:01:13 CST
![]() |
![]() |