We are having an 2node RAC - 11gR2 with ASM. I have cloned an PROD environment with RMAN into TEST. After cloning, I found that few of the ASM alias are using old directory naming shown as below.
and I want to change it to
By refering Oracle support Note How to rename/move a datafile in the same ASM diskgroup [ID 564993.1], I am able to successfully rename alias firing below commands(few listed below).
alter diskgroup DATA1 rename alias '+DATA1/oradata/CRAMPRD/cntrl_1.dbf' to '+DATA1/oradata/CRAMPBBS/cntrl_1.dbf';
alter diskgroup DATA1 rename alias '+DATA1/oradata/CRAMPRD/cntrl_2.dbf' to '+DATA1/oradata/CRAMPBBS/cntrl_2.dbf';
Once I change it, DB instance wont come up saying that it is not able to find the required files at the correct directory.
Now how to make Oracle DB instance aware that I have renamed ASM alias to a new location.
You must check control files, is correct place or not,
show parameter control_files
after mount, you can check data file, redo log , temp files directories.
they must be in correct directory