Unable To Mount Or Drop A Diskgroup, Fails With Ora-15032 And Ora-15063_353423.1

rongshiyuan發表於2015-02-27
AI

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.1 [Release 10.1 to 10.2]
Information in this document applies to any platform.
***Checked for relevance on 11-Jul-2014***


Symptoms

Unable to get the diskgroup mounted or dropped.

SQL> ALTER DISKGROUP CIF_RECO_01 mount;
ALTER DISKGROUP CIF_RECO_01 mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15063: diskgroup "CIF_RECO_01" lacks quorum of 1 PST disks; 0 found



Main issue is that need to get this diskgroup dropped so can use the disks in another diskgroup. 

Cause

Dropping a diskgroup requires that it be mounted. If the diskgroup cannot be mounted then you need to overwrite the first block of the disk to make it not look like a disk in the diskgroup you want to drop. There are several ways to accomplish this. All of them are dangerous because you can destroy a working diskgroup if you type in the wrong device name for the disk

1. You can use 'dd' Unix command to write a block of zero on the disk header in block 0.
2. You can just add the disk to a new diskgroup using the FORCE option.
3. You can create a new diskgroup using all the disks in the old diskgroup with the FORCE option. The new diskgroup can then be mounted and dropped. The only advantage of this over choice 2 is that the FORCE adds are all done at once so the adds to new diskgroups can be done over time with out making a habit of using FORCE.

Solution

The following steps would be one way to accomplish this.

1.  Create a new diskgroup FORCE'ing disks over to new diskgroup.  Once disks are forced over to new diskgroup, the original diskgroup (CIF_RECO_01 in this example) no longer exists.

SQL> create diskgroup TEST_DG external redundancy
disk '/dev/raw/raw1' FORCE, '/dev/raw/raw3' FORCE;


Note: The previous statement is a destructive operation, since the ‘FORCE’ option will clear any former ASM metadata and initialize the disks with the new ASM metadata associated with the new diskgroup in question, therefore all the former data structures allocated in associated disks (specified in the CREATE DISKGROUP statement) will be wipe out. For this reason, if you are not sure about the listed disks, then please open a Service Request (SR) with Oracle Support and we will be glad to assist you with this task.


2. Verify mounted.

SQL> select name, state from v$asm_diskgroup;



3. Drop the new diskgroup to free up the disks.

SQL> drop diskgroup TEST_DG;

 

4. Verify disks header

 

SQL> select name,path,header_status from v$asm_disk;

 

The header_status for the disks should be FORMER, which indicates the disk was once part of a disk group, and it may be added to a new disk group with the ALTER DISKGROUP statement

5. Then add the disks to CIF_DATA_02, the intended diskgroup.

SQL> alter diskgroup CIF_DATA_02 add disk '/dev/raw/raw1', '/dev/raw/raw3';

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17252115/viewspace-1442889/，如需轉載，請註明出處，否則將追究法律責任。

相關文章