1,没有超过repair_time可以执行执行online相关操作。 alter diskgroup lodg online disk 'XXXX_000X'; 2,如果offline 超时,从asm 磁盘组删除 删除日志: alter diskgroup REPAIR drop disk xxx_000x force /ASM SERVER/ # 重新添加被offline磁盘: alter diskgroup data add disk '/dev/xxx/' force;...
select * from v$asm_operation; 五、割接后检查 检查所有盘的状态,确保无异常 Select count(*),mount_status,mode_status,inst_id from gv$asm_disk; Select * from gv$asm_diskgroup where offline_disks>0; 检查ASM日志,数据库日志,确保无异常
ALTER DISKGROUP D3 OFFLINE DISK D3_0001; 将D3磁盘组F2故障组的所有磁盘OFFLINE,在repair time后会drop掉 ALTER DISKGROUP D3 OFFLINE DISKS IN FAILGROUP F2; 将D3磁盘组的D3_0001磁盘ONLINE ALTER DISKGROUP D3 ONLINE DISK D3_0001; 我们可以在命令后查看ASM的活动情况 SELECT GROUP_NUMBER, OPERATION, ...
某银行ODS系统的一体机(数据库版本为19.8)上,由于某个存储节点掉了4块盘,磁盘处于offline状态,在超过了“_asm_disk_repair_time”时间内没有online,被磁盘组自动drop force,之后在drop disk rebalance未完成的情况下,将4块盘重新加入了磁盘组,由于担心rebalance影响ODS跑批业务,所以在跑批阶段中断rebalance操作,在空闲...
selectgroup_number,name,state,type,total_mb,free_mb,usable_file_mb,offline_disksfromv$asm_diskgroup; 2.看磁盘的 setline200 setpagesize200 col name format a20 col path format a30 selectname,mount_Status,state,disk_number,path,total_mb,free_mb,group_numberfromv$asm_disk;...
Oracle-视图V$ASM_DISK 官方文档对于V$ASM_DISK的描述是:V$ASM_DISKdisplays one row for every disk discovered by the Oracle Automatic Storage Management (Oracle ASM) instance, including disks that are not part of any disk group.翻译过来是:V$ASM_DISK为Oracle ASM实例发现的每个磁盘显示...
Oracle ASM操作管理 查看ASM磁盘情况 SQL> select group_number,disk_number,mount_status,header_status,mode_status,state,failgroup,total_mb,free_mb,name,path from v$asm_disk; 查看ASM磁盘组情况 SQL> select group_number,block_size,name,allocation_unit_size,state,type,total_mb,free_mb,offline_disks...
3、创建和删除ASM磁盘 创建ASM磁盘: # /etc/init.d/oracleasm createdisk data_vol01_sdb5 /dev/sdb5 Marking disk "data_vol01_sdb5" as an ASM disk: [ OK ] # /etc/init.d/oracleasm createdisk data_vol02_sdb6 /dev/sdb6 Marking disk "data_vol02_sdb6" as an ASM disk: [ OK ] ...
该问题源于存储节点掉了4块盘,磁盘处于offline状态。在超过了“_asm_disk_repair_time”时间内没有online,被磁盘组自动drop force。在drop disk rebalance未完成的情况下,将4块盘重新加入了磁盘组。然而,在跑批阶段由于担心rebalance影响ODS跑批业务,所以在跑批阶段中断rebalance操作,在空闲时重新发起rebalance。然而,在...
1 OFFLINE OFFLINE Instance Shutdown 2 OFFLINE OFFLINE Instance Shutdown SQL> alter diskgroup data dismount; Diskgroup altered. OCR磁盘组无法卸载,CRSD进程以及CTSS进程使用OCR/VF磁盘组,如果关闭集群,那么ASM实例也会关闭,也就无法连接ASM实例执行磁盘组卸载命令,也无法执行asmcmd命令拉起图形化界面 。