FreeLists / oracle-l / Re: RMAN RESTORE TO NEW SERVER

[Andy Rivenes <arivenes@xxxxxxxx>]

Hi Larry, if you're using SET NEWNAME then I don't think placing it 
in a run block by itself is going to take, even with the SWITCH 
DATAFILE ALL. This approach has always worked for me:
# . orasetup <SID>
# export NSR_CLIENT=<source host>
# svrmgrl
# SVRMGR> connect internal
# SVRMGR> startup nomount restrict;
# SVRMGR> exit
# rman target sys/<passwd> rcvcat rman_prd/<passwd>@<alias>
# rman> @rman_restore.<SID>
#
run {
allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type 'SBT_TAPE'
#
set newname for datafile '/u03/oradata/TRGT8/system01.dbf' to 
'/u05/oradata/COPY8/system01.dbf';
set newname for datafile '/u04/oradata/TRGT8/psidx01.dbf' to 
'/u06/oradata/COPY8/psidx01.dbf';
...
set newname for datafile '/u02/oradata/TRGT8/sysrbc01.dbf' to 
'/u08/oradata/COPY8/sysrbc01.dbf';
#
restore ( database );
#
release channel t1;
release channel t2;
}

As you can tell the example is old, which is in my notes for 
restoring to another machine. Note the svrmgrl command. However, I 
believe the RMAN syntax is still valid. I think that if you want to 
switch the datafiles, which in your case seems appropriate, that you 
would place that command right after the restore. At least that's 
what I got out of the RMAN reference manual. Good luck.
Andy Rivenes


At 11:20 AM 2/8/2008, Wolfson Larry - lwolfs wrote:

>   I've tried the SET NEWNAME command and when I run it it says it 
> worked but the files always want to go to original place.
>
>  RUN
>     {
> SET NEWNAME FOR DATAFILE '/x/system01.dbf'  TO '/y/system01.dbf' ;
>     SWITCH DATAFILE ALL;
>     }