Bonjour,
Env Oracle 10.2.0.4 sous win 2003 server.
J'ai "dropé" un diskgroup DATA avec:
Est ce qu'il y a moyen de passer le "HEADER_STTUS" dans V$ASM_DISK de FORMER à CANDIDAT ?
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
Pour ré-utilser le nom DATA de diskgroup, faut créer le diskgroup à nouveau ou faire un mount ?
Merci.
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"
Partager