How would i specify this sleep command in a 7.3/ebu/nbu configuration? checking ebu docs..
> -----Original Message----- > From: Fink, Dan [mailto:Dan.Fink@;mdx.com] > Sent: Wednesday, October 23, 2002 3:09 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Opinions on B&R scenarios > > > 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). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar 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).