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

From: Big George <jbeteta_at_gmail.com>
Date: Thu, 26 Apr 2012 07:38:12 -0700 (PDT)
Message-ID: <7bcca8c3-f512-47ab-b544-b8dafcbfa3db_at_e15g2000vbt.googlegroups.com>

Hello,

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

My RMAN backuppieces are stored in a network drive:
\\old_location\FULL

and
\\old_location\INC

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
   \10.2.0\db_1\database\
   

I started creating an instance in new server from scratch:

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

RMAN> SET DBID=21692876873
RMAN> STARTUP force nomount PFILE=C:\oracle\product
\10.2.0\db_1\database\init_mtdprod.ora

RMAN> restore controlfile from 'C:\oracle\product\10.2.0\db_1\database
\CTL_MTDPROD_2308_20120401_1.CTL';

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
\SYSAUX01.DBF

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

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

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

channel ORA_DISK_1: reading from backup piece \\old_location\FULL
\FULL_MTDPROD_20120401_2304_1.BAK

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

Questions:

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