Can anyone please clarify what 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? John > -----Original Message----- > From: Ganesh Raja [SMTP:[EMAIL PROTECTED]] > Sent: 29 May 2002 10:48 > To: Multiple recipients of list ORACLE-L > Subject: RE: online backup and alter system switch logfile > > Yes Alter System Achive Log Current is the way to go. > > Now regarding what are the archive logs hat I will backup. My Script at > the > End of Each Backup routine will Backup all the archive Logs and then > delete > the same from the Log Dest in this way I only backup all the Logs that > have > been generated since the last backup and also by doing this I free a lot > of > space in my Archive Location. > > HTH > > Best Regards, > Ganesh R > Tel : +971 (4) 397 3337 Ext 420 > Fax : +971 (4) 397 6262 > HP : +971 (50) 745 6019 > ============================================ > Live to learn... forget... and learn again. > ============================================ > > > > -----Original Message----- > Sent: Wednesday, May 29, 2002 1:03 PM > To: Multiple recipients of list ORACLE-L > > > 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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ganesh Raja > 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).
