total sense. next time I work without RMAN, I'll put in "breaks" in the backups.
--- "Fink, Dan" <[EMAIL PROTECTED]> wrote: > Under this scenario, you have 2 options > 1) Incomplete recovery to 2:10:30. Since there are no tablespaces in > backup > mode, this is possible. > 2) Do a complete recovery to the point of failure at 2:15:30. Of > course, if > the failure was manual (oops, I dropped a table in production), then > this is > not a valid recovery because it would return you to the state > immediately > following the failure. > > Also consider this scenario: > Well after the backup has completed, it is determined that data has > been > logically corrupted and the database needs to be recovered to the > point in > time immediately prior to the corruption. If the corruption occurred > at > 02:15:30, the only option is to perform an incomplete recovery to > 02:10:59. > > I looked in my notes from the Oracle8 Internals Seminar and this is > the > explanation. Incomplete recovery is not allowed during a hot backup > (while > ts was in hot backup mode). Because the high scn is not recorded (in > the > datafile), the recovery logic does not know how to perform a > recovery. The > first time when incomplete recovery is possible is at the checkpoint > immediately following the end of hot backup mode (which may be > delayed in > some releases). > > Does this make sense? > > -----Original Message----- > Sent: Wednesday, October 23, 2002 3:45 PM > To: Multiple recipients of list ORACLE-L > > > > Dan, > > What you intend to say is that if the database crashed at say > 2:15:30, you > can do an incomplete recovery upto say 2:10:30, right? Why cant I do > a > complete recovery ? or what stops me from doing an incomplete > recovery > until 2:15:25? > > Raj > > > > <<snip>> > > > 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. > > <<snip>> > -- > 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). __________________________________________________ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).