On Tue, 28 May 2002, [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> > > 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: [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).
