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!

ORA-15032 and ORA-15177 alter diskgroup rename directory

Dude!Dec 22 2010 — edited Dec 23 2010
Hi,

Oracle 11.2.0.1, Oracle Linux 5.5

I would like to do some RMAN testing and for this reason rename an existing directory in an ASM diskgroup, temporarily.

The database 'orcl' instance is shutdown. I have tried the following using the ASM/Grid environment:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Automatic Storage Management option

SQL> alter diskgroup DATA rename directory '+DATA/ORCL' TO '+DATA/OLDORCL';
alter diskgroup DATA rename directory '+DATA/ORCL' TO '+DATA/OLDORCL'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15177: cannot operate on system aliases


ASMCMD> ls -l
Type  Redund  Striped  Time             Sys  Name
                                        Y    ASM/
                                        Y    ORCL/
                                        Y    RCAT/

ASMCMD> ls -l ORCL
Type           Redund  Striped  Time             Sys  Name
                                                 Y    CONTROLFILE/
                                                 Y    DATAFILE/
                                                 Y    ONLINELOG/
                                                 Y    PARAMETERFILE/
                                                 Y    TEMPFILE/
                                                 N    spfileorcl.ora => +DATA/ORCL/PARAMETERFILE/spfile.270.737565081
I also removed the alias inside the ORCL directory, but it does not help. How can I rename the directory?

Thanks.
This post has been answered by Levi Pereira on Dec 22 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 20 2011
Added on Dec 22 2010
2 comments
4,247 views