oracle遷移OCR盤
遷移OCR
1.dd新的盤
dd if=/dev/zero of=/dev/mapper/mpathd bs=1M count=1024
2.建立新的ocr磁碟組(1節點)
create diskgroup VOT external redundancy disk '/dev/asm-diskd' attribute 'compatible.rdbms'='11.2','compatible.asm'='11.2';
3.2節點mount磁碟組
alter diskgroup VOT mount;
4.用ocrcheck檢視ocr資訊
[grid@ear1 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2984
Available space (kbytes) : 259136
ID : 1650000229
Device/File Name : +OCR
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
5.新的磁碟組新增ocr
/oracle/grid/crs_1/bin/ocrconfig -add +VOT
6.用ocrcheck檢視ocr資訊
[grid@ear1 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2980
Available space (kbytes) : 259140
ID : 1650000229
Device/File Name : +OCR
Device/File integrity check succeeded
Device/File Name : +VOT
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 bypassed due to non-privileged user
7.檢視vote資訊
[grid@ear1 ~]$ crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 9884ef58d7f64ff2bf0ac7302563830b (/dev/asm-diskb) [OCR]
Located 1 voting disk(s).
8.vote替換磁碟組
crsctl replace votedisk +VOT
9.再次檢視vote資訊
[grid@ear1 ~]$ crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE b0669b6b47b74f94bfe83061594de6d5 (/dev/asm-diskd) [VOT]
Located 1 voting disk(s).
10.檢視叢集狀態
crsctl stat res -t
11.重建spfile(gi)
show parameter spfile;
create pfile='/tmp/asmpfile.ora' from spfile;
create spfile='+VOT' from pfile='/tmp/asmpfile.ora';
12.重啟crs(cluster -all是2邊同時關、開)(1邊操作即可)
/oracle/grid/crs_1/bin/crsctl stop cluster -all
/oracle/grid/crs_1/bin/crsctl start cluster -all
13.確認spfile更改自動更改過
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +VOT/ear-cluster/asmparameterf
ile/registry.253.1088567353
14.檢視ocr.loc檔案
[root@ear1 ~]# more /etc/oracle/ocr.loc
#Device/file getting replaced by device +VOT
ocrconfig_loc=+OCR
ocrmirrorconfig_loc=+VOT
local_only=false
15.刪除舊ocr盤的ocr資訊(1節點)
/oracle/grid/crs_1/bin/ocrconfig -delete +OCR
16.2節點dismount掉舊ocr磁碟組(如果先dismount再跑上一步,會報ORA-15027: active use of diskgroup "OCR" precludes its dismount)
alter diskgroup OCR dismount;
17.1節點刪除磁碟組
drop diskgroup OCR including contents;
如果使用上述方法無法刪除ocrvote磁碟組,採用強制刪除的方法來完成(以下命令分別在一二節點執行):
alter diskgroup OCRVOTE dismount force;
drop diskgroup OCRVOTE including contents;
18.確認vote遷移完成
方法一、
[grid@ear1 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2960
Available space (kbytes) : 259160
ID : 1650000229
Device/File Name : +VOT
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@ear1 ~]$ crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE b0669b6b47b74f94bfe83061594de6d5 (/dev/asm-diskd) [VOT]
Located 1 voting disk(s).
方法三、
[grid@ear1 ~]$ more /etc/oracle/ocr.loc
#Device/file +OCR getting replaced by device +VOT
ocrconfig_loc=+VOT
local_only=false
來自 “ ITPUB部落格 ” ,連結:https://blog.itpub.net/69980685/viewspace-3001492/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle RAC 遷移替換 OCR 盤Oracle
- Oracle遷移文件大全Oracle
- Oracle遷移文章大全Oracle
- Windows 遷移系統盤Windows
- oracle xtts遷移 AIX to LinuxOracleTTSAILinux
- 遷移OCR和VotingDisk並刪除原ASM磁碟組ASM
- Oracle rman duplicate遷移測試Oracle
- AWS RDS Oracle資料遷移Oracle
- oracle 19c pdb遷移Oracle
- 使用GoldenGate 遷移Oracle到PostgreSQL/LightDBGoOracleSQL
- 遷移oracle使用者密碼Oracle密碼
- 連載一:Oracle遷移文件大全Oracle
- 連載二:Oracle遷移文章大全Oracle
- oracle重建ocrOracle
- 【XTTS】Oracle XTTS V4--Oracle11.2.0.4+ 遷移升級TTSOracle
- Oracle資料庫(DataGuard)遷移方案(下)Oracle資料庫
- Oracle資料庫(DataGuard)遷移方案(上)Oracle資料庫
- Oracle資料庫(DataGuard)遷移方案(中)Oracle資料庫
- Oracle中表空間、表、索引的遷移Oracle索引
- 【STATS】Oracle遷移表統計資訊Oracle
- 無外網Oracle資料庫遷移Oracle資料庫
- Oracle使用RMAN從Windows遷移資料到LinuxOracleWindowsLinux
- Oracle 12cbigfile表空間物件遷移Oracle物件
- 模擬Oracle行遷移和行連結Oracle
- oracle RAC 更換儲存遷移資料Oracle
- Oracle資料庫(資料泵)遷移方案(上)Oracle資料庫
- Oracle資料庫(資料泵)遷移方案(下)Oracle資料庫
- Oracle 19c adg全庫遷移資料Oracle
- 1.0 ORACLE到MYSQL資料遷移方式選型OracleMySql
- Oracle 行遷移 & 行連結的檢測與消除Oracle
- Oracle/雲MySQL/MsSQL“大遷移”真相及最優方案OracleMySql
- Oracle官方推薦的資料遷移方式評估Oracle
- 【BUILD_ORACLE】使用Oracle資料泵線上不停機克隆/遷移PDBUIOracle
- 從 Oracle 到 TiDB,全鏈路資料遷移平臺核心能力和杭州銀行遷移實踐OracleTiDB
- c盤滿了檔案怎麼遷移 軟體怎麼從c盤移到d盤
- LightDB/Postgres 使用ora2pg遷移Oracle到LightDB/PostgresOracle
- 棧遷移
- 遷移公告