TA的每日心情 | 开心 2023-8-9 11:05 |
---|
|
- SQL> alter diskgroup ocr offline disk ocr1;
- alter diskgroup ocr offline disk ocr1
- *
- ERROR at line 1:
- ORA-15032: not all alterations performed
- ORA-15283: ASM operation requires compatible.rdbms of 11.1.0.0.0 or higher
复制代码 查询版本
- SQL> select name,value from v$asm_attribute where name like '%compa%';
- NAME VALUE
- ------------------------------ ------------------------------
- compatible.asm 19.0.0.0.0
- compatible.rdbms 10.1.0.0.0
- compatible.advm 19.0.0.0.0
复制代码 或者
- [grid@zy2 trace]$ asmcmd lsattr -G ocr -l
- Name Value
- access_control.enabled FALSE
- access_control.umask 066
- appliance._partnering_type GENERIC
- ate_conversion_done true
- au_size 4194304
- cell.smart_scan_capable FALSE
- cell.sparse_dg allnonsparse
- compatible.advm 19.0.0.0.0
- compatible.asm 19.0.0.0.0
- compatible.rdbms 11.2.0.0.0
- content.check FALSE
- content.type data
- content_hardcheck.enabled FALSE
- disk_repair_time 12.0h
- failgroup_repair_time 24.0h
- idp.boundary auto
- idp.type dynamic
- logical_sector_size 512
- maxblkdump_content.check 3
- maxdump_content.check 32
- maxerr_content.check 1048576
- phys_meta_replicated true
- preferred_read.enabled FALSE
- scrub_async_limit 1
- scrub_metadata.enabled TRUE
- sector_size 512
- thin_provisioned FALSE
- vam_migration_done true
复制代码
修改属性
- SQL> alter diskgroup ocr set attribute 'compatible.rdbms'='11.2.0.0.0';
- Diskgroup altered.
复制代码 或者
- [grid@zy2 trace]$ asmcmd setattr -G ocr compatible.rdbms 11.2.0.0.0
复制代码
offline disk
- SQL> alter diskgroup ocr offline disk ocr1;
- Diskgroup altered.
- GROUP_NUMBER DISK_NUMBER STATE NAME LABEL PATH MOUNT_S
- ------------ ----------- -------- ------------------------------ ------------------------------- ---------------------------------------- -------
- 0 0 NORMAL OCR1 AFD:OCR1 CLOSED
- 0 1 NORMAL DATA11 AFD:DATA11 CLOSED
- 2 0 NORMAL OCR1 MISSING
- 2 1 NORMAL OCR2 OCR2 AFD:OCR2 CACHED
- 2 2 NORMAL OCR3 OCR3 AFD:OCR3 CACHED
复制代码 或者
- [grid@zy2 trace]$ asmcmd offline -G ocr -D ocr1
- Diskgroup altered.
复制代码
online disk
- SQL> alter diskgroup ocr online disk ocr1;
- Diskgroup altered.
- set lines 180
- col path for a60
- select GROUP_NUMBER,DISK_NUMBER,STATE,NAME,LABEL,PATH,MOUNT_STATUS from v$asm_disk;
- GROUP_NUMBER DISK_NUMBER STATE NAME LABEL PATH MOUNT_S
- ------------ ----------- -------- ------------------------------ ------------------------------- ---------------------------------------- -------
- 0 0 NORMAL DATA11 AFD:DATA11 CLOSED
- 2 0 NORMAL OCR1 OCR1 AFD:OCR1 CACHED
- 2 1 NORMAL OCR2 OCR2 AFD:OCR2 CACHED
- 2 2 NORMAL OCR3 OCR3 AFD:OCR3 CACHED
复制代码 或者
- [grid@zy2 trace]$ asmcmd online -G ocr -D ocr1
- Diskgroup altered.
复制代码- SELECT GROUP_NUMBER, DISK_NUMBER, MOUNT_STATUS, HEADER_STATUS, MODE_STATUS, STATE, OS_MB, TOTAL_MB, FREE_MB, NAME, FAILGROUP, PATH FROM V$ASM_DISK ORDER BY GROUP_NUMBER, FAILGROUP, DISK_NUMBER;
- GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST STATE OS_MB TOTAL_MB FREE_MB NAME FAILGROUP PATH
- ------------ ----------- ------- ------------ ------- -------- ---------- ---------- ---------- ------------------------------ ------------------------------ --------------------
- 0 0 CLOSED MEMBER ONLINE NORMAL 5120 0 0 AFD:OCR1
- 0 1 CLOSED MEMBER ONLINE NORMAL 20480 0 0 AFD:DATA11
- 2 0 MISSING UNKNOWN OFFLINE FORCING 0 5120 4896 _DROPPED_0000_OCR OCR1
- 2 1 CACHED MEMBER ONLINE NORMAL 5120 5120 4736 OCR2 OCR2 AFD:OCR2
- 2 2 CACHED MEMBER ONLINE NORMAL 5120 5120 4736 OCR3 OCR3 AFD:OCR3
复制代码
|
|