Avatar of LindaC
LindaCFlag for Puerto Rico

asked on 

I have a ASM dism "mounted" I want to change the name and use it for datafiles and Archives

I have a ASM diks "mounted" I want to change the name and use it for datafiles and Archives.
The new name would be DATA2:
ORacle Rac - Version 10.2.0.3

SQL> select name, state, type, total_mb, free_mb from v$asm_diskgroup;

NAME                           STATE       TYPE     TOTAL_MB    FREE_MB
------------------------------ ----------- ------ ---------- ----------
DATA                           CONNECTED   EXTERN     245760       3636
FRA                            MOUNTED     EXTERN      61440      61336
Oracle Database

Avatar of undefined
Last Comment
LindaC
Avatar of johnsone
johnsone
Flag of United States of America image

I have never done it, but according to the doc, there seems to be a utility rename.

http://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#sthref421

Seems pretty straightforward.
Avatar of LindaC
LindaC
Flag of Puerto Rico image

ASKER

Is this for oracle 10.2.0.3 also?
Avatar of johnsone
johnsone
Flag of United States of America image

Sorry, I missed the version in your original post.

I don't see a way in the documentation for 10.2 to rename a disk group.  Seems the only way would be to drop and re-add.

http://docs.oracle.com/cd/B19306_01/server.102/b14231/storeman.htm#sthref1747
ASKER CERTIFIED SOLUTION
Avatar of LindaC
LindaC
Flag of Puerto Rico image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of LindaC
LindaC
Flag of Puerto Rico image

ASKER

No oracle services needed to be shutdown for this.
ORacle Rac version 10.2.0.3
Avatar of LindaC
LindaC
Flag of Puerto Rico image

ASKER

I found the correct answer.
Oracle Database
Oracle Database

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

81K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo