Bonjour,
Env Oracle 10.2.0.4 sous win 2003 server.
J'ai "dropé" un diskgroup DATA avec:

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
SQL> drop diskgroup data including contents;
Diskgroup dropped.
 
SQL> select name from v$asm_diskgroup;
 
NAME
------------------------------
DATA
FLASH
 
ASMCMD> lsdg
State       Type    Rebal  Unbal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Name
DISMOUNTED          N      N         512   4096  1048576         0        0                0               0              0  DATA/
MOUNTED     NORMAL  N      N         512   4096  1048576     14858     4426             4096             165              0  FLASH/
 
 
select name, state, header_status from v$asm_disk
 
NAME                           STATE    HEADER_STATU
------------------------------ -------- ------------
                               NORMAL   FORMER
                               NORMAL   FORMER
                               NORMAL   FORMER
                               NORMAL   CANDIDATE
                               NORMAL   CANDIDATE
                               NORMAL   MEMBER
                               NORMAL   FORMER
                               NORMAL   FORMER
                               NORMAL   FORMER
                               NORMAL   FORMER
                               NORMAL   FORMER
 
FLASH_0002                     NORMAL   MEMBER
FLASH_0003                     NORMAL   MEMBER
FLASH_0005                     NORMAL   MEMBER
FLASH_0000                     NORMAL   MEMBER
Est ce qu'il y a moyen de passer le "HEADER_STTUS" dans V$ASM_DISK de FORMER à CANDIDAT ?

Pour ré-utilser le nom DATA de diskgroup, faut créer le diskgroup à nouveau ou faire un mount ?
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
SQL> alter diskgroup DATA mount;
alter diskgroup DATA mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA"
Merci.