Oracle 11g RAC ASM VOTEDISK所在磁碟全部丟失重大故障恢復
Oracle 11g RAC ASM VOTEDISK所在磁碟全部丟失恢復
一、環境描述
系統:AIX 7100-02-03-1334
資料庫:Oracle 11.2.0.3.10 RAC ASM
二、故障描述
儲存故障導致ASM VOTEDISK所在磁碟全部丟失。
因為OCR和VOTEDISK的丟失,叢集服務終止,OHAS程式還在。
三、操作步驟
思路:使用CRS自動備份的檔案恢復OCR,VOTEDISK。
1)所有節點停掉CRS服務
root@testdb3:/#/oracle/app/11.2.0/grid/bin/crsctl stop crs -f
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'testdb3'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'testdb3'
CRS-2673: Attempting to stop 'ora.crf' on 'testdb3'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'testdb3'
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'testdb3'
CRS-2677: Stop of 'ora.cssdmonitor' on 'testdb3' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'testdb3' succeeded
CRS-2677: Stop of 'ora.crf' on 'testdb3' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'testdb3'
CRS-2677: Stop of 'ora.gipcd' on 'testdb3' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'testdb3'
CRS-2677: Stop of 'ora.gpnpd' on 'testdb3' succeeded
CRS-2677: Stop of 'ora.drivers.acfs' on 'testdb3' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'testdb3' has completed
CRS-4133: Oracle High Availability Services has been stopped.
root@testdb3:/#
root@testdb3:/#ps -ef |grep grid
root 2884826 3146642 0 15:56:44 pts/0 0:00 grep grid
2)在一個節點上以NOCRS方式啟動CRS,此操作會啟動ASM例項。
root@testdb3:/#/oracle/app/11.2.0/grid/bin/crsctl start crs -excl -nocrs
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start 'ora.mdnsd' on 'testdb3'
CRS-2676: Start of 'ora.mdnsd' on 'testdb3' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'testdb3'
CRS-2676: Start of 'ora.gpnpd' on 'testdb3' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'testdb3'
CRS-2672: Attempting to start 'ora.gipcd' on 'testdb3'
CRS-2676: Start of 'ora.cssdmonitor' on 'testdb3' succeeded
CRS-2676: Start of 'ora.gipcd' on 'testdb3' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'testdb3'
CRS-2672: Attempting to start 'ora.diskmon' on 'testdb3'
CRS-2676: Start of 'ora.diskmon' on 'testdb3' succeeded
CRS-2676: Start of 'ora.cssd' on 'testdb3' succeeded
CRS-2672: Attempting to start 'ora.drivers.acfs' on 'testdb3'
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'testdb3'
CRS-2672: Attempting to start 'ora.ctssd' on 'testdb3'
CRS-2676: Start of 'ora.ctssd' on 'testdb3' succeeded
CRS-2676: Start of 'ora.drivers.acfs' on 'testdb3' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'testdb3' succeeded
CRS-2679: Attempting to clean 'ora.asm' on 'testdb3'
CRS-2681: Clean of 'ora.asm' on 'testdb3' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'testdb3'
CRS-2676: Start of 'ora.asm' on 'testdb3' succeeded
3)新增一塊盤,修改許可權並在ASM中檢視磁碟狀態,建立一個新的磁碟組
root@testdb3:/#chown grid:asmadmin /dev/vx/rdmp/hitachi_vsp0_11d4
root@testdb3:/#chmod 660 /dev/vx/rdmp/hitachi_vsp0_11d4
root@testdb4:/#chown grid:asmadmin /dev/vx/rdmp/hitachi_vsp0_11d4
root@testdb4:/#chmod 660 /dev/vx/rdmp/hitachi_vsp0_11d4
root@testdb3:/#su - grid
$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 15 16:14:51 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> set pagesize 10000
SQL> set linesize 300
SQL> alter system set asm_diskstring = '/dev/vx/rdmp/*';
System altered.
SQL> set pagesize 10000 linesize 300
SQL> select group_number, disk_number, state, path from v$asm_disk order by 1,2;
GROUP_NUMBER DISK_NUMBER STATE PATH
------------ ----------- -------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
0 0 NORMAL /dev/rhitachi_v0_11cc
0 1 NORMAL /dev/rhitachi_v0_11cd
0 2 NORMAL /dev/rhitachi_v0_11ce
0 3 NORMAL /dev/rhitachi_v0_11cf
0 4 NORMAL /dev/rhitachi_v0_11d0
0 5 NORMAL /dev/rhitachi_v0_11d1
0 6 NORMAL /dev/rhitachi_v0_11d2
0 7 NORMAL /dev/rhitachi_v0_11d3
0 8 NORMAL /voting_disk/vote_disk_nfs
0 9 NORMAL /dev/vx/rdmp/hitachi_vsp0_11cc
0 10 NORMAL /dev/vx/rdmp/hitachi_vsp0_11cd
0 11 NORMAL /dev/vx/rdmp/hitachi_vsp0_11ce
0 12 NORMAL /dev/vx/rdmp/hitachi_vsp0_11cf
0 13 NORMAL /dev/vx/rdmp/hitachi_vsp0_11d0
0 14 NORMAL /dev/vx/rdmp/hitachi_vsp0_11d1
0 15 NORMAL /dev/vx/rdmp/hitachi_vsp0_11d2
0 16 NORMAL /dev/vx/rdmp/hitachi_vsp0_11d3
0 17 NORMAL /dev/vx/rdmp/hitachi_vsp0_11d4
18 rows selected.
SQL> create diskgroup OCRVOTE1 external redundancy
2 disk '/dev/vx/rdmp/hitachi_vsp0_11d4'
3 ATTRIBUTE 'compatible.rdbms' = '11.2','compatible.asm' = '11.2';
Diskgroup created.
4)修改/etc/oracle/ocr.loc檔案,將ocrconfig_loc修改成新增的磁碟組名稱,以便將OCR恢復到新的磁碟組中。
root@testdb3:/#cat /etc/oracle/ocr.loc
ocrconfig_loc=+OCRVOTE
local_only=FALSE
root@testdb3:/#vi /etc/oracle/ocr.loc
ocrconfig_loc=+OCRVOTE1
local_only=FALSE
5)從以前OCR備份中恢復OCR
root@testdb3:/#/oracle/app/11.2.0/grid/bin/ocrconfig -showbackup
PROT-26: Oracle Cluster Registry backup locations were retrieved from a local copy
testdb4 2014/07/03 15:55:26 /oracle/app/11.2.0/grid/cdata/testdb/backup00.ocr
testdb4 2014/07/03 11:55:25 /oracle/app/11.2.0/grid/cdata/testdb/backup01.ocr
testdb4 2014/07/03 07:55:25 /oracle/app/11.2.0/grid/cdata/testdb/backup02.ocr
testdb4 2014/07/01 23:55:22 /oracle/app/11.2.0/grid/cdata/testdb/day.ocr
testdb4 2014/06/20 07:54:56 /oracle/app/11.2.0/grid/cdata/testdb/week.ocr
testdb2 2014/05/27 09:37:16 /oracle/app/11.2.0/grid/cdata/testdb/backup_20140527_093716.ocr
testdb2 2014/05/27 09:37:10 /oracle/app/11.2.0/grid/cdata/testdb/backup_20140527_093710.ocr
testdb4 2014/05/26 16:06:13 /oracle/app/11.2.0/grid/cdata/testdb/backup_20140526_160613.ocr
testdb4 2014/05/26 16:05:54 /oracle/app/11.2.0/grid/cdata/testdb/backup_20140526_160554.ocr
testdb4 2014/05/26 16:04:48 /oracle/app/11.2.0/grid/cdata/testdb/backup_20140526_160448.ocr
root@testdb3:/#/oracle/app/11.2.0/grid/bin/ocrconfig -restore /oracle/app/11.2.0/grid/cdata/testdb/backup00.ocr
root@testdb3:/#/oracle/app/11.2.0/grid/bin/ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 3244
Available space (kbytes) : 258876
ID : 1187520997
Device/File Name : +OCRVOTE1
Device/File integrity check succeeded
Device/File not configured
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check succeeded
6)建立VOTEDISK
root@testdb3:/#/oracle/app/11.2.0/grid/bin/crsctl replace votedisk +OCRVOTE1
Successful addition of voting disk 833551381fb94fd0bf09eefda7f1b380.
Successful deletion of voting disk 89210622f0864ff0bf9517205691e679.
Successful deletion of voting disk 55c4ee685a824ff3bf6ce510bf09468e.
Successful deletion of voting disk 159234e88fe64f55bf0d4571362c3b07.
Successfully replaced voting disk group with +OCRVOTE1.
CRS-4266: Voting file(s) successfully replaced
root@testdb3:/#/oracle/app/11.2.0/grid/bin/crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 833551381fb94fd0bf09eefda7f1b380 (/dev/vx/rdmp/hitachi_vsp0_11d4) [OCRVOTE1]
Located 1 voting disk(s).
7)建立SPFILE並按照以前標準修改ASM引數,重啟ASM
$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 15 16:28:37 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> create spfile='+OCRVOTE1' from memory;
File created.
SQL> startup force mount;
ORA-32004: obsolete or deprecated parameter(s) specified for ASM instance
ASM instance started
Total System Global Area 342388736 bytes
Fixed Size 2221360 bytes
Variable Size 315001552 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
ASM diskgroups volume enabled
8)重啟CRS
root@testdb3:/#/oracle/app/11.2.0/grid/bin/crsctl stop crs -f
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'testdb3'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'testdb3'
CRS-2673: Attempting to stop 'ora.ctssd' on 'testdb3'
CRS-2673: Attempting to stop 'ora.asm' on 'testdb3'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'testdb3'
CRS-2677: Stop of 'ora.ctssd' on 'testdb3' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'testdb3' succeeded
CRS-2677: Stop of 'ora.asm' on 'testdb3' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'testdb3'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'testdb3' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'testdb3'
CRS-2677: Stop of 'ora.cssd' on 'testdb3' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'testdb3'
CRS-2677: Stop of 'ora.gipcd' on 'testdb3' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'testdb3'
CRS-2677: Stop of 'ora.gpnpd' on 'testdb3' succeeded
CRS-2677: Stop of 'ora.drivers.acfs' on 'testdb3' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'testdb3' has completed
CRS-4133: Oracle High Availability Services has been stopped.
root@testdb3:/#/oracle/app/11.2.0/grid/bin/crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
9)啟動節點2的CRS
修改節點2的ocr.loc
root@testdb4:/#vi /etc/oracle/ocr.loc
ocrconfig_loc=+OCRVOTE1
local_only=FALSE
root@testdb4:/#/oracle/app/11.2.0/grid/bin/crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
10)檢視CRS資源狀態,已恢復完成
$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCHDG.dg
ONLINE OFFLINE testdb3
ONLINE OFFLINE testdb4
ora.DATADG.dg
ONLINE OFFLINE testdb3
ONLINE OFFLINE testdb4
ora.LISTENER.lsnr
ONLINE ONLINE testdb3
ONLINE ONLINE testdb4
ora.OCRVOTE.dg
ONLINE OFFLINE testdb3
ONLINE OFFLINE testdb4
ora.SYSDG.dg
ONLINE OFFLINE testdb3
ONLINE OFFLINE testdb4
ora.asm
ONLINE ONLINE testdb3 Started
ONLINE ONLINE testdb4 Started
ora.gsd
OFFLINE OFFLINE testdb3
OFFLINE OFFLINE testdb4
ora.net1.network
ONLINE ONLINE testdb3
ONLINE ONLINE testdb4
ora.ons
ONLINE ONLINE testdb3
ONLINE ONLINE testdb4
ora.registry.acfs
ONLINE ONLINE testdb3
ONLINE ONLINE testdb4
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE testdb3
ora.cvu
1 ONLINE ONLINE testdb3
ora.oc4j
1 ONLINE ONLINE testdb3
ora.scan1.vip
1 ONLINE ONLINE testdb3
ora.testdb.db
1 ONLINE OFFLINE Instance Shutdown
3 ONLINE OFFLINE Instance Shutdown
ora.testdb3.vip
1 ONLINE ONLINE testdb3
ora.testdb4.vip
1 ONLINE ONLINE testdb4
$
一、環境描述
系統:AIX 7100-02-03-1334
資料庫:Oracle 11.2.0.3.10 RAC ASM
二、故障描述
儲存故障導致ASM VOTEDISK所在磁碟全部丟失。
因為OCR和VOTEDISK的丟失,叢集服務終止,OHAS程式還在。
三、操作步驟
思路:使用CRS自動備份的檔案恢復OCR,VOTEDISK。
1)所有節點停掉CRS服務
root@testdb3:/#/oracle/app/11.2.0/grid/bin/crsctl stop crs -f
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'testdb3'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'testdb3'
CRS-2673: Attempting to stop 'ora.crf' on 'testdb3'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'testdb3'
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'testdb3'
CRS-2677: Stop of 'ora.cssdmonitor' on 'testdb3' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'testdb3' succeeded
CRS-2677: Stop of 'ora.crf' on 'testdb3' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'testdb3'
CRS-2677: Stop of 'ora.gipcd' on 'testdb3' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'testdb3'
CRS-2677: Stop of 'ora.gpnpd' on 'testdb3' succeeded
CRS-2677: Stop of 'ora.drivers.acfs' on 'testdb3' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'testdb3' has completed
CRS-4133: Oracle High Availability Services has been stopped.
root@testdb3:/#
root@testdb3:/#ps -ef |grep grid
root 2884826 3146642 0 15:56:44 pts/0 0:00 grep grid
2)在一個節點上以NOCRS方式啟動CRS,此操作會啟動ASM例項。
root@testdb3:/#/oracle/app/11.2.0/grid/bin/crsctl start crs -excl -nocrs
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start 'ora.mdnsd' on 'testdb3'
CRS-2676: Start of 'ora.mdnsd' on 'testdb3' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'testdb3'
CRS-2676: Start of 'ora.gpnpd' on 'testdb3' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'testdb3'
CRS-2672: Attempting to start 'ora.gipcd' on 'testdb3'
CRS-2676: Start of 'ora.cssdmonitor' on 'testdb3' succeeded
CRS-2676: Start of 'ora.gipcd' on 'testdb3' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'testdb3'
CRS-2672: Attempting to start 'ora.diskmon' on 'testdb3'
CRS-2676: Start of 'ora.diskmon' on 'testdb3' succeeded
CRS-2676: Start of 'ora.cssd' on 'testdb3' succeeded
CRS-2672: Attempting to start 'ora.drivers.acfs' on 'testdb3'
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'testdb3'
CRS-2672: Attempting to start 'ora.ctssd' on 'testdb3'
CRS-2676: Start of 'ora.ctssd' on 'testdb3' succeeded
CRS-2676: Start of 'ora.drivers.acfs' on 'testdb3' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'testdb3' succeeded
CRS-2679: Attempting to clean 'ora.asm' on 'testdb3'
CRS-2681: Clean of 'ora.asm' on 'testdb3' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'testdb3'
CRS-2676: Start of 'ora.asm' on 'testdb3' succeeded
3)新增一塊盤,修改許可權並在ASM中檢視磁碟狀態,建立一個新的磁碟組
root@testdb3:/#chown grid:asmadmin /dev/vx/rdmp/hitachi_vsp0_11d4
root@testdb3:/#chmod 660 /dev/vx/rdmp/hitachi_vsp0_11d4
root@testdb4:/#chown grid:asmadmin /dev/vx/rdmp/hitachi_vsp0_11d4
root@testdb4:/#chmod 660 /dev/vx/rdmp/hitachi_vsp0_11d4
root@testdb3:/#su - grid
$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 15 16:14:51 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> set pagesize 10000
SQL> set linesize 300
SQL> alter system set asm_diskstring = '/dev/vx/rdmp/*';
System altered.
SQL> set pagesize 10000 linesize 300
SQL> select group_number, disk_number, state, path from v$asm_disk order by 1,2;
GROUP_NUMBER DISK_NUMBER STATE PATH
------------ ----------- -------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
0 0 NORMAL /dev/rhitachi_v0_11cc
0 1 NORMAL /dev/rhitachi_v0_11cd
0 2 NORMAL /dev/rhitachi_v0_11ce
0 3 NORMAL /dev/rhitachi_v0_11cf
0 4 NORMAL /dev/rhitachi_v0_11d0
0 5 NORMAL /dev/rhitachi_v0_11d1
0 6 NORMAL /dev/rhitachi_v0_11d2
0 7 NORMAL /dev/rhitachi_v0_11d3
0 8 NORMAL /voting_disk/vote_disk_nfs
0 9 NORMAL /dev/vx/rdmp/hitachi_vsp0_11cc
0 10 NORMAL /dev/vx/rdmp/hitachi_vsp0_11cd
0 11 NORMAL /dev/vx/rdmp/hitachi_vsp0_11ce
0 12 NORMAL /dev/vx/rdmp/hitachi_vsp0_11cf
0 13 NORMAL /dev/vx/rdmp/hitachi_vsp0_11d0
0 14 NORMAL /dev/vx/rdmp/hitachi_vsp0_11d1
0 15 NORMAL /dev/vx/rdmp/hitachi_vsp0_11d2
0 16 NORMAL /dev/vx/rdmp/hitachi_vsp0_11d3
0 17 NORMAL /dev/vx/rdmp/hitachi_vsp0_11d4
18 rows selected.
SQL> create diskgroup OCRVOTE1 external redundancy
2 disk '/dev/vx/rdmp/hitachi_vsp0_11d4'
3 ATTRIBUTE 'compatible.rdbms' = '11.2','compatible.asm' = '11.2';
Diskgroup created.
4)修改/etc/oracle/ocr.loc檔案,將ocrconfig_loc修改成新增的磁碟組名稱,以便將OCR恢復到新的磁碟組中。
root@testdb3:/#cat /etc/oracle/ocr.loc
ocrconfig_loc=+OCRVOTE
local_only=FALSE
root@testdb3:/#vi /etc/oracle/ocr.loc
ocrconfig_loc=+OCRVOTE1
local_only=FALSE
5)從以前OCR備份中恢復OCR
root@testdb3:/#/oracle/app/11.2.0/grid/bin/ocrconfig -showbackup
PROT-26: Oracle Cluster Registry backup locations were retrieved from a local copy
testdb4 2014/07/03 15:55:26 /oracle/app/11.2.0/grid/cdata/testdb/backup00.ocr
testdb4 2014/07/03 11:55:25 /oracle/app/11.2.0/grid/cdata/testdb/backup01.ocr
testdb4 2014/07/03 07:55:25 /oracle/app/11.2.0/grid/cdata/testdb/backup02.ocr
testdb4 2014/07/01 23:55:22 /oracle/app/11.2.0/grid/cdata/testdb/day.ocr
testdb4 2014/06/20 07:54:56 /oracle/app/11.2.0/grid/cdata/testdb/week.ocr
testdb2 2014/05/27 09:37:16 /oracle/app/11.2.0/grid/cdata/testdb/backup_20140527_093716.ocr
testdb2 2014/05/27 09:37:10 /oracle/app/11.2.0/grid/cdata/testdb/backup_20140527_093710.ocr
testdb4 2014/05/26 16:06:13 /oracle/app/11.2.0/grid/cdata/testdb/backup_20140526_160613.ocr
testdb4 2014/05/26 16:05:54 /oracle/app/11.2.0/grid/cdata/testdb/backup_20140526_160554.ocr
testdb4 2014/05/26 16:04:48 /oracle/app/11.2.0/grid/cdata/testdb/backup_20140526_160448.ocr
root@testdb3:/#/oracle/app/11.2.0/grid/bin/ocrconfig -restore /oracle/app/11.2.0/grid/cdata/testdb/backup00.ocr
root@testdb3:/#/oracle/app/11.2.0/grid/bin/ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 3244
Available space (kbytes) : 258876
ID : 1187520997
Device/File Name : +OCRVOTE1
Device/File integrity check succeeded
Device/File not configured
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check succeeded
6)建立VOTEDISK
root@testdb3:/#/oracle/app/11.2.0/grid/bin/crsctl replace votedisk +OCRVOTE1
Successful addition of voting disk 833551381fb94fd0bf09eefda7f1b380.
Successful deletion of voting disk 89210622f0864ff0bf9517205691e679.
Successful deletion of voting disk 55c4ee685a824ff3bf6ce510bf09468e.
Successful deletion of voting disk 159234e88fe64f55bf0d4571362c3b07.
Successfully replaced voting disk group with +OCRVOTE1.
CRS-4266: Voting file(s) successfully replaced
root@testdb3:/#/oracle/app/11.2.0/grid/bin/crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 833551381fb94fd0bf09eefda7f1b380 (/dev/vx/rdmp/hitachi_vsp0_11d4) [OCRVOTE1]
Located 1 voting disk(s).
7)建立SPFILE並按照以前標準修改ASM引數,重啟ASM
$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 15 16:28:37 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> create spfile='+OCRVOTE1' from memory;
File created.
SQL> startup force mount;
ORA-32004: obsolete or deprecated parameter(s) specified for ASM instance
ASM instance started
Total System Global Area 342388736 bytes
Fixed Size 2221360 bytes
Variable Size 315001552 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
ASM diskgroups volume enabled
8)重啟CRS
root@testdb3:/#/oracle/app/11.2.0/grid/bin/crsctl stop crs -f
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'testdb3'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'testdb3'
CRS-2673: Attempting to stop 'ora.ctssd' on 'testdb3'
CRS-2673: Attempting to stop 'ora.asm' on 'testdb3'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'testdb3'
CRS-2677: Stop of 'ora.ctssd' on 'testdb3' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'testdb3' succeeded
CRS-2677: Stop of 'ora.asm' on 'testdb3' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'testdb3'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'testdb3' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'testdb3'
CRS-2677: Stop of 'ora.cssd' on 'testdb3' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'testdb3'
CRS-2677: Stop of 'ora.gipcd' on 'testdb3' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'testdb3'
CRS-2677: Stop of 'ora.gpnpd' on 'testdb3' succeeded
CRS-2677: Stop of 'ora.drivers.acfs' on 'testdb3' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'testdb3' has completed
CRS-4133: Oracle High Availability Services has been stopped.
root@testdb3:/#/oracle/app/11.2.0/grid/bin/crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
9)啟動節點2的CRS
修改節點2的ocr.loc
root@testdb4:/#vi /etc/oracle/ocr.loc
ocrconfig_loc=+OCRVOTE1
local_only=FALSE
root@testdb4:/#/oracle/app/11.2.0/grid/bin/crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
10)檢視CRS資源狀態,已恢復完成
$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCHDG.dg
ONLINE OFFLINE testdb3
ONLINE OFFLINE testdb4
ora.DATADG.dg
ONLINE OFFLINE testdb3
ONLINE OFFLINE testdb4
ora.LISTENER.lsnr
ONLINE ONLINE testdb3
ONLINE ONLINE testdb4
ora.OCRVOTE.dg
ONLINE OFFLINE testdb3
ONLINE OFFLINE testdb4
ora.SYSDG.dg
ONLINE OFFLINE testdb3
ONLINE OFFLINE testdb4
ora.asm
ONLINE ONLINE testdb3 Started
ONLINE ONLINE testdb4 Started
ora.gsd
OFFLINE OFFLINE testdb3
OFFLINE OFFLINE testdb4
ora.net1.network
ONLINE ONLINE testdb3
ONLINE ONLINE testdb4
ora.ons
ONLINE ONLINE testdb3
ONLINE ONLINE testdb4
ora.registry.acfs
ONLINE ONLINE testdb3
ONLINE ONLINE testdb4
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE testdb3
ora.cvu
1 ONLINE ONLINE testdb3
ora.oc4j
1 ONLINE ONLINE testdb3
ora.scan1.vip
1 ONLINE ONLINE testdb3
ora.testdb.db
1 ONLINE OFFLINE Instance Shutdown
3 ONLINE OFFLINE Instance Shutdown
ora.testdb3.vip
1 ONLINE ONLINE testdb3
ora.testdb4.vip
1 ONLINE ONLINE testdb4
$
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/25964700/viewspace-1653709/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 針對11.2 RAC丟失OCR和Votedisk所在ASM Diskgroup的恢復手段ASM
- RAC共享磁碟物理路徑故障導致OCR、Votedisk所在ASM磁碟組不可訪問的案例分析ASM
- RAC 11G ASM磁碟損壞恢復ASM
- 遷移ocr/votedisk/asm spfile所在磁碟組ASM
- 【RAC】Oracle11g RAC CRS磁碟丟失後恢復Oracle
- Oracle database 11g rac損壞ocr和votedisk恢復實驗OracleDatabase
- 存貯在asm中的ocr/votedisk/asm磁碟組損害的恢復ASM
- ASM之OCR所在磁碟組損壞後的恢復ASM
- Oracle OCR和VOTEDISK故障修復Oracle
- asm磁碟組中的磁碟頭資訊丟失恢復實驗ASM
- Oracle asm磁碟損壞異常恢復OracleASM
- Oracle 10g rac+asm 磁碟頭備份與恢復實驗Oracle 10gASM
- Oracle ASM故障資料恢復解決方案OracleASM資料恢復
- 控制檔案全部丟失恢復
- oracle 線上日誌全部丟失的資料恢復Oracle資料恢復
- dbca建立oracle 11g rac發現不了asm磁碟OracleASM
- [zt]Oracle rac 11g線上新增ocr,votediskOracle
- Oracle 目錄許可權丟失故障恢復Oracle
- Oracle Database 12c RAC損壞ocr和votedisk恢復實驗OracleDatabase
- 紅色警報 ORACLE RAC 11.2.0.4 FOR SOLARIS 10 ASM 和DB因叢集心跳丟失重啟OracleASM
- RMAN恢復案例:丟失全部資料檔案恢復
- ORACLE RAC重建ASM磁碟組OracleASM
- 控制檔案全部丟失的恢復
- 11G ORACLE RAC DBCA 無法識別asm磁碟組OracleASM
- oracle 12c裡如何恢復votediskOracle
- ASM磁碟組丟失member kfed修復ASM
- 一次asm磁碟頭部資訊丟失故障ASM
- Oracle10g 10.2.0.5 RAC一次恢復ORC、votedisk實戰Oracle
- oracle rac 在asm下的備份與恢復OracleASM
- 【ASK_ORACLE】Oracle表決磁碟丟失後的恢復方法Oracle
- oracle rac 無法建立asm磁碟OracleASM
- 當前控制檔案全部丟失恢復
- 11G RAC 為 ASM 磁碟組增加一個磁碟。(AIX)ASMAI
- RAC asm恢復到單例項ASM單例
- 恢復案例:無歸檔,掉電,控制檔案全部丟失恢復
- UDEV方式配置Oracle RAC ASM共享磁碟devOracleASM
- 記一次oracle資料庫redolog全部丟失的恢復Oracle資料庫
- 恢復案例:歸檔模式下丟失全部資料檔案的恢復模式