Oracle-L: RE: RMAN: How to restore backup to a different box

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 12 Aug 2002 08:23:33 -0800
Message-ID: <F001.004B205A.20020812082333@fatcity.com>

Helmut - I am struggling with this myself. What is your goal? Are you just trying to create a test database, or trying to perform a disaster recovery test? For creating a test database, take a look at the RMAN DUPLICATE command.

As to your specific question of changing the file path, the RMAN SWITCH command should be able to do what you need. Another idea is to have your Unix system administrator create the file paths you need so that you don't have to perform any changes in RMAN. For example, if you need a path /u01, create a file path or mount point with that name on the test system. One less thing to wrestle with in RMAN. I do not find that RMAN takes kindly to changes.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Monday, August 12, 2002 10:48 AM
To: Multiple recipients of list ORACLE-L

Hi!

I need to restore a RMAN backup (full db backup) of our production database to a test machine, which has a different file system layout.

Production box: /u01, /u02, /u03, /u04, /u05

On the test box, all the data files need to be restored under /export (i.e. /export/u01, /export/u02 etc.)

How do I achieve this using RMAN?

This is 8.1.7 on Solaris.

Thanks,
Helmut

--

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 Mon Aug 12 2002 - 11:23:33 CDT