Restore backup onto new host ASM datafile rename issue
797752Sep 27 2011 — edited Dec 12 2011Helllo,
Database: Oracle 11gR2 with ASM
RMAN: no catalog
I've researched the procedure on doing a restore onto a new host but have encountered some difficulty getting the datafiles into their correct locations upon restore.
Here is my script:
RUN
{
# allocate a channel to the tape device
allocate channel c1 device type disk format '/orabackup/Rman_FIN89DMO_20110918_fsmmsddt_1_1.full';
allocate channel c2 device type disk format '/orabackup/Rman_FIN89DMO_20110918_ftmmsddu_1_1.full';
SET NEWNAME FOR DATAFILE 1 TO '+DATA/sd89dmo/datafile/system.dbf';
SET NEWNAME FOR DATAFILE 2 TO '+DATA/sd89dmo/datafile/sysaux.dbf';
SET NEWNAME FOR DATAFILE 3 TO '+DATA/sd89dmo/datafile/psundots.dbf';
SET NEWNAME FOR DATAFILE 4 TO '+DATA/sd89dmo/datafile/psdefault.dbf';
SET NEWNAME FOR DATAFILE 5 TO '+DATA/sd89dmo/datafile/amapp.dbf';
etc...
SET NEWNAME FOR TEMPFILE 1 TO '+DATA/sd89dmo/tempfile/temp.dbf';
SET NEWNAME FOR TEMPFILE 2 TO '+DATA/sd89dmo/tempfile/pstemp.dbf';
SWITCH TEMPFILE ALL;
RESTORE DATABASE;
SWITCH DATAFILE ALL;
RECOVER DATABASE;
}
The datafile OMF ALIAS are being created in the new ASM DIR "+DATA/sd89dmo/datafile" and they point to the old ASM dir not the new ASM dir. The actual datafiles are still going into the old ASM dir "+DATA/fin89dmo/datafile"
My guess is due to the restored controlfile or ASM.
My question is what command or parameter am I missing in my script to tell RMAN to put both the datafiles and their OMF alias into the NEW ASM directories.
I am not interested in doing a duplicate database connection to my production environment for the restore.
Let me know if any additional info is needed.
Thanks.