The only logs you must back up in order to have a valid online backup are:
All the logs between and including the log that was active when you issued the first "alter tablespace ... begin backup" command or RMAN "backup database/tablespace/datafile" command and the log that was active when you completed the last "alter tablespace ... end backup" command or the last RMAN "backup database/tablespace/datafile" command completed. Beyond that, you would need all the logs since your last backup in order to roll forward to an arbitrary point in time. This is a question we can't answer completely for you, because it depends on your recovery needs. Maybe you need to be backing up logs every hour in order to have recoverability to a fairly recent point in time. We can't tell you what you need. Also, when you are citing one of my papers in a widely distributed email, it would be nice to have some attribution. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 29 May 2002, John Dunn wrote: > 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." -- 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).
