RE: Disaster recovery using RMAN

Dennis,

I hope you can clarify something in your plan for me.

Why are you backing up to disk? By doing so, you are losing one of the chief benefits of RMAN. RMAN keeps a catalog of the tapes and knows which tapes to request to restore a backup, and which files to retrieve from those tapes.

Do you backup the disk files to tape without the benefit of any tape management software? Do you manually label the tapes?

Thanks,

Jared

                                                                                       
                              
                    DENNIS WILLIAMS                                                    
                              
                    <DWILLIAMS_at_LIFE       To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>        
                    TOUCH.COM>            cc:                                          
                              
                    Sent by:              Subject:     RE: Disaster recovery using  
RMAN                             
                    root_at_fatcity.co                                                    
                              
                    m                                                                  
                              
                                                                                       
                              
                                                                                       
                              
                    01/17/02 05:05                                                     
                              
                    AM                                                                 
                              
                    Please respond                                                     
                              
                    to ORACLE-L                                                        
                              
                                                                                       
                              
                                                                                       
                              

Sona - I am planning to test a disaster recovery using RMAN also. My company
won't completely trust it until I can. Like you, I currently use RMAN to back up to disk, and write the backup to tape, keeping a Level 0 backup on disk. Here are the steps I am planning for disaster recovery.

1. Export the RMAN catalog and FTP a copy to the target system each time nightly backups are complete.
2. Back the Level 0 backup to tape, along with RMAN catalog export.
3. Mount the tape on the disaster recovery test system.
4. Assume that same version of Oracle is installed on the disaster recovery test system.
5. Create an RMAN user and import the RMAN catalog export.
6. Copy the RMAN Level 0 backup to disk. If possible, put it on the same path as on the original machine. If not, create a link so it looks like the same location to the system.
7. Begin RMAN recovery, changing disk locations for the data files, as needed.

I'm just listing these off the top of my head, so I may have left something out. If you or any other listers see anything amiss with my plans, please point that out.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, January 16, 2002 5:21 PM To: Multiple recipients of list ORACLE-L

Hi

Here in my company we are planning to put together a disaster recovery plan using RMAN would like to test various recovery scenarios using RMAN.

Could anyone provide the information on the procedures followed in a testing
like this?

TIA

--
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: Jared.Still_at_radisys.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).