RE: Moving RMAN Disk Backup Files

Moving RMAN Disk Backup FilesAFAIK, you cannot use rman to move or duplicate a database to a different OS. You have to use exp/imp for this.

Regards,
Ruth
-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Stahlke, Mark
Sent: Thursday, July 14, 2005 9:11 AM
To: oracle-l_at_freelists.org
Subject: Moving RMAN Disk Backup Files

Greetings,

This question pertains to Oracle 9.2.0.4 on Winblows.

Is there a way to convince RMAN to use backup files from a location other than where they were created?

I was duplicating a database from an old RMAN backup on a Windows system that has an entirely different disk configuration than the server it normally runs on. The RMAN backups are written to d:\oracle\backups. When I tried to restore the database on the new box, RMAN insisted on looking for the backup files in d:\oracle\backups. Unfortunately, the d: drive on the new machine is a CDROM. Try as I might, I couldn't find a way to make RMAN look somewhere else for the backup files. Eventually I got around the problem by disabling the CDROM and mapping a network drive as d: to the c: drive. This worked but it seems like a Mickey Mouse solution.

Did I miss something easy? Is there a way to tell RMAN where to find the backup files?

Cheers,
Mark Stahlke
Oracle D'ohBA
Denver Newspaper Agency

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jul 14 2005 - 10:27:49 CDT