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