RE: Disaster recovery using RMAN

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 17 Jan 2002 05:22:29 -0800
Message-ID: <F001.003F26D5.20020117050519@fatcity.com>

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.

Export the RMAN catalog and FTP a copy to the target system each time nightly backups are complete.
Back the Level 0 backup to tape, along with RMAN catalog export.
Mount the tape on the disaster recovery test system.
Assume that same version of Oracle is installed on the disaster recovery test system.
Create an RMAN user and import the RMAN catalog export.
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.
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

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). Received on Thu Jan 17 2002 - 07:22:29 CST