Re: online backup and archived redo logs files (Was online backup

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