No, I mean an incomplete recovery. In this case it is a time-based incomplete recovery.
-----Original Message----- Sent: Wednesday, October 23, 2002 12:39 PM To: Multiple recipients of list ORACLE-L Dont you mean complete recovery? "You could then perform an incomplete recovery until 02:10:01 - 02:10:59 or 02:21:01 - 02:21:59, etc." "Fink, Dan" <Dan.Fink@mdx To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> .com> cc: Sent by: Subject: RE: Opinions on B&R scenarios root@fatcity. com October 23, 2002 02:11 PM Please respond to ORACLE-L It provides a window for an incomplete recovery during the time that the backup is being performed. For example 02:00 1st tablespace begins backup 04:00 last tablespace ends backup with no time gaps in between It is not possible to perform an incomplete recovery from 02:00 to 04:00. 02:00 1st tablespace begins backup 02:10 1st tablespace ends backup 02:11 2nd tablespace begins backup 02:21 2nd tablespace ends backup 02:22 3rd tablespace begins backup 02:32 3rd tablespace ends backup etc. You could then perform an incomplete recovery until 02:10:01 - 02:10:59 or 02:21:01 - 02:21:59, etc. Granted, it is not a common need to perform an incomplete recovery during the time of a hot backup, but better safe than sorry. Dan Fink -----Original Message----- Sent: Wednesday, October 23, 2002 11:20 AM To: Multiple recipients of list ORACLE-L On Wed, Oct 23, 2002 at 08:14:07AM -0800, Fink, Dan wrote: > Rick, > I will assume that all logs are properly backed up. > The only difference in the recoverability of the 2 scenarios is that > an incomplete recovery cannot be done to a time while any tablespace in the > database is in hot backup mode. So, there is a window of exposure in > Scenario 1, that does not exist in 2. For this reason, it is recommended > that each tablespace be placed in backup mode, the files copied, the > tablespace taken out of backup mode and the process sleeps for 1 minute. 1 minute? What's that about? > Repeat with the next tablespace, etc. =============================================================== -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).