Re:will log be generated during hot backup ?

From: <dgoulet_at_vicr.com>
Date: Tue, 23 Jan 2001 09:53:15 -0500
Message-Id: <10750.127273@fatcity.com>

Rahul,

This gets more into your backup and recovery planning, namely how long do you keep backup files for? During a hot backup, whether a tablespace or the entire DB, the redo information is constantly being written to the archive logs. If your only doing one tablespace, any of the logs created between the "alter tablespace <name> start backup" and "alter tablespace <name> end backup" may be needed during a recovery. Which ones will depend on which files you need to restore, when the backup started, and when your rolling forward to. The discussion can get rather DEEP fast & I really don't want to tie up too much of the lists bandwidth. Therefore, I keep ALL archive log files for 30 days or until the last database backup tape with a date earlier than the date of the archive log tape has been recycled/trashed, whichever is LONGER. If you have more questions, can we take then off-line?

Dick Goulet

____________________Reply Separator____________________

Subject: will log be generated during hot backup ? Author: Rahul <rahul_at_ratelindo.co.id>
Date: 1/23/2001 2:00 AM

List,
will log generation (and archiving) continues during the backup of a tablespace ?
if yes, then how will identify which logs to delete/keep after finish my hot backup ?

regards
rahul sharma

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Rahul
INET: rahul_at_ratelindo.co.id

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). Received on Tue Jan 23 2001 - 08:53:15 CST