Skip to Main Content
Forums

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!

After renaming ASM Alias, Database wont come up

LANCERIQUEJul 18 2013 — edited Jul 18 2013

Hi Gurus,

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.

ASMCMD> pwd

+DATA1/oradata/CRAMPRD

and I want to change it to

ASMCMD> pwd

+DATA1/oradata/CRAMPBBS

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.

Regards,

Nikhil Mehta.

Comments

Mahir M. Quluzade

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

Mahir

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 15 2013
Added on Jul 18 2013
#11gr2, #asm, #database, #grid, #performance-availability, #rac-asm-clusterware-installation
1 comment
444 views