Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Restore on another machine with RMAN

RE: Restore on another machine with RMAN

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Sun, 07 Jul 2002 06:53:21 -0800
Message-ID: <F001.00490AB8.20020707065321@fatcity.com>


Luc - You don't mention which platform you are on (NT or Unix), and since you are discussing file locations, that is a relevant issue.

   If you are on Unix, I would recommend that you create a mount point that matches the backup location on your production machine. That will eliminate an issue for RMAN. I vaguely recall an RMAN command to change the backup location, so you might look for that. If you take the suggestion someone else provided and use a catalog, then you could try changing the backup location in the RMAN catalog database tables.

    Good luck and please report any success you achieve. I'm still trying to perform a disaster recovery test with our RMAN backups. We can't cease operating system backups until I complete that test. As you have discovered, there appear to be a number of obstacles.

     Robert - are you listening? Another chapter idea for your book.

Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, July 04, 2002 12:38 PM
To: Multiple recipients of list ORACLE-L

Hi gurus,

I'm in process of testing our backup strategies. We are using RMAN, but for our prod database we aren't using the recovery catalog.

Our backup's files are on disk, so I transfered them on another machine. I recovered the controlfile, I mounted the database, but when RMAN tried to restore it looks for the original location where RMAN created the backup.

How can indicate the new location of the backup's files ?

TIA
Luc



Luc Demanche
luckyref_at_yahoo.com

Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com
--

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

Author: Luc Demanche
  INET: luckyref_at_yahoo.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: 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 Sun Jul 07 2002 - 09:53:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US