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

From: <John.Hallas_at_vodafone.co.uk>
Date: Mon, 12 Aug 2002 08:48:25 -0800
Message-ID: <F001.004B20DF.20020812084825@fatcity.com>

Helmut,
Check out the newname command that can be used when duplicating a database

    set newname for datafile 1 TO '$ORACLE_HOME/dbs/newdb_data_01.f'; 
    set newname for datafile 2 TO '$ORACLE_HOME/dbs/newdb_data_02.f'; 
    set newname for datafile 3 TO '$ORACLE_HOME/dbs/newdb_data_11.f'; 
    set newname for datafile 4 TO '$ORACLE_HOME/dbs/newdb_data_12.f'; 
    set newname for datafile 5 TO '$ORACLE_HOME/dbs/newdb_data_21.f'; 
    set newname for datafile 6 TO '$ORACLE_HOME/dbs/newdb_data_22.f';

HTH John

-----Original Message-----
Sent: 12 August 2002 17:24
To: Multiple recipients of list ORACLE-L

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: John.Hallas_at_vodafone.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------