Rick,
I'm going to make the following assumptions about both scenarios, namely
that both instances are in 'archive log mode' and that your handling the
archived redo logs separately. That being said, both scenario's are viable for
recovery up to the point of failure assuming that in the second scenario you do
NOT copy the online redo logs and control files back onto the system. If you do
then the database will startup normally as all of the files are in line with
each other and no recovery is required. I copy the control files and online
redo files whenever I get a chance to do a cold backup so that I can restore to
a different server in the event of a WTC type of disaster.
Dick Goulet
____________________Reply Separator____________________
Author: [EMAIL PROTECTED]
Date: 10/23/2002 7:15 AM
Hi DBAs,
A co-worker and I disagree on impact of slightly different B&R 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 BACKUP
.....
If database crashes I perform media recovery then recover database.
Scenario 2:
Co-worker shuts down database and copy all files to backup directory.
Restarts database backup
If database crashes restore backup files then apply the
archive logs.
Co-worker says both scenarios are the same. I think scenario 1 results in
no loss where scenario 2 results in the loss
of data that was in the online redo logs.
Any thoughts on this?
Also what is the minimum system/object priviledges a user needs to perform
B&R. I would like to create a user with only those
privs necessary for B&R.
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
