I kept a flat file list of the archived logs I had backed up in the last backup, then did a diff of that with the logs currently on disk, backed up every log in the new list minus the very latest one (but I was willing to lose a little data, in the case that that log had already been archived)
or you could use RMAN and let it decide --- John Dunn <[EMAIL PROTECTED]> wrote: > it looks like alter system archive log current; is the way to go. > > Can anyone please clarify waht archived logs should be backed up when > doing > a online backup? > > I have seen various online backup scripts that seem to take different > approaches. > > I have also seem the comment > > "a backup script should never just back up "all the archived > redologs." If a > script does not restrict itself only to those logs that it knows to > be > archived, it may improperly try to back up an archived redolog that > is not > yet completely archived. To determine which logs are archived, a > backup > script should query the v$archived_log view to obtain a file list for > copying." > > What apporoach do you guys take? > > > > > > -----Original Message----- > > From: Jeremiah Wilton [SMTP:[EMAIL PROTECTED]] > > Sent: 28 May 2002 16:18 > > To: Multiple recipients of list ORACLE-L > > Subject: Re: online backup and alter system switch logfile > > > > 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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: John Dunn > 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). __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).