Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Opinions on B&R scenarios

Re: Opinions on B&R scenarios

From: <Rajesh.Rao_at_jpmchase.com>
Date: Wed, 23 Oct 2002 10:01:08 -0800
Message-ID: <F001.004F1633.20021023100108@fatcity.com>

If the database crash causes media failure of your archive destination or your online log destination, then you can only recover the database upto the last archivelog availability, and you would need to open the database with resetlogs. This is true for both scenarios.

Assuming no media failures, in the scenario 2, you can always recover upto the point of the last archive log, and then apply the online redo log file to perform a complete recovery. So you colleague is right. Both of them are practically the same, except in scenario 2, your database needs to be down for the backup.

Regards
Raj

                                                                                                                     
                    Rick_Cale_at_team                                                                                   
                    health.com            To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>        
                    Sent by:              cc:                                                                        
                    root_at_fatcity.c        Subject:     Opinions on B&R scenarios                                     
                    om                                                                                               
                                                                                                                     
                                                                                                                     
                    October 23,                                                                                      
                    2002 11:15 AM                                                                                    
                    Please respond                                                                                   
                    to ORACLE-L                                                                                      
                                                                                                                     
                                                                                                                     




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: Rajesh.Rao_at_jpmchase.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 - 13:01:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US