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. [EMAIL PROTECTED]
-----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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
