增加磁盘

1.进入asm环境
[Oracle@rac1 ~]$ export ORACLE_SID=+ASM1
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jan 5 14:22:46 2011
Copyright （c） 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options 2.查看当前的状态
SQL> select group_number, name, total_mb, free_mb, total_mb-free_mb used_mb from v$asm_disk_stat;
GROUP_NUMBER NAME                             TOTAL_MB    FREE_MB    USED_MB
------------ ------------------------------ ---------- ---------- ----------
           0                                      1019          0       1019
           0                                       101          0        101
           0                                       101          0        101
           1 DATA_0001                            1019        565        454
           1 DATA_0000                            3067       2129        938SQL> select name, total_mb, free_mb from v$asm_disk_stat;
NAME                             TOTAL_MB    FREE_MB
------------------------------ ---------- ----------
                                     1019          0
                                      101          0
                                      101          0
DATA_0001                            1019        565
DATA_0000                            3067       2129SQL> select * from v$asm_operation;
no rows selected3.开始删除磁盘DATA_0001
SQL> alter diskgroup data drop disk DATA_0001;
Diskgroup altered.4.磁盘做rebalance操作
SQL> set linesize 200;
SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA STAT      POWER     ACTUAL      SOFAR   EST_WORK   EST_RATE EST_MINUTES
------------ ----- ---- ---------- ---------- ---------- ---------- ---------- -----------
           1 REBAL RUN           1          1        167        456        414           0SQL> select name, total_mb, free_mb from v$asm_disk_stat;
NAME                             TOTAL_MB    FREE_MB
------------------------------ ---------- ----------
                                     1019          0
                                      101          0
                                      101          0
DATA_0001                            1019        732
DATA_0000                            3067       1962SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA STAT      POWER     ACTUAL      SOFAR   EST_WORK   EST_RATE EST_MINUTES
------------ ----- ---- ---------- ---------- ---------- ---------- ---------- -----------
           1 REBAL RUN           1          1        381        454        411           05.继续等待磁盘已经删除
SQL> select * from v$asm_operation;
no rows selectedSQL> select * from v$asm_operation;
no rows selectedSQL> select name, total_mb, free_mb from v$asm_disk_stat;
NAME                             TOTAL_MB    FREE_MB
------------------------------ ---------- ----------
                                     1019          0
                                      101          0
                                      101          0
DATA_0000                            3067       1677SQL> select path,group_number, disk_number,mount_status,header_status,mode_status,state from v$asm_disk;
PATH                                     GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST STATE
---------------------------------------- ------------ ----------- ------- ------------ ------- --------
/dev/raw/raw5                                       0           0 CLOSED FORMER       ONLINE NORMAL
/dev/raw/raw3                                       0           1 CLOSED CANDIDATE    ONLINE NORMAL
/dev/raw/raw2                                       0           2 CLOSED FOREIGN      ONLINE NORMAL
/dev/raw/raw1                                       0           4 CLOSED FOREIGN      ONLINE NORMAL
/dev/raw/raw4                                       1           0 CACHED MEMBER       ONLINE NORMAL6.增加一个asm磁盘
SQL> ALTER DISKGROUP DATA ADD DISK "/dev/raw/raw5";
Diskgroup altered.SQL> select path,group_number, disk_number,mount_status,header_status,mode_status,state from v$asm_disk;
PATH                                     GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST STATE
---------------------------------------- ------------ ----------- ------- ------------ ------- --------
/dev/raw/raw3                                       0           1 CLOSED CANDIDATE    ONLINE NORMAL
/dev/raw/raw2                                       0           2 CLOSED FOREIGN      ONLINE NORMAL
/dev/raw/raw1                                       0           4 CLOSED FOREIGN      ONLINE NORMAL
/dev/raw/raw5                                       1           1 CACHED MEMBER       ONLINE NORMAL
/dev/raw/raw4                                       1           0 CACHED MEMBER       ONLINE NORMALSQL> select * from v$asm_operation;
GROUP_NUMBER OPERA STAT      POWER     ACTUAL      SOFAR   EST_WORK   EST_RATE EST_MINUTES
------------ ----- ---- ---------- ---------- ---------- ---------- ---------- -----------
           1 REBAL RUN           1          1        181        350        501           0SQL> select name, total_mb, free_mb from v$asm_disk_stat;
NAME                             TOTAL_MB    FREE_MB
------------------------------ ---------- ----------
                                     1019          0
                                      101          0
                                      101          0
DATA_0001                            1019        671
DATA_0000                            3067       2023SQL> select * from v$asm_operation;
no rows selected.Oracle DML流程Oracle 10g & ASM Install For Redhat Enterprise Linux AS 4相关资讯 Oracle基础教程

Oracle块编程返回结果集详解（11/10/2013 10:45:58）
Oracle基础教程之设置系统全局区（08/22/2013 14:24:00）
Oracle基础教程知识点总结（06/18/2013 07:43:32）

Oracle基础教程之tkprof程序详解（10/22/2013 11:49:50）
Oracle基础教程之sqlplus汉字乱码（07/18/2013 16:30:00）
Oracle 管理之 Linux 网络基础（02/16/2013 18:37:35）

本文评论查看全部评论（0）