Restoration After all Oracle11gRACASM disks are lost

Restoration After all Oracle11gRACASM disks are lost, oracle11.2.0.3racon1_lelinux6x86 _ 64, with only one external redundant ASM disk mdash; m

Oracle 11g rac asm disk recovery after all loss, Oracle 11.2.0.3 rac on Oracle Linux 6 x86_64, only one ASM external redundant disk group mdash; m

I. Environment Description

(1) Oracle 11.2.0.3 rac on Oracle Linux 6 x86_64, with only one ASM external redundant disk group-DATA;
(2) OCR, VOTEDISK, DATAFILE, CONTROLFILE, and SPFILE are all on this disk group;

Ii. fault description

(1) Storage failure causes the loss of the ASM disk.
(2) due to the loss of OCR and VOTEDISK, the cluster ware service has stopped in addition to OHAS.

Iii. Backup status

(1) RMAN backup: including controlfile, database, spfile, archivelog,
(2) OCR backup: no manual backup has been performed, and CRS automatic backup files are available in the $ CRS_HOME/cdata directory.

Iv. Procedure

Note: You can use the files automatically backed up by CRS to recover the OCR and RMAN to recover the database. When preparing to recover data, you can adjust the ASM disk and separate OCR and VOTEDISK from the database files.

Recommended reading:

Oracle 11g from entry to proficient in PDF + CD source code

Solutions to various problems after installing Oracle 11gR2 in Ubuntu 12.04 (amd64)

4.1 restore OCR and VOTEDISK

(1) Stop the CRS service on all RAC nodes

[Root @ rac1 ~] # Crsctl stop has-fCRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1' CRS-2673: Attempting to stop' ora. mdnsd 'on 'rac1' CRS-2673: Attempting to stop' ora. crf 'on 'rac1' CRS-2677: Stop of 'ora. mdnsd 'on 'rac1' succeededCRS-2677: Stop of 'ora. crf 'on 'rac1' succeededCRS-2673: Attempting to stop' ora. gipcd 'on 'rac1' CRS-2677: Stop of 'ora. gipcd 'on 'rac1' succeededCRS-2673: Attempting to stop' ora. gpnpd 'on 'rac1' CRS-2677: Stop of 'ora. gpnpd 'on 'rac1' succeededCRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completedCRS-4133: Oracle High Availability Services has been stopped.

[Root @ rac2 ~] # Crsctl stop has-fCRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac2' CRS-2673: Attempting to stop' ora. mdnsd 'on 'rac2' CRS-2673: Attempting to stop' ora. crf 'on 'rac2' CRS-2677: Stop of 'ora. mdnsd 'on 'rac2' succeededCRS-2677: Stop of 'ora. crf 'on 'rac2' succeededCRS-2673: Attempting to stop' ora. gipcd 'on 'rac2' CRS-2677: Stop of 'ora. gipcd 'on 'rac2' succeededCRS-2673: Attempting to stop' ora. gpnpd 'on 'rac2' CRS-2677: Stop of 'ora. gpnpd 'on 'rac2' succeededCRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac2' has completedCRS-4133: Oracle High Availability Services has been stopped.

(2) Start CRS in NOCRS mode on a node. This operation starts the ASM instance.

[Root @ rac1 ~] # Crsctl start crs-excl-nocrsCRS-4123: Oracle High Availability Services has been started. CRS-2672: Attempting to start' ora. mdnsd 'on 'rac1' CRS-2676: Start of 'ora. mdnsd 'on 'rac1' succeededCRS-2672: Attempting to start' ora. gpnpd 'on 'rac1' CRS-2676: Start of 'ora. gpnpd 'on 'rac1' succeededCRS-2672: Attempting to start 'ora.css dmonitor' on 'rac1' CRS-2672: Attempting to start' ora. gipcd 'on 'rac1' CRS-2676: Start of 'ora.css dmonitor' on 'rac1' succeededCRS-2676: Start of 'ora. gipcd 'on 'rac1' succeededCRS-2672: Attempting to start 'ora.css d' on 'rac1' CRS-2672: Attempting to start' ora. diskmon 'on 'rac1' CRS-2676: Start of 'ora. diskmon 'on 'rac1' succeededCRS-2676: Start of 'ora.css d' on 'rac1' succeededCRS-2679: Attempting to clean' ora. cluster_interconnect.haip 'on 'rac1' CRS-2672: Attempting to start' ora. ctssd 'on 'rac1' CRS-2681: Clean of 'ora. cluster_interconnect.haip 'on 'rac1' succeededCRS-2672: Attempting to start' ora. cluster_interconnect.haip 'on 'rac1' CRS-2676: Start of 'ora. ctssd 'on 'rac1' succeededCRS-2676: Start of 'ora. cluster_interconnect.haip 'on 'rac1' succeededCRS-2672: Attempting to start' ora. asm 'on 'rac1' CRS-2676: Start of 'ora. asm 'on 'rac1' succeeded

(3) Three new disks have been added, and UDEV has been used for binding to view the disk status.

[Root @ rac1 ~] # Su-grid [grid @ rac1 ~] $ Sqlplus/as sysasmSQL * Plus: Release 11.2.0.3.0 Production on Fri Jul 5 17:41:49 2013 Copyright (c) 1982,201 1, Oracle. all rights reserved. connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionWith the Real Application Clusters and Automatic Storage Management optionsSQL> select group_number group #, disk_number disk #, OS _MB, state, path, header_status from v $ asm_disk order by 001024; GROUP # DISK # OS _MB STATEPATHHEADER_STATUS ---------- too large NORMAL/dev/asm-diskcCANDIDATE015120 NORMAL/dev/asm-diskdCANDIDATE0220480 NORMAL/dev/asm-diskbCANDIDATE

(4) create three disk groups. SYSTEMDG is used by CRS to store spfiles of OCR, VOTEDISK, and ASM instances. The other two are used by ORACLE. DATADG is used to store datafile, controlfile, redolog, spfile, and ARCLOGDG to store archivelog.

SQL> create diskgroup SYSTEMDG external redundancy 2 disk '/dev/asm-diskc '3 attribute' compatible. rdbms '= '11. 2', 'compatible. asm '= '11. 2'; Diskgroup created. SQL> create diskgroup DATADG external redundancy 2 disk '/dev/asm-diskb '3 attribute' compatible. rdbms '= '11. 2', 'compatible. asm '= '11. 2'; Diskgroup created. SQL> create diskgroup ARCLOGDG external redundancy 2 disk '/dev/asm-diskd '3 attribute' compatible. rdbms '= '11. 2', 'compatible. asm '= '11. 2'; Diskgroup created.

(5) Prepare to recover OCR and VOTEDISK. The ocr path is recorded in/etc/oracle/OCR. loc, and modify the value of ocrconfig_loc to restore OCR to the new disk group.

[Root @ rac1 ~] # More/etc/oracle/ocr. lococrconfig_loc = + DATAlocal_only = FALSE [root @ rac1 ~] # Vi/etc/oracle/ocr. lococrconfig_loc = + SYSTEMDGlocal_only = FALSE

(6) Restore OCR