Hi DBAs,
A co-worker and I disagree on impact of slightly different BR scenarios
and I would like your thoughts.
Environment for both scenarios: Oracle 8.1.6, WinNt, Archivelog mode, not
using RMAN
Scenario 1:
I do standard Hot Backup using
BEGIN BACKUP
OCOPY ...
END
both scenarios potentially lose the online redo logs. actually, since
you don't include the backup of the archived redo logs in either
scenario, you can't do recovery without a resetlogs for both scenarios.
In order not to lose the contents of the online logs, you have to
archive them and back
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
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
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
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED]Subject: Opinions on BR scenarios
:
Sent by: Subject: RE: Opinions on BR scenarios
root@fatcity.
com
on BR
scenarios
root@fatcity.
com
October 23,
2002 02:11 PM
Please
respond to
ORACLE-L
It provides
]
.comcc:
Sent by: Subject: RE: Opinions on BR scenarios
root@fatcity
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
total sense.
next time I work without RMAN, I'll put in breaks in the backups.
--- Fink, Dan [EMAIL PROTECTED] wrote:
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
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 BR scenarios
Under
12 matches
Mail list logo