SQL> create diskgroup data_nor normal redundancy failgroup controller1 disk ‘/dev/oracleasm/disk/DISK10’ controller2 disk ‘/dev/oracleasm/disk/DISK11’ failgroup2 controller1 disk ‘/dev/oracleasm/disk/DISK12’ controller2 disk ‘/dev/oracleasm/disk/DISK13’;
SQL> alter diskgroup data_nor add disk ‘/dev/oracleasm/disks/DISK14’;
SQL> alter diskgroup data_nor add disk ‘/dev/oracleasm/disks/DISK15’;
SQL> alter diskgroup data_nor drop disk DATA_NOR_0000;(DATA_NOR_0000是v$asm_disk_atat中的DISK10对应的name)
SQL> alter diskgroup data_nor drop disk DATA_NOR_0002
(DATA_NOR_0002是v$asm_disk_atat中的DISK12对应的name)
SQL> create tablespace tbs1 encrytion using ‘AES256’;
SQL> alter database datafile ‘+DATA/orcl/datafile/tbs1’ autoextend on;
SQL> CREATE USER test2;
SQL> alter user deftault tablespace tsp1;
SQL> craete role ROLE1;
SQL> grant ROLE1 to test1
SQL> grant connect, resource, dba to ROLE1;