Trying to restore a database with RMAN in new server and new location of backppieces

From: Big George <>
Date: Thu, 26 Apr 2012 07:38:12 -0700 (PDT)
Message-ID: <>


Database: Oracle 10gR2
O/S: Windows Server 2003

My RMAN backuppieces are stored in a network drive:


I'm trying to restore a whole database with RMAN in another server from my FULL backup.

For that, I copy all backuppieces files
from: \\old_location\FULL
to new server: D:\new_location\

Also I created the relevant folder hierarchy under <ORACLE_BASE> directory, as follows:

  1. Create BDUMP, CDUMP, and UDUMP directories under '<ORACLE_ BASE>
    \admin' directory
  2. Create <DATABASE_NAME> directory under '<ORACLE_BASE>\oradata' directory
  3. pfile.ora and controlfile (CTL_MTDPROD_2308_20120401_1.CTL) are backup from original database and they are in D:\new_location\
  4. I copied pfile.ora and controlfile to folder: C:\oracle\product

I started creating an instance in new server from scratch:

C:\>oradim -new -sid MTDPROD -intpwd mtdprod
C:\> rman
RMAN> connect target sys

RMAN> SET DBID=21692876873
RMAN> STARTUP force nomount PFILE=C:\oracle\product

RMAN> restore controlfile from 'C:\oracle\product\10.2.0\db_1\database

RMAN> alter database mount;

#Since I want to read my backuppieces from D:\new_location and not from \\old_location\FULL then I catalog and restore like:

RMAN> catalog start with 'D:\new_location\'; RMAN> restore database;

Starting recover at 25/04/12
allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=541 devtype=DISK
channel ORA_DISK_1: starting incremental datafile backupset restore
channel ORA_DISK_1: specifying datafile copies to recover
recovering datafile copy fno=00003 name=D:\BD_MTDPROD\CONTROLFILES

recovering datafile copy fno=00004 name=D:\BD_MTDPROD\CONTROLFILES

recovering datafile copy fno=00007 name=D:\BD_MTDPROD\DATAFILES_DATA

recovering datafile copy fno=00010 name=D:\BD_MTDPROD\DATAFILES_DATA

channel ORA_DISK_1: reading from backup piece \\old_location\FULL

channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: failover to piece handle=D:\new_location\FULL
\FULL_MTDPROD_20120401_2304_1.BAK tag=TAG20120401T190004


  1. RMAN still reads from old_location. The only way to avoid that would be deleting all files from \\old_location\FULL ?
  2. The message "failover to piece handle=D:\new_location\...." indicates that that file is not usefull? I just copy them from old_location to new_location... how can they get useless?

I suspect there is something in controlfile that redirects to \
\old_location\FULL\ and doesn't let to read from D:\new_location\

Please, advice. Received on Thu Apr 26 2012 - 09:38:12 CDT

Original text of this message