Database Administration (MOSC)

MOSC Banner

asm drop disk

edited Nov 14, 2016 8:35AM in Database Administration (MOSC) 1 commentAnswered ✓

Hello,

Does one kown the role that must a user have to be able to administer asmdisks?

I am facing the issue not beeing able to drop a disk from diskgroup:

sqlplus / as sysdba;

select GROUP_NUMBER,NAME from V$ASM_DISKGROUP;

GROUP_NUMBER NAME

------------ ------------------------------

           1 XDATA_FDWH

           2 XFLASH_FDWH

SQL> select group_number, name, TOTAL_MB, FREE_MB from V$asm_disk_stat;

GROUP_NUMBER NAME                             TOTAL_MB    FREE_MB

------------ ------------------------------ ---------- ----------

           1              XDATA_FDWH_0021                    204828      22002

alter diskgroup XDATA_FDWH drop disk XDATA_FDWH_0021;

alter diskgroup XDATA_FDWH drop disk XDATA_FDWH_0021

*

ERROR at line 1:

ORA-15032: not all alterations performed

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center