The following is the ASM DG details:
GROUP_NUMBER NAME MOUNT_S HEADER_STATU MODE_ST STATE TOTAL_MB FREE_MB NAME PATH AU_SIZE TYPE
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
2 FLASH CACHED MEMBER ONLINE NORMAL 10236 9678 FLASH wouldn: 1048576 EXTERN FLASH
1 the DATA CACHED MEMBER ONLINE NORMAL 10236 9840 MYASMD1 former: 1048576 NORMAL MYASMD1
1 the DATA CACHED MEMBER ONLINE NORMAL 10236 9840 MYASMD2 former: 1048576 NORMAL MYASMD2
1 the DATA CACHED MEMBER ONLINE DROPPING 10236 10202 MYASMD3 former: 1048576 NORMAL MYASMD3
4 T1 CACHED MEMBER ONLINE NORMAL 10236 10143 MYASMD4 former: MYASMD4 EXTERN 1048576
3 RACBASE CACHED MEMBER ONLINE NORMAL 10236 6102 RACBASE former: RACBASE EXTERN 1048576
The DISK wouldn: MYASMD4 is deleted after reconstruction of the DISK GROUP in the DATA GROUP, DISK wouldn: MYASMD3 the same operation, I then rebuilt on the plate DISK GROUP has an error:
SQL> The create diskgroup t2 external redundancy disk 'former: MYASMD3';
The create diskgroup t2 external redundancy disk 'former: MYASMD3'
*
The ERROR at line 1:
ORA - 15018: diskgroup always be created
ORA - 15029: disk 'former: MYASMD3' is already mounted by this instance
RAC node environment, another node of the ASM and the disk the same case, there is no another node mounted,
CodePudding user response:
MYASMD3 no removed from inside the data DG success?CodePudding user response:
This MYASMD3 not also in DATA in disk group?CodePudding user response:
Don't delete it,,,,,,,,CodePudding user response:
Don't delete, such as synchronization, released can be added to the other groupsCodePudding user response:
Directory permissions changed, add the oracle installation directory permissions everyone full control, and then operating,CodePudding user response:
On a back to the wrong postCodePudding user response:
Several days, this disk has been DROPPINGCodePudding user response:
DISKGROUP T1 was spun off from the DATA, I try again to delete and create new DISKGROUP results still won't do
SQL> The alter diskgroup data drop disk MYASMD3;
The alter diskgroup data drop disk MYASMD3
*
The ERROR at line 1:
ORA - 15032: not all alterations performed
ORA - 15071: ASM disk "MYASMD3" is already being dropped
SQL> The create diskgroup t2 external redundancy disk 'former: MYASMD3';
The create diskgroup t2 external redundancy disk 'former: MYASMD3'
*
The ERROR at line 1:
ORA - 15018: diskgroup always be created
ORA - 15029: disk 'former: MYASMD3' is already mounted by this instance
CodePudding user response:
Release DG T1 deleted disks (10 g), and then divided into smaller (1 g * 3 and 7 g * 1), the three small pieces of 1 g the DATA DG, success is as follows:
SQL> The DROP DISKGROUP T1 o CONTENTS;
Diskgroup dropped.
SQL> The ALTER DISKGROUP DATA UNDROP DISKS.
Diskgroup altered.
GROUP_NUMBER NAME FAILGROUP MOUNT_S HEADER_STATU MODE_ST STATE TOTAL_MB FREE_MB NAME PATH AU_SIZE TYPE
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
2 FLASH FLASH CACHED MEMBER ONLINE NORMAL 10236 9678 FLASH wouldn: 1048576 EXTERN FLASH
1 DATA MYASMD1 CACHED MEMBER ONLINE NORMAL 10236 9840 MYASMD1 former: 1048576 NORMAL MYASMD1
1 DATA MYASMD2 CACHED MEMBER ONLINE NORMAL 10236 9840 MYASMD2 former: 1048576 NORMAL MYASMD2
1 DATA MYASMD3 CACHED MEMBER ONLINE NORMAL 10236 10177 MYASMD3 former: 1048576 NORMAL MYASMD3
3 RACBASE RACBASE CACHED MEMBER ONLINE NORMAL 10236 6036 RACBASE former: RACBASE EXTERN 1048576
SQL> The select al-qeada roup_number, a.f ailgroup, arjun ount_status, a.h eader_status, arjun ode_status, a.s Tate, a.t otal_mb, a.f ree_mb, a.n ame, Amy polumbo ath the from v $asm_disk a;
GROUP_NUMBER FAILGROUP MOUNT_S HEADER_STATU MODE_ST STATE TOTAL_MB FREE_MB NAME PATH
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
0 CLOSED PROVISIONED ONLINE NORMAL 0 0 former: DATA2
0 CLOSED PROVISIONED ONLINE NORMAL 0 0 former: MYASMD41
0 CLOSED PROVISIONED ONLINE NORMAL 0 0 former: MYASMD42
0 CLOSED PROVISIONED ONLINE NORMAL 0 0 former: MYASMD43
2 FLASH CACHED MEMBER ONLINE NORMAL 10236 9678 FLASH wouldn: FLASH
1 MYASMD1 CACHED MEMBER ONLINE NORMAL 10236 9927 MYASMD1 former: MYASMD1
1 MYASMD2 CACHED MEMBER ONLINE NORMAL 10236 9926 MYASMD2 former: MYASMD2
1 MYASMD3 CACHED MEMBER ONLINE NORMAL 10236 9929 MYASMD3 former: MYASMD3
3 RACBASE CACHED MEMBER ONLINE NORMAL 10236 6036 RACBASE former: RACBASE
SQL> nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull