| 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
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: Ray Stell INET: stellr_at_cns.vt.edu 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: 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).Received on Wed Oct 23 2002 - 13:11:24 CDT
 |
 |