Oracle asm lib存储扩容及测试
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了Oracle asm lib存储扩容及测试,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含8237字,纯文字阅读大概需要12分钟。
内容图文
![Oracle asm lib存储扩容及测试](/upload/InfoBanner/zyjiaocheng/523/55f0b34bdb7a45d89176ba084a2f079e.jpg)
[--primary {hot|cold}] [--secondary {hot|cold}] volume ASMCMD> volcreate -G ARCH -s 2g v01 ORA-15032: not all alterations performed ORA-15221: ASM operation requires compatible.asm of 11.2.0.0.0 or higher (DBD ERROR: OCIStmtExecute) SQL> select name,total_mb/1024 total_g,state,type,COMPATIBILITY ,DATABASE_COMPATIBILITY from v$asm_diskgroup; NAME TOTAL_G STATE TYPE COMPATIBILITY DATABASE_COMPATIBILI ---------- ---------- --------------- ------ -------------------- -------------------- ARCH 9.98828125 MOUNTED EXTERN 10.1.0.0.0 10.1.0.0.0 OCR 19.9931641 MOUNTED EXTERN 11.2.0.0.0 10.1.0.0.0 SQL>alter diskgroup ARCH set attribute ‘compatible.asm‘=‘11.2‘; SQL>alter diskgroup ARCH set attribute ‘compatible.rdbms‘=‘11.2‘; Tue May 05 12:03:00 2020 SQL> alter diskgroup ARCH set attribute ‘compatible.asm‘=‘11.2‘ NOTE: Created Used Space Directory for 2 threads NOTE: Advancing ASM compatibility to 11.2.0.0.0 for grp 1 NOTE: initiating PST update: grp = 1 Tue May 05 12:03:04 2020 GMON updating group 1 at 13 for pid 28, osid 48447 NOTE: Advancing compatible.asm on grp 1 disk ARCH_0000 NOTE: Advancing compatible.asm on grp 1 disk ARCH_0001 NOTE: PST update grp = 1 completed successfully SUCCESS: Advanced compatible.asm to 11.2.0.0.0 for grp 1 Tue May 05 12:03:04 2020 NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 1 SUCCESS: alter diskgroup ARCH set attribute ‘compatible.asm‘=‘11.2‘ Tue May 05 12:03:13 2020 NOTE: setting 11.2 start ABA for group ARCH thread 2 to 3.188 Tue May 05 12:03:36 2020 SQL> alter diskgroup ARCH set attribute ‘compatible.rdbms‘=‘11.2‘ NOTE: Advancing RDBMS compatibility to 11.2.0.0.0 for grp 1 Tue May 05 12:03:40 2020 GMON querying group 1 at 15 for pid 28, osid 48447 SUCCESS: Advanced compatible.rdbms to 11.2.0.0.0 for grp 1 SUCCESS: alter diskgroup ARCH set attribute ‘compatible.rdbms‘=‘11.2‘ SQL> select name,total_mb/1024 total_g,state,type,COMPATIBILITY ,DATABASE_COMPATIBILITY from v$asm_diskgroup; NAME TOTAL_G STATE TYPE COMPATIBILITY DATABASE_COMPATIBILI ---------- ---------- --------------- ------ -------------------- -------------------- ARCH 9.98828125 MOUNTED EXTERN 11.2.0.0.0 11.2.0.0.0 OCR 19.9931641 MOUNTED EXTERN 11.2.0.0.0 10.1.0.0.0 ASMCMD> volcreate -G ARCH -s 2g v01 SUCCESS: /* ASMCMD */alter diskgroup ARCH add volume ‘v01‘ size 2g SQL> select VOLUME_NAME,SIZE_MB,REDUNDANCY,STATE,VOLUME_DEVICE from v$asm_volume; VOLUME_NAM SIZE_MB REDUND STATE VOLUME_DEVICE ---------- ---------- ------ --------------- -------------------- V01 2048 UNPROT ENABLED /dev/asm/v01-317 SQL> host ls -lrt /dev/asm/v01-317 brwxrwx--- 1 root asmadmin 252, 162305 May 5 12:04 /dev/asm/v01-317 ASMCMD> volinfo -G ARCH v01 Diskgroup Name: ARCH Volume Name: V01 Volume Device: /dev/asm/v01-317 State: ENABLED Size (MB): 2048 Resize Unit (MB): 32 Redundancy: UNPROT Stripe Columns: 4 Stripe Width (K): 128 Usage: Mountpath: 格式化v01 [root@wsgw2 ~]# mkfs -t acfs /dev/asm/v01-317 mkfs.acfs: version = 11.2.0.4.0 mkfs.acfs: on-disk version = 39.0 mkfs.acfs: volume = /dev/asm/v01-317 mkfs.acfs: volume size = 2147483648 mkfs.acfs: Format complete. 注册acfs [grid@wsgw1 /]$ acfsutil registry -a /dev/asm/v01-317 /ogg acfsutil registry: mount point /ogg successfully added to Oracle Registry Tue May 05 12:12:01 2020 Starting background process VDBG Tue May 05 12:12:01 2020 VDBG started with pid=28, OS id=49816 NOTE: client +ASM1:asmvol registered, osid 49816, mbr 0x2 Starting background process VMB0 Tue May 05 12:12:01 2020 VMB0 started with pid=34, OS id=49819 Starting background process VBG1 Starting background process VBG2 Tue May 05 12:12:02 2020 VBG1 started with pid=36, OS id=49825 NOTE: client +ASM1:asmvol deregistered Tue May 05 12:12:03 2020 VBG2 started with pid=37, OS id=49827 NOTE: client +ASM1:asmvol registered, osid 49816, mbr 0x2 [grid@wsgw1 /]$ df -h|grep ogg /dev/asm/v01-317 2.0G 81M 2.0G 4% /ogg #mount -t acfs /dev/asm/v01-317 /ogg grid$acfsutil size 4G /ogg acfsutil size: new file system size: 4294967296 (4096MB) [root@wsgw2 ogg]# df -h|grep -v sd|grep -v tmp Filesystem Size Used Avail Use% Mounted on /dev/asm/v01-317 4.0G 149M 3.9G 4% /ogg SQL> select VOLUME_NAME,SIZE_MB,REDUNDANCY,STATE,VOLUME_DEVICE from v$asm_volume; VOLUME_NAM SIZE_MB REDUND STATE VOLUME_DEVICE ---------- ---------- ------ --------------- -------------------- V01 4096 UNPROT ENABLED /dev/asm/v01-317 ASMCMD> volinfo -G ARCH v01 Diskgroup Name: ARCH Volume Name: V01 Volume Device: /dev/asm/v01-317 State: ENABLED Size (MB): 4096 Resize Unit (MB): 32 Redundancy: UNPROT Stripe Columns: 4 Stripe Width (K): 128 Usage: ACFS Mountpath: /ogg [root@wsgw1 /]# acfsutil info fs /ogg ACFS Version: 11.2.0.4.0 flags: MountPoint,Available mount time: Tue May 5 12:12:04 2020 volumes: 1 total size: 4294967296 total free: 4139364352 primary volume: /dev/asm/v01-317 label: flags: Primary,Available,ADVM on-disk version: 39.0 allocation unit: 4096 major, minor: 252, 162305 size: 4294967296 free: 4139364352 ADVM diskgroup ARCH ADVM resize increment: 33554432 ADVM redundancy: unprotected ADVM stripe columns: 4 ADVM stripe width: 131072 number of snapshots: 0 snapshot space usage: 0 replication status: DISABLED
二、生产环境扩容
SQL> select VOLUME_NAME,SIZE_MB,REDUNDANCY,STATE,VOLUME_DEVICE from v$asm_volume;
VOLUME_NAM SIZE_MB REDUND STATE VOLUME_DEVICE
---------- ---------- ------ --------------- --------------------
V02 102400 UNPROT ENABLED /dev/asm/v02-111
ASMCMD> volinfo -G ARCH v02
Diskgroup Name: ARCH
Volume Name: V02
Volume Device: /dev/asm/v02-111
State: ENABLED
······
Usage: ACFS
Mountpath: /u01/ogg
[root@wsgw1 /]# acfsutil info fs
/u01/ogg
ACFS Version: 11.2.0.4.0
flags: MountPoint,Available
······
primary volume: /dev/asm/v02-111
······
实际上确认acfs挂载目录,以及确认存储空间足够,直接size 即可,非常方便。
本次上面有ogg进程,先stop *,stop mgr 关闭ogg进程后进行操作,扩容200g,1分钟不到。
grid$acfsutil size 300G /U01/ogg
Oracle asm lib存储扩容及测试
标签:spec update span font 文件系统 方便 arch process split
本文系统来源:https://www.cnblogs.com/lvcha001/p/12860347.html
内容总结
以上是互联网集市为您收集整理的Oracle asm lib存储扩容及测试全部内容,希望文章能够帮你解决Oracle asm lib存储扩容及测试所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。