RMAN: restoring backup files from one machine to another

From: larry9700 <lcjohnso_at_pcs.cnu.edu>
Date: 10 Mar 2005 16:10:24 -0800
Message-ID: <1110499824.722973.314780@f14g2000cwb.googlegroups.com>

Hi all,

Currently I'm trying to restore a backup file created by an oracle instance on my production server to another machine. I've moved the backup files (Control Files and DB Backup) to the other machine and it seems that the only problem that I'm experiencing in trying to restore the DB is when when the system attempts to access the backup file.

Here's a summary of what I've done so far:

DB Files from prod server were located at:

E:\oracle...

DB Files on new machine are located at:

C:\oracle...

I restore my control files from the production server using:

set DBID=##########;
set controlfile autobackup format for device type disk to 'c:\contf_db_%F';
startup nomount;
restore controlfile from autobackup;

which executes fine, but when I try to restore the DB using:

run
{
  set new name for datafile 'e:\...dbf' to 'c:\...dbf';   ...for all datafiles
  restore database;
  recover database noredo;
  alter database open resetlogs;
  switch datafile all;
}

I get this error:

executing command: SET NEWNAME

...

Starting restore at 10-MAR-05

using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set

restoring datafile 00001 to C:\ORACLE\ORADATA\DB\SYSTEM01.DBF
restoring datafile 00002 to C:\ORACLE\ORADATA\DB\UNDOTBS01.DBF
restoring datafile 00003 to C:\ORACLE\ORADATA\DB\CWMLITE01.DBF
restoring datafile 00004 to C:\ORACLE\ORADATA\DB\DRSYS01.DBF
restoring datafile 00005 to C:\ORACLE\ORADATA\DB\EXAMPLE01.DBF
restoring datafile 00006 to C:\ORACLE\ORADATA\DB\INDX01.DBF
restoring datafile 00007 to C:\ORACLE\ORADATA\DB\TOOLS01.DBF
restoring datafile 00008 to C:\ORACLE\ORADATA\DB\USERS01.DBF
restoring datafile 00009 to C:\ORACLE\ORADATA\DB\SYSTABLESPACE.DBF
restoring datafile 00010 to E:\ORACLE\ORADATA\DB\USERTBLSPC.DBF
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00579: the following error occurred at 03/10/2005 18:29:37
RMAN-03002: failure during compilation of command

RMAN-03013: command type: restore
RMAN-03007: retryable error occurred during execution of command: IRESTORE
RMAN-12004: unhandled exception during command execution on channel ORA_DISK_1
RMAN-10035: exception raised in RPC: ORA-19505: failed to identify file "E:\BACKUP\BU_DB_37GEFPQ7_1_1"

ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE I'm pretty sure this is because I haven't specified the location of the backup file on the new machine. Does anyone know how to do this?

Thanks in advance,

Larry Received on Thu Mar 10 2005 - 18:10:24 CST