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_at_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: Dan.Fink_at_mdx.com
>
> 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: 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).
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mandar A. Ghosalkar
INET: mghosalk_at_byer.com
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: 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 Wed Oct 23 2002 - 21:28:49 CDT
