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).
