ASM磁盘测试

[root@11gasm ~]# su - grid
[grid@11gasm ~]$ sqlplus / as sysasm


SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 22 13:47:06 2015


Copyright (c) 1982, 2013, Oracle.  All rights reserved.




Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Automatic Storage Management option


SQL> CREATE DISKGROUP data1 EXTERNAL REDUNDANCY DISK '/dev/raw/raw3';


Diskgroup created.


SQL> alter DISKGROUP data1 add disk '/dev/raw/raw4';


Diskgroup altered.


SQL> select name, total_mb, free_mb from v$asm_diskgroup;


NAME                             TOTAL_MB    FREE_MB
------------------------------ ---------- ----------
ARCH                                 5585       5049
DATA                                 9773       4295
DATA1                                1466       1414


SQL> select name,total_mb,free_mb from v$asm_disk;


NAME                             TOTAL_MB    FREE_MB
------------------------------ ---------- ----------
DATA_0000                            9773       4295
ARCH_0000                            5585       5049
DATA1_0000                            486        468
DATA1_0001                            980        946




[root@11gasm ~]# su - oracle
[oracle@11gasm ~]$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 22 13:52:43 2015


Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to an idle instance.


SQL> startup
ORACLE instance started.


Total System Global Area 1068937216 bytes
Fixed Size                  2260088 bytes
Variable Size             331350920 bytes
Database Buffers          729808896 bytes
Redo Buffers                5517312 bytes
Database mounted.
Database opened.
SQL> create tablespace test datafile '+data1';


Tablespace created.


SQL> create user dennis identified by dennis default tablespace test temporary tablespace TEMP;


User created.


SQL> grant dba to dennis;


Grant succeeded.


SQL> conn dennis/dennis
Connected.
SQL> create table test insert into select * fr