敗家貓

環境 oracle11gR1

測試md_restore發生錯誤，但進去asmcmd下ls,可看到匯入失敗的diskgroup。但找了一些資料，並無法進行刪除
後來誤打誤撞，測出解決方法。如有人有正確的解法，也請告知，謝謝了
分享一下小弟的解法:

[oracle@c141 ~]$ asmcmd
lASMCMD>ls
ASM141/
ASMCMD> ls
ASM141/
-- 由這裏可看到只有一個diskgroup
ASMCMD> md_restore -b /tmp/data1.txt
Current Diskgroup being restored: DATA
ASMCMD-09352: CREATE DISKGROUP failed
ORA-15018: diskgroup cannot be created
ORA-15057: specified size of 7404 MB is larger than actual size of 2047 MB (DBD ERROR: OCIStmtExecute)
--匯入失敗
ASMCMD> ls
ASM141/
DATA/
ASMCMD> ls
ASM141/
DATA/
--但有看到建立了DATA這個diskgroup
ASMCMD> exit
[oracle@c141 ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Sun Feb 8 02:36:24 2009

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$asm_diskgroup;

NAME
------------------------------
ASM141

SQL> alter diskgroup all mount;
alter diskgroup all mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15017: diskgroup "ASM141" cannot be mounted
ORA-15013: diskgroup "ASM141" is already mounted


SQL> alter diskgroup data check;
alter diskgroup data check
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15001: diskgroup "DATA" does not exist or is not mounted


SQL> alter diskgroup asm141 check;

Diskgroup altered.
--做完上列這些無意議的事情後，怪事發生了
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@c141 ~]$ asmcmd
ls
ASMCMD> ASM141/
--匯入失敗的diskgroup DATA不見了=.="


下列為我當時抓的LOG
Sun Feb 08 02:35:34 2009
SQL> create diskgroup DATA EXTERNAL redundancy  disk '/dev/raw/raw1' name DATA_0000 size 7404M 
NOTE: Assigning number (2,0) to disk (/dev/raw/raw1)
NOTE: De-assigning number (2,0) from disk (/dev/raw/raw1)
ORA-15018: diskgroup cannot be created
ORA-15057: specified size of 7404 MB is larger than actual size of 2047 MB
ERROR: create diskgroup DATA EXTERNAL redundancy  disk '/dev/raw/raw1' name DATA_0000 size 7404M
kfdp_dismount(): 37
Sun Feb 08 02:35:35 2009
kfdp_dismountBg(): 37
ERROR: diskgroup DATA was not created
Sun Feb 08 02:36:43 2009
SQL> alter diskgroup all mount
WARNING: Deprecated privilege SYSDBA for command 'ALTER DISKGROUP MOUNT'
ORA-15032: not all alterations performed
ORA-15017: diskgroup "ASM141" cannot be mounted
ORA-15013: diskgroup "ASM141" is already mounted
ERROR: alter diskgroup all mount
Sun Feb 08 02:36:56 2009
SQL> alter diskgroup data check
ORA-15032: not all alterations performed
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ERROR: alter diskgroup data check
Sun Feb 08 02:37:07 2009
SQL> alter diskgroup asm141 check
WARNING: Deprecated privilege SYSDBA for command 'ALTER DISKGROUP CHECK'
NOTE: starting check of diskgroup ASM141
kfdp_checkDsk(): 38
kfdp_checkDsk(): 39
SUCCESS: check of diskgroup ASM141 found no errors
SUCCESS: alter diskgroup asm141 check