Shulou(Shulou.com)06/01 Report--

Operate on ASM instance in SQLPLUS

1. View the status of ASM disk groups

SELECT GROUP_NUMBER, NAME, TYPE, STATE, TOTAL_MB, FREE_MB, OFFLINE_DISKS FROM V$ASM_DISKGROUP

GROUP_NUMBER NAME TYPE STATE TOTAL_MB FREE_MB OFFLINE_DISKS

1 DG1 NORMAL MOUNTED 102365 102208

2. View ASM disk information

SELECT GROUP_NUMBER, DISK_NUMBER, LABEL, STATE, FAILGROUP, NAME, PATH, TOTAL_MB, FREE_MB FROM V$ASM_DISK

GROUP_NUMBER DISK_NUMBER LABEL STATE FAILGROUP NAME

--

PATH TOTAL_MB FREE_MB

1 4 NORMAL DG1_0004 DG1_0004

/ dev/oracleasm/disks/D5 20473 20443

1 3 NORMAL DG1_0003 DG1_0003

/ dev/oracleasm/disks/D4 20473 20443

1 2 NORMAL DG1_0002 DG1_0002

/ dev/oracleasm/disks/D3 20473 20442

GROUP_NUMBER DISK_NUMBER LABEL STATE FAILGROUP NAME

--

PATH TOTAL_MB FREE_MB

1 1 NORMAL DG1_0001 DG1_0001

/ dev/oracleasm/disks/D2 20473 20439

1 0 NORMAL DG1_0000 DG1_0000

/ dev/oracleasm/disks/D1 20473 20441

3. Add disk groups:

CREATE DISKGROUP dgd NORMAL REDUNDANCY

FAILGROUP failgroup1 DISK

'/ dev/raw/raw1' NAME diskA1 SIZE 120g FORCE

'/ dev/raw/raw2'

'/ dev/raw/raw3'

FAILGROUP failgroup2 DISK

'/ dev/raw/raw4'

'/ dev/raw/raw5'

'/ dev/raw/raw6'

4. Add fail group:

ALTER DISKGROUP dg1 ADD FAILGROUP fail3 DISK'/ dev/raw/raw22' name disk5 REBALANCE POWER 11

5. Add ASM disk:

ALTER DISKGROUP dg1 add failgroup fail1 DISK'/ dev/raw/raw19' name disk3

6. Delete ASM disk:

ALTER DISKGROUP dg1 DROP DISK disk4

7. To unmount the disk group, close the rdbms database instance installed on ASM first.

ALTER DISKGROUP dg2 DISMOUNT

8. Detect a disk group or disk:

ALTER DISKGROUP dg1 CHECK ALL

ALTER DISKGROUP DG1 CHECK DISK VOL1

7. Control the speed of equalization fault-tolerant group data:

ALTER DISKGROUP dg2 REBALANCE POWER 11

Balance speed control parameters:

Asm_power_limit = 1x 11

8. Check the database balance speed:

SELECT GROUP_NUMBER, OPERATION, STATE, EST_WORK, SOFAR, EST_RATE, EST_MINUTES FROM V$ASM_OPERATION

9. Delete the disk group:

DROP DISKGROUP GROUP1 INCLUDING CONTENTS

10. Cancel deletion:

ALTER DISKGROUP group1 UNDROP DISKS

11. Add a directory:

ALTER DISKGROUP DG1 ADD DIRECTORY'+ DG1/ad'

CREATE TABLESPACE T1 DATAFILE'+ DG1/ad/t1.dbf' SIZE 100m AUOEXTEND ON

12. Rename directories: tablespaces are not affected in any way

ALTER DISKGROUP DG1 RENAME DIRECTORY'+ DG1/ad' to'+ DG1/add'

13. Delete the directory:

ALTER DISKGROUP DG1 DROP DIRECTORY'+ DG1/ad/demo' FORCE

14. Create aliases:

ALTER DISKGROUP DG1 ADD ALIAS'+ DG1/ad/spfilead.ora' FOR'+ DG1/ad/parameterfile/spfile.269.777212438'

15. Rename aliases:

Alter diskgroup dg1 rename alias'+ DG1/ASMDB/spfile.ora' to'+ DG1/ASMDB/spfileasmdb.ora'

16. Delete aliases: deleting aliases files will not be deleted

DROP DISKGROUP DG1 DROP ALIAS'+ DG1/ASMDB/spfileasmdb.ora'

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.