给ASM磁盘组加空间！

最新推荐文章于 2021-05-03 05:19:22 发布

henrybai

最新推荐文章于 2021-05-03 05:19:22 发布

阅读量3.9k

点赞数

分类专栏： ORACLE11G 文章标签：磁盘 oracle linux disk library database

本文链接：https://blog.csdn.net/henrybai/article/details/7936872

版权

ORACLE11G 专栏收录该内容

96 篇文章 0 订阅

订阅专栏

ASM盘组空间不足。
[oracle@Linux117 ~]$ id
uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1200(dba),1300(asmdba),1400(oper)
[oracle@Linux117 ~]$ asmcmd
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 511993 6 0 6 0 N DATA/

[oracle@Linux117 ~]$ id
uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1200(dba),1300(asmdba),1400(oper)

[oracle@Linux117 ~]$ . oraenv
ORACLE_SID = [ORCL] ? +ASM
The Oracle base for ORACLE_HOME=/u01/app/11.2.0/grid is /u01/app/oracle
[oracle@Linux117 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Aug 30 10:56:33 2012

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

SQL> select status from v$instance;

STATUS
------------
STARTED
SQL> alter diskgroup DATA add disk 'ORCL:VDISK2';
alter diskgroup DATA add disk 'ORCL:VDISK2'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group

SQL> shutdown immediate;
ORA-01031: insufficient privileges

SQL> select * from v$asm_diskgroup;

           1 DATA                                   512       4096
             1048576 MOUNTED     EXTERN     511993          6           0
      511987                       0              6             0
11.2.0.0.0
10.1.0.0.0                                                   N

SQL> select path from v$asm_disk;

ORCL:VDISK2
ORCL:VDISK1
[oracle@Linux117 ~]$ su - grid
[grid@Linux117 ~]$ id
uid=1100(grid) gid=1000(oinstall) groups=1000(oinstall),1100(asmadmin),1200(dba),1300(asmdba),1301(asmoper)

SQL> conn / as sysasm
Connected.

SQL> alter diskgroup data add disk 'ORCL:VDISK2';

Diskgroup altered.

SQL>
--------------------------------------------------------------------------------
UDID
----------------------------------------------------------------
PRODUCT CREATE_DA MOUNT_DAT REPAIR_TIMER READS
-------------------------------- --------- --------- ------------ ----------
WRITES READ_ERRS WRITE_ERRS READ_TIME WRITE_TIME BYTES_READ BYTES_WRITTEN
---------- ---------- ---------- ---------- ---------- ---------- -------------
P HASH_VALUE HOT_READS HOT_WRITES HOT_BYTES_READ HOT_BYTES_WRITTEN COLD_READS
- ---------- ---------- ---------- -------------- ----------------- ----------
COLD_WRITES COLD_BYTES_READ COLD_BYTES_WRITTEN V SECTOR_SIZE FAILGRO
----------- --------------- ------------------ - ----------- -------

SQL> set head off
SQL> /

           0           0              0 3915934782 CLOSED CANDIDATE    ONLINE
NORMAL   UNKNOWN
ASM Library - Generic Linux, version 2.0.4 (KABI_V2)                 221183
         0          0           0            0
                               VDISK2
ORCL:VDISK2

0
N 512 REGULAR

1 0 16777216 3915934781 CACHED MEMBER ONLINE

NORMAL   UNKNOWN
ASM Library - Generic Linux, version 2.0.4 (KABI_V2)                 511993
    511993          6           0       511987 VDISK1
VDISK1                         VDISK1
ORCL:VDISK1

                                 16-APR-12 28-AUG-12            0     384822
    224042          0          0    875.256   1803.663 2.7934E+10    2725892096
3076181572          0          0              0                 0     381455
     134792      2.7920E+10         2360324096 N         512 REGULAR

SQL> alter diskgroup DATA add disk 'ORCL:VDISK2';
SQL> exit
[oracle@Linux117 ~]$ asmcmd
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 733176 56444 0 56444 0 N DATA/