Re: online backup and alter system switch logfile

On Tue, 28 May 2002, DBarbour_at_austin.isd.tenet.edu wrote:

> Add a 'sleep' command to your UNIX-side shell script before you copy
> the logs to ensure the log has finished writing. You need to have
> that last archivelog - it contains the data regarding datafile
> header record changes you'll need to apply in the event you have to
> restore to sync up your controlfile.

Sleep doesn't seem like a very reliable approach here. As has already been mentioned, Oracle provides a command that does not return until the current log is archived.

alter system archive log current;

In fact, this is one of the Oracle misconceptions I wrote about:

http://www.speakeasy.org/~jwilton/oracle/switch-logfile-backups.html

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton



> John Dunn <john.dunn_at_sefas.co.uk>

> 

> I have a online backup script which issues the command

> 

> ALTER SYSTEM SWITCH LOGFILE;

> 

> immediately before copying the archived redo logs.

> 

> Does this make sense? I am finding that the ARC process has not finished

> archiving the log before I copy the archive logs




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  INET: jwilton_at_speakeasy.net

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: 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).