Question:
I am attempting to the add back the dropped
members by executing the following ALTER DISKGROUP statement:
alter diskgroup
data
add
failgroup
data_0001
disk
'\\.\orcldiskdata1'
name
data_0001
size 4096 m rebalance power 11
I get the following error
message:
Failed to commit: ORA-15032: not all alterations performed
ORA-15033: disk '\\.\ORCLDISKDATA1' belongs to diskgroup "DATA"
What causes the ORA-15033 error?
Answer: The Oracle docs provide this on the ORA-15033 error:
ORA-15033: disk xxx belongs to diskgroup yyy
Cause:
An attempt was made to ADD to a diskgroup a disk that was already
part of another diskgroup, or an attempt was made to DROP / OFFLINE
/ ONLINE / CHECK a disk that was not part of the specified
diskgroup.
Action: For ADD, check the path
specifier for the disk. If it is certain that the disk is not in use
by another diskgroup, the FORCE option may be used to override this
check. For the other commands, check the name of the specified disk.
In your case, the ORA-15033 error
can be fixed by using the FORCE option:
alter diskgroup
data
add
failgroup
data_0001
disk
'\\.\orcldiskdata1' FORCE
name
data_0001
size 4096 m rebalance power 11
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
