Oracle 11.2.0.3 manages ASM instances

Currently, ASM instances are widely used in both rac and single-instance database environments. This article mainly introduces the management of ASM instances in Oracle 11.2.0.3, including the following:
1: view the status of the ASM disk and disk group
2: Create an external redundant disk group, add or delete a disk.
3: Create a normal redundancy disk group
4: failgroup test under normal redundancy
5. Delete the ASM disk group.
6. Meanings of initialization parameters of other asm instances

I. view the status of the ASM disk and disk group
SQL> select * from v $ asm_disk;
SQL> select * from v $ asm_diskgroup;

Ii. Create an external redundant disk group, add or delete a disk, and specify the disk name instead of path when deleting the disk.

1. SQL> create diskgroup FRA external redundancy disk '/dev/asm-disk4 ';
2. Diskgroup created.
4. SQL> alter diskgroup fra add disk'/dev/asm-disk5 'rebalance power 10;
5. Diskgroup altered.
7. SQL> select name, failgroup, path from v $ asm_disk;
9. NAME FAILGROUP PATH
10. ------------------------------------------------------------
11. DATA_0000 DATA_0000/dev/asm-disk1
12. DATA_0001 DATA_0001/dev/asm-disk3
13. DATA_0002 DATA_0002/dev/asm-disk2
14. FRA_0000 FRA_0000/dev/asm-disk4
15. FRA_0001 FRA_0001/dev/asm-disk5
16. /Dev/asm-disk6
17. /Dev/asm-disk7
19. SQL> alter diskgroup fra drop disk '/dev/asm-disk4' rebalance power 10;
20. Alter diskgroup fra drop disk '/dev/asm-disk4 'rebalance power 10
21. *
22. ERROR at line 1:
23. ORA-15032: not all alterations saved med
24. ORA-15054: disk "/DEV/ASM-DISK4" does not exist in diskgroup "FRA"
26. SQL> alter diskgroup fra drop disk 'fra _ 0000 'rebalance power 10;
27. Diskgroup altered.

3. Create a normal redundancy disk group

1. SQL> conn/as sysasm
2. Connected.
3. SQL> create diskgroup fra normal redundancy
4. Failgroup fg1 disk '/dev/asm-disk4', '/dev/asm-disk5'
5. Failgroup fg2 disk '/dev/asm-disk6', '/dev/asm-disk7'
6. Attribute 'compatible. rdbms '= '11. 2', 'compatible. asm' = '11. 2 ';
7. Diskgroup created.
9. SQL> select name, total_mb, free_mb, required_pai_free_mb, usable_file_mb from v $ asm_diskgroup;
11. NAME TOTAL_MB FREE_MB required_assist_free_mb USABLE_FILE_MB
12. -------------------------------------------------------------------
13. DATA 61440 54873 0 18291
14. FRA 81920 81592 20480 30556

4. failgroup test; FAILGROUP is used to group disks to ensure the loss of any group of FAILGROUP disks. The data is still complete. It is mostly used for multiple arrays and redundant environments through ASM!
1: View failgroup information and disk status in the FRA disk group

1. SQL> select name, path, failgroup, mount_status from v $ asm_disk where group_number = 2;
3. Name path failgroup MOUNT_STATUS
4. -----------------------------------------------------------------------
5. FRA_0003/dev/asm-disk7 FG2 CACHED
6. FRA_0002/dev/asm-disk6 FG2 CACHED
7. FRA_0000/dev/asm-disk4 FG1 CACHED
8. FRA_0001/dev/asm-disk5 FG1 CACHED

2: Create a tablespace in an rdbms instance, create a table, insert data, and collect table statistics.

1. SQL> create tablespace test01 datafile '+ fra ';
2. Tablespace created.
4. ASMCMD> pwd
5. + Fra/db/datafile
6. ASMCMD> ls
7. TEST01.256.800622493
9. SQL> create table t1 tablespace test01 as select * from dba_objects;
10. Table created.
12. SQL> exec dbms_stats.gather_table_stats ('sys ', 'T1 ');
13. PL/SQL procedure successfully completed.
15. SQL> select count (*) from t1;
17. COUNT (*)
18. ----------
19. 74501

3. Delete udev rules, restart database instances and ASM instances, and verify whether data exists.

1. SQL> conn/as sysasm
2. Connected.
3. SQL> alter diskgroup fra mount;
4. Alter diskgroup fra mount
5. *
6. ERROR at line 1:
7. ORA-15032: not all alterations saved med
8. ORA-15040: diskgroup is incomplete.
9. ORA-15042: ASM disk "1" is missing from group number "2"
10. ORA-15042: ASM disk & quot; 0 & quot; is missing from group number & quot; 2 & quot"
12. SQL> alter diskgroup fra mount force;
13. Diskgroup altered.
15. SQL> select name, path, failgroup, mount_status from v $ asm_disk;
17. Name path failgroup MOUNT_STATUS
18. -----------------------------------------------------------------------
19. FRA_0000 FG1 MISSING
20. FRA_0001 FG1 MISSING
21. FRA_0002/dev/asm-disk6 FG2 CACHED
22. FRA_0003/dev/asm-disk7 FG2 CACHED
23. DATA_0000/dev/asm-disk1 DATA_0000 CACHED
24. DATA_0002/dev/asm-disk2 DATA_0002 CACHED
25. DATA_0001/dev/asm-disk3 DATA_0001 CACHED
26. 7 rows selected.
28. SQL> conn/as sysdba
29. Connected.
30. SQL> select count (*) from t1;
32. COUNT (*)
33. ----------
34. 74501

1 2 Next Page