| Rename Logical Volume [message #172229] |
Mon, 15 May 2006 10:45  |
hpaccess
Messages: 17
Registered: October 2005
|
Junior Member |
|
|
My unix sys admin wants to rename the Logical Volume ex: vghcmlog to vghcmprdlog. These volume groups are used to create ASM diskgroups.
Please advise as an Oracle DBA, what should i do to reflect these changes.
|
|
|
|
| Re: Rename Logical Volume [message #172241 is a reply to message #172229] |
Mon, 15 May 2006 12:13  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Are you adding logical volumes instead of disks to you ASM disk groups? If so, try these steps:
1. Ask your sysadmin to create a new "vghcmprdlog" logical volume
2. Add the new "vghcmprdlog" volume to the ASM diskgroup
3. Drop "vghcmlog" from the ASM diskgroup
4. Wait until Oracle moved all data from "vghcmlog" to "vghcmprdlog"
5. Ask your sysadmin to remove "vghcmlog"
|
|
|
|
|
|
| Re: Rename Logical Volume [message #172318 is a reply to message #172288] |
Tue, 16 May 2006 00:29 |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
That is a very important question. The DROP statement completes right away, but the data is transferred in the background. To monitor what is happening:
SELECT state, header_status, SUBSTR(name,1,12), free_mb, SUBSTR(path,1,16)
FROM v$asm_disk;
When the HEADER_STATUS column changes from MEMBER to FORMER, you can remove those disks or use them for something else.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
