Oracle-L: Re:Opinions on B&R scenarios

From: <dgoulet_at_vicr.com>
Date: Wed, 23 Oct 2002 08:23:26 -0800
Message-ID: <F001.004F11D0.20021023082326@fatcity.com>

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: Rick_Cale_at_teamhealth.com
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: 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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: dgoulet_at_vicr.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------