Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Restore backup onto new host ASM datafile rename issue

797752Sep 27 2011 — edited Dec 12 2011
Helllo,

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 9 2012
Added on Sep 27 2011
10 comments
6,382 views