Opinions on B&R scenarios

From: <Rick_Cale_at_teamhealth.com>
Date: Wed, 23 Oct 2002 07:15:27 -0800
Message-ID: <F001.004F0F6A.20021023071527@fatcity.com>

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: Rick_Cale_at_teamhealth.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 - 10:15:27 CDT