From oracle-l-bounce@freelists.org Thu Jul 14 10:27:49 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j6EFRkFE002168 for ; Thu, 14 Jul 2005 10:27:46 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j6EFReIP002147 for ; Thu, 14 Jul 2005 10:27:40 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AB9E41D1B0B; Thu, 14 Jul 2005 10:27:34 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 31176-03; Thu, 14 Jul 2005 10:27:34 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 25F791D18E0; Thu, 14 Jul 2005 10:27:34 -0500 (EST) From: "Ruth Gramolini" To: , Subject: RE: Moving RMAN Disk Backup Files Date: Thu, 14 Jul 2005 11:25:38 -0400 Message-ID: <012101c58888$49c82370$8459000a@vttaxnet.tax.state.vt.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0122_01C58866.C2B68370" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 In-Reply-To: <0F3AA39C49335840BB3EDD3BD974D6AEC39D38@dna2k3-cex.denvernewspaperagency.com> X-archive-position: 22465 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rgramolini@tax.state.vt.us Precedence: normal Reply-To: rgramolini@tax.state.vt.us X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-2.9 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_NextPart_000_0122_01C58866.C2B68370 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Stahlke, Mark Sent: Thursday, July 14, 2005 9:11 AM To: oracle-l@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 ------=_NextPart_000_0122_01C58866.C2B68370 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Moving RMAN Disk Backup Files
AFAIK, = you cannot=20 use rman to move or duplicate a database to a different OS.  You = have to=20 use exp/imp for this.
 
 
Regards,
Ruth
-----Original Message-----
From: = oracle-l-bounce@freelists.org=20 [mailto:oracle-l-bounce@freelists.org]On Behalf Of Stahlke,=20 Mark
Sent: Thursday, July 14, 2005 9:11 AM
To:=20 oracle-l@freelists.org
Subject: Moving RMAN Disk Backup=20 Files

Greetings,

This question pertains to Oracle 9.2.0.4 = on=20 Winblows.

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

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

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


Cheers,
Mark=20 Stahlke
Oracle D'ohBA =
Denver Newspaper Agency

------=_NextPart_000_0122_01C58866.C2B68370-- -- http://www.freelists.org/webpage/oracle-l