| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Opinions on B&R scenarios
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
"Fink, Dan"
<Dan.Fink_at_mdx To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
.com> cc:
Sent by: Subject: RE: Opinions on B&R scenarios
root_at_fatcity.
com
October 23,
2002 04:09 PM
Please
respond to
ORACLE-L
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."
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
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: Rajesh.Rao_at_jpmchase.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 - 16:44:45 CDT
 |
 |