ATTRIBUTE ‘au_size’=‘1M’,
‘compatible.asm’ = ‘11.2’,
‘compatible.rdbms’ = ‘11.2’,
‘compatible.advm’ = ‘11.2’;
创建 Data 磁盘组需要指定两个 failgroup,命令如下:
CREATE DISKGROUP DATA NORMAL REDUNDANCY
FAILGROUP aa DISK ‘/dev/asm-aadata1’
FAILGROUP bb DISK ‘/dev/asm-bbdata1’
ATTRIBUTE ‘au_size’=‘1M’,
‘compatible.asm’ = ‘11.2’,
‘compatible.rdbms’ = ‘11.2’,
‘compatible.advm’ = ‘11.2’;
如果上线后有添加磁盘的需求,Data 磁盘组添加磁盘命令如下:
alter diskgroup DATA add
FAILGROUP aa disk ‘/dev/asm-aadata2’
FAILGROUP bb disk ‘/dev/asm-bbdata2’
rebalance power 111;
双活的 ocr 磁盘组创建好之后需要将 OCR 和 votedisk 设备迁移至 OCR 磁盘中,命令如下:
$ORACLE_HOME/bin/ocrconfig -add +OCR
$ORACLE_HOME/bin/ocrconfig -delete +TMPOCR
$ORACLE_HOME/bin/crsctl replace votedisk +OCR
$ORACLE_HOME/bin/crsctl query css votedisk
$ORACLE_HOME/bin/ocrcheck
将 ASM 实例的参数文件迁移到 asmspfile 至 OCR 磁盘组
sqlplus / as sysasm
SQL> create pfile=‘/tmp/pfile.ora’ from spfile;
SQL> create spfile=‘+OCR’ from pfile=‘/tmp/pfile.ora’;
ASM 实例的参数需要做如下设置(优先读本地磁盘组):
alter system set asm_preferred_read_failure_groups=‘DATA.aa’ sid=‘+ASM1’ SCOPE=SPFILE;
alter system set asm_preferred_read_failure_groups=‘DATA.bb’ sid=‘+ASM2’ SCOPE=SPFILE;
3Oracle 存储双活性能测试
Oracle 双活存储安装完毕之后需要重点