Re: RMAN disaster recovery

Dennis,

We have all of our RMAN catalogs on a small unix server that is fairly isolated and doesn't have much else on it. We also backup up the databases that contain those catalogs to other catalogs using RMAN to a second small,
isolated UNIX server.

In addition, we also take logical backups of all databases containing RMAN catalogs every night using exp utility.
The exports stay on the backup servers for a week.

If you're going to go to all of the work of setting RMAN up, you might as well go the extra step and locate your
RMAN catalog on a separate server. If you have a server go bad, it could well take down your RMAN catalog too.

My $.02

Cherie Machler
Oracle DBA
Gelco Information Network

                                                                                       
                        
                    DENNIS WILLIAMS                                                    
                        
                    <DWILLIAMS_at_LIFE       To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>  
                    TOUCH.COM>            cc:                                          
                        
                    Sent by:              Subject:     RMAN disaster recovery          
                        
                    root_at_fatcity.co                                                    
                        
                    m                                                                  
                        
                                                                                       
                        
                                                                                       
                        
                    11/30/01 08:25                                                     
                        
                    AM                                                                 
                        
                    Please respond                                                     
                        
                    to ORACLE-L                                                        
                        
                                                                                       
                        
                                                                                       
                        

I am wondering how RMAN would work for disaster recovery. Our manager's statement is "assume your server is reduced to a pile of ash. Now take your backup tape and build me a new system on a loaner from the vendor." I am trying to figure how that would work with RMAN. We are still at the stage of
just using RMAN to create disk copies, and we are on Compaq Tru64 UNIX. He wants us to demonstrate that level of recoverability, but I'm not sure how that would work. I think we could assume that we have a database to load the
RMAN catalog from an export.

           One issue would be whether the disk location of the RMAN files might
be different, and I'm not sure how to get RMAN to accept a different location. A more minor issue is if the database file locations are different, but I think that is pretty well documented.

           Has anyone else tried this? What am I overlooking? Any ideas will be
appreciated.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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: Cherie_Machler_at_gelco.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).