Oracle 11.2.0.3管理ASM的方法是什么
本篇内容主要讲解“Oracle 11.2.0.3管理ASM的方法是什么”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“Oracle 11.2.0.3管理ASM的方法是什么”吧!
一：查看ASM磁盘及磁盘组状态
SQL> select * from v$asm_disk;
SQL> select * from v$asm_diskgroup;
二：创建external 冗余磁盘组,添加，删除磁盘，删除磁盘的时候需要指定磁盘的name而不是path
SQL> create diskgroup FRA external redundancy disk '/dev/asm-disk4';
Diskgroup created.
SQL> alter diskgroup fra add disk '/dev/asm-disk5' rebalance power 10;
Diskgroup altered.
SQL> select name,failgroup,path from v$asm_disk;
NAME FAILGROUP PATH
-------------------- -------------------- --------------------
DATA_0000 DATA_0000 /dev/asm-disk1
DATA_0001 DATA_0001 /dev/asm-disk3
DATA_0002 DATA_0002 /dev/asm-disk2
FRA_0000 FRA_0000 /dev/asm-disk4
FRA_0001 FRA_0001 /dev/asm-disk5
/dev/asm-disk6
/dev/asm-disk7
SQL> alter diskgroup fra drop disk '/dev/asm-disk4' rebalance power 10;
alter diskgroup fra drop disk '/dev/asm-disk4' rebalance power 10
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15054: disk "/DEV/ASM-DISK4" does not exist in diskgroup "FRA"
SQL> alter diskgroup fra drop disk 'FRA_0000' rebalance power 10;
Diskgroup altered.
三：创建normal redundancy磁盘组
SQL> conn /as sysasm
Connected.
SQL> create diskgroup fra normal redundancy
failgroup fg1 disk '/dev/asm-disk4','/dev/asm-disk5'
failgroup fg2 disk '/dev/asm-disk6','/dev/asm-disk7'
attribute 'compatible.rdbms'='11.2','compatible.asm'='11.2';
Diskgroup created.
SQL> select name, total_mb,free_mb,required_mirror_free_mb,usable_file_mb from v$asm_diskgroup;
NAME TOTAL_MB FREE_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB
---------- ---------- ---------- ----------------------- --------------
DATA 61440 54873 0 18291
FRA 81920 81592 20480 30556
四：failgroup测试；FAILGROUP是用于将磁盘分组，以保证丢失任何一组FAILGROUP磁盘，数据还是完整的,多用于多阵列，通过ASM来完成冗余的环境！
1：查看FRA磁盘组中failgroup信息及磁盘状态
SQL> select name,path,failgroup,mount_status from v$asm_disk where group_number=2;
NAME PATH FAILGROUP MOUNT_STATUS
-------------------- -------------------- ---------- ---------------------
FRA_0003 /dev/asm-disk7 FG2 CACHED
FRA_0002 /dev/asm-disk6 FG2 CACHED
FRA_0000 /dev/asm-disk4 FG1 CACHED
FRA_0001 /dev/asm-disk5 FG1 CACHED
2：在rdbms实例中创建表空间，建表并插入数据，收集表统计信息
SQL> create tablespace test01 datafile '+FRA';
Tablespace created.
ASMCMD> pwd
+fra/db/datafile
ASMCMD> ls
TEST01.256.800622493
SQL> create table t1 tablespace test01 as select * from dba_objects;
Table created.
SQL> exec dbms_stats.gather_table_stats('SYS','T1');
PL/SQL procedure successfully completed.
SQL> select count(*) from t1;
COUNT(*)
----------
74501
3：删除udev相关规则，重启数据库实例和ASM实例，验证数据是否存在
SQL> conn /as sysasm
Connected.
SQL> alter diskgroup fra mount;
alter diskgroup fra mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15042: ASM disk "1" is missing from group number "2"
ORA-15042: ASM disk "0" is missing from group number "2"
SQL> alter diskgroup fra mount force;
Diskgroup altered.
SQL> select name,path,failgroup,mount_status from v$asm_disk;
NAME PATH FAILGROUP MOUNT_STATUS
---------- -------------------- -------------------- ---------------------
FRA_0000 FG1 MISSING
FRA_0001 FG1 MISSING
FRA_0002 /dev/asm-disk6 FG2 CACHED
FRA_0003 /dev/asm-disk7 FG2 CACHED
DATA_0000 /dev/asm-disk1 DATA_0000 CACHED
DATA_0002 /dev/asm-disk2 DATA_0002 CACHED
DATA_0001 /dev/asm-disk3 DATA_0001 CACHED
7 rows selected.
SQL> conn /as sysdba
Connected.
SQL> select count(*) from t1;
COUNT(*)
----------
74501
五：删除ASM磁盘组，默认磁盘故障条件下，经过12960秒即3.6个小时后自动删除；删除磁盘组之前需要保证无数据存放在磁盘组上且无到该磁盘组的active连接
[grid@localhost ~]$ tail -f /u01/app/grid/diag/asm/+asm/+ASM/trace/alert_+ASM.log
ORA-15062: ASM disk is globally closed
Thu Nov 29 12:00:53 2012
WARNING: Disk 0 (FRA_0000) in group 2 will be dropped in: (12960) secs on ASM inst 1
WARNING: Disk 1 (FRA_0001) in group 2 will be dropped in: (12960) secs on ASM inst 1
Thu Nov 29 12:00:58 2012
asm实例：
SQL> select path,name,repair_timer from v$asm_disk where group_number=2;
PATH NAME REPAIR_TIMER
-------------------- ---------- ------------
FRA_0000 12960
FRA_0001 12960
/dev/asm-disk6 FRA_0002 0
/dev/asm-disk7 FRA_0003 0
SQL> alter diskgroup fra online disk 'FRA_0000';
Diskgroup altered.
SQL> alter diskgroup fra online disk 'FRA_0001';
Diskgroup altered.
SQL> select name,path,failgroup,mount_status from v$asm_disk;
NAME PATH FAILGROUP MOUNT_STATUS
---------- -------------------- -------------------- ---------------------
FRA_0002 /dev/asm-disk6 FG2 CACHED
FRA_0003 /dev/asm-disk7 FG2 CACHED
DATA_0000 /dev/asm-disk1 DATA_0000 CACHED
DATA_0002 /dev/asm-disk2 DATA_0002 CACHED
DATA_0001 /dev/asm-disk3 DATA_0001 CACHED
FRA_0001 /dev/asm-disk5 FG1 CACHED
FRA_0000 /dev/asm-disk4 FG1 CACHED
SQL> drop diskgroup fra;
drop diskgroup fra
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15053: diskgroup "FRA" contains existing files
rdbms实例：
SQL> drop tablespace test01 including contents;
Tablespace dropped.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
asm实例：
SQL> drop diskgroup fra including contents;
Diskgroup dropped.
rdbms实例：
SQL> startup
ORACLE instance started.
Total System Global Area 313860096 bytes
Fixed Size 1344652 bytes
Variable Size 192940916 bytes
Database Buffers 113246208 bytes
Redo Buffers 6328320 bytes
Database mounted.
Database opened.
到此，相信大家对“Oracle 11.2.0.3管理ASM的方法是什么”有了更深的了解，不妨来实际操作一番吧！这里是亿速云网站，更多相关内容可以进入相关频道进行查询，关注我们，继续学习！
免责声明：
① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的，并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据，供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。
② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
![[mysql]mysql8修改root密码](https://static.528045.com/imgs/43.jpg?imageMogr2/format/webp/blur/1x0/quality/35)
