遷移ocr/votedisk/asm spfile所在磁碟組
環境：redhat6.5 oracle11.2.0.3兩節點RAC
本實驗將ocr/votedisk/asm spfile所在磁碟組遷移到另外一個磁碟組
[grid@hp580-5 ~]$ asmcmd
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED NORMAL N 512 4096 1048576 1536000 1418049 512000 453024 0 Y DATA/
MOUNTED EXTERN N 512 4096 1048576 512000 504395 0 504395 0 N FRA/
MOUNTED EXTERN N 512 4096 1048576 512000 511901 0 511901 0 N SYS/
ASMCMD> exit
[grid@hp580-5 ~]$ crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 2994b1890e944fc7bf13744a8c98f5ea (/dev/asm-diskc) [DATA]
2. ONLINE 0e8b5764cd5a4fb6bf74fe7058745670 (/dev/asm-diskd) [DATA]
3. ONLINE 62a1876953964f16bff300704a04717a (/dev/asm-diske) [DATA]
Located 3 voting disk(s).
[grid@hp580-5 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2972
Available space (kbytes) : 259148
ID : 1794026097
Device/File Name : +DATA
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 bypassed due to non-privileged user
[grid@hp580-5 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Mon Mar 9 15:52:41 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/hp580-cluster/asmparamet
erfile/registry.253.854119569
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
[grid@hp580-5 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE hp580-4
ONLINE ONLINE hp580-5
ora.FRA.dg
ONLINE ONLINE hp580-4
ONLINE ONLINE hp580-5
ora.LISTENER.lsnr
ONLINE ONLINE hp580-4
ONLINE ONLINE hp580-5
ora.SYS.dg
ONLINE ONLINE hp580-4
ONLINE ONLINE hp580-5
ora.asm
ONLINE ONLINE hp580-4 Started
ONLINE ONLINE hp580-5 Started
ora.gsd
OFFLINE OFFLINE hp580-4
OFFLINE OFFLINE hp580-5
ora.net1.network
ONLINE ONLINE hp580-4
ONLINE ONLINE hp580-5
ora.ons
ONLINE ONLINE hp580-4
ONLINE ONLINE hp580-5
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE hp580-5
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE hp580-4
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE hp580-4
ora.cvu
1 ONLINE ONLINE hp580-4
ora.hp580-4.vip
1 ONLINE ONLINE hp580-4
ora.hp580-5.vip
1 ONLINE ONLINE hp580-5
ora.oc4j
1 ONLINE ONLINE hp580-4
ora.orcl.db
1 ONLINE ONLINE hp580-4 Open
2 ONLINE ONLINE hp580-5 Open
ora.scan1.vip
1 ONLINE ONLINE hp580-5
ora.scan2.vip
1 ONLINE ONLINE hp580-4
ora.scan3.vip
1 ONLINE ONLINE hp580-4
[grid@hp580-5 ~]$ ocrconfig -add +sys
PROT-20: Insufficient permission to proceed. Require privileged user
[grid@hp580-5 ~]$ echo $ORACLE_HOME
/g01/app/11.2.0/grid
[grid@hp580-5 ~]$ exit
logout
[root@hp580-5 dev]# cd /g01/app/11.2.0/grid/bin
[root@hp580-5 bin]# ./ocrconfig -add +sys
[root@hp580-5 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2972
Available space (kbytes) : 259148
ID : 1794026097
Device/File Name : +DATA
Device/File integrity check succeeded
Device/File Name : +sys
Device/File integrity check succeeded
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check succeeded
[root@hp580-5 bin]# ./crsctl replace votedisk +sys
Successful addition of voting disk 1600c0ff5c084fa9bf2bb00d1381d589.
Successful deletion of voting disk 2994b1890e944fc7bf13744a8c98f5ea.
Successful deletion of voting disk 0e8b5764cd5a4fb6bf74fe7058745670.
Successful deletion of voting disk 62a1876953964f16bff300704a04717a.
Successfully replaced voting disk group with +sys.
CRS-4266: Voting file(s) successfully replaced
[root@hp580-5 bin]# ./ocrconfig -delete +data
[root@hp580-5 bin]# su - grid
[grid@hp580-5 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2972
Available space (kbytes) : 259148
ID : 1794026097
Device/File Name : +sys
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 bypassed due to non-privileged user
[grid@hp580-5 ~]$ crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 1600c0ff5c084fa9bf2bb00d1381d589 (/dev/asm-diskg) [SYS]
Located 1 voting disk(s).
SQL> connect / as sysdba
Connected.
SQL> create pfile='/tmp/pfile.ora' from spfile;
SQL> create spfile='+SYS' from pfile='/tmp/pfile.ora';
File created.
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/hp580-cluster/asmparamet
erfile/registry.253.854119569
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
[root@hp580-5 bin]# ./crsctl stop crs
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'hp580-5'
CRS-2673: Attempting to stop 'ora.crsd' on 'hp580-5'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'hp580-5'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'hp580-5'
CRS-2673: Attempting to stop 'ora.SYS.dg' on 'hp580-5'
CRS-2673: Attempting to stop 'ora.orcl.db' on 'hp580-5'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'hp580-5'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'hp580-5' succeeded
CRS-2673: Attempting to stop 'ora.hp580-5.vip' on 'hp580-5'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'hp580-5' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'hp580-5'
CRS-2677: Stop of 'ora.hp580-5.vip' on 'hp580-5' succeeded
CRS-2672: Attempting to start 'ora.hp580-5.vip' on 'hp580-4'
CRS-2677: Stop of 'ora.scan1.vip' on 'hp580-5' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'hp580-4'
CRS-2677: Stop of 'ora.orcl.db' on 'hp580-5' succeeded
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'hp580-5'
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'hp580-5'
CRS-2676: Start of 'ora.hp580-5.vip' on 'hp580-4' succeeded
CRS-2676: Start of 'ora.scan1.vip' on 'hp580-4' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'hp580-4'
CRS-2677: Stop of 'ora.FRA.dg' on 'hp580-5' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'hp580-4' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'hp580-5' succeeded
CRS-2677: Stop of 'ora.SYS.dg' on 'hp580-5' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'hp580-5'
CRS-2677: Stop of 'ora.asm' on 'hp580-5' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'hp580-5'
CRS-2677: Stop of 'ora.ons' on 'hp580-5' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'hp580-5'
CRS-2677: Stop of 'ora.net1.network' on 'hp580-5' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'hp580-5' has completed
CRS-2677: Stop of 'ora.crsd' on 'hp580-5' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'hp580-5'
CRS-2673: Attempting to stop 'ora.ctssd' on 'hp580-5'
CRS-2673: Attempting to stop 'ora.evmd' on 'hp580-5'
CRS-2673: Attempting to stop 'ora.asm' on 'hp580-5'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'hp580-5'
CRS-2677: Stop of 'ora.crf' on 'hp580-5' succeeded
CRS-2677: Stop of 'ora.evmd' on 'hp580-5' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'hp580-5' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'hp580-5' succeeded
CRS-2677: Stop of 'ora.asm' on 'hp580-5' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'hp580-5'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'hp580-5' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'hp580-5'
CRS-2677: Stop of 'ora.cssd' on 'hp580-5' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'hp580-5'
CRS-2677: Stop of 'ora.gipcd' on 'hp580-5' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'hp580-5'
CRS-2677: Stop of 'ora.gpnpd' on 'hp580-5' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'hp580-5' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@hp580-5 bin]#
[root@hp580-5 bin]# ./crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
[root@hp580-5 bin]# su - grid
[grid@hp580-5 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Mon Mar 9 16:26:53 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +SYS/hp580-cluster/asmparamete
rfile/registry.253.873908213
SQL>
重起另一個節點的crs即OK
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26870952/viewspace-1453727/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 遷移ASM磁碟組ASM
- 遷移OCR和VotingDisk並刪除原ASM磁碟組ASM
- ASM下遷移spfileASM
- ASM重新命名包含OCR/vote file的磁碟組ASM
- 從定位資料塊所在ASM磁碟到ASM strippingASM
- ASM磁碟組限制ASM
- 將spfile從ASM裡遷移到檔案系統ASM
- oracle遷移OCR盤Oracle
- 【ASM】Oracle asm磁碟被格式化，如何掛載該磁碟組ASMOracle
- 【ASM】Oracle asm刪除磁碟組注意事項ASMOracle
- Oracle 12c rac ocr和votedisk管理Oracle
- ASM磁碟組更換磁碟的操作方法ASM
- 更換ocr和votingdisk磁碟組
- 【ASM】ASM啟動無法找到spfile問題原因ASM
- ASM 磁碟組的建立及擴容ASM
- ORACLE ASM磁碟組空間溢位OracleASM
- 使用udev擴充套件ASM磁碟組dev套件ASM
- ASM磁碟組擴容操作文件ASM
- Oracle RAC 遷移替換 OCR 盤Oracle
- Oracle ASM磁碟組擴容(AIX7.1)OracleASMAI
- ASM磁碟組ORA-15042 ORA-15096ASM
- 一次ASM新增新的磁碟組ASM
- Oracle RAC環境下ASM磁碟組擴容OracleASM
- RAC之grid叢集安裝及ASM磁碟組配置ASM
- Oracle RAC ASM磁碟組擴容時遇到的VIP漂移OracleASM
- 基於裸裝置的ASM磁碟組擴容方案ASM
- 資料檔案遷移至其他磁碟組
- Oracle Database 12c RAC損壞ocr和votedisk恢復實驗OracleDatabase
- 【ASM】ASM磁碟頭被重寫，如何修復ASM
- （grid重灌後圖形介面報錯）ASM磁碟組字元介面配置ASM字元
- asm磁碟組依賴導致資料庫自啟動報錯ASM資料庫
- 【ARCH】Oracle 判斷asm磁碟組大小，超過閾值清理指令碼OracleASM指令碼
- 在ASM磁碟組中刪除歸檔日誌報ORA-15028ASM
- 2.7.2 遷移到伺服器引數檔案(spfile)伺服器
- ASM磁碟簡單維護，新增，刪除ASM
- Oracle RAC日常運維-ASM磁碟擴容Oracle運維ASM
- ORACLE ASM的SSD磁碟空間回收分析OracleASM
- Oracle asm磁碟損壞異常恢復OracleASM
- 【BUILD_ORACLE】使用ASMLib包搭建ASM磁碟UIOracleASM