asm添加和删除磁盘

最新推荐文章于 2024-05-29 10:47:33 发布
最新推荐文章于 2024-05-29 10:47:33 发布
阅读量157 收藏
点赞数
文章标签： 数据库 awk
OS：solaris
oracle: 10G R2和11G R2

11G添加删除磁盘
##磁盘变更属组和权限
-bash-3.2# bash format.sh | awk -F. '{if(($1>=1)&&($1<=15)) print $0}' | awk '{print "chown grid:asmadmin /dev/rdsk/"$2"s6"}'
chown grid:asmadmin /dev/rdsk/c9t50060E8012612D00d0s6
chown grid:asmadmin /dev/rdsk/c9t50060E8012612D00d1s6
chown grid:asmadmin /dev/rdsk/c9t50060E8012612D00d2s6
chown grid:asmadmin /dev/rdsk/c9t50060E8012612D00d3s6
chown grid:asmadmin /dev/rdsk/c9t50060E8012612D00d4s6
chown grid:asmadmin /dev/rdsk/c9t50060E8012612D00d5s6
chown grid:asmadmin /dev/rdsk/c9t50060E8012612D00d6s6
chown grid:asmadmin /dev/rdsk/c9t50060E8012612D00d7s6
chown grid:asmadmin /dev/rdsk/c9t50060E8012612D00d8s6
chown grid:asmadmin /dev/rdsk/c9t50060E8012612D00d9s6
chown grid:asmadmin /dev/rdsk/c9t50060E8012612D00d10s6
chown grid:asmadmin /dev/rdsk/c9t50060E8012612D00d11s6
chown grid:asmadmin /dev/rdsk/c9t50060E8012612D00d12s6
chown grid:asmadmin /dev/rdsk/c9t50060E8012612D00d13s6
chown grid:asmadmin /dev/rdsk/c9t50060E8012612D00d14s6
-bash-3.2# bash format.sh | awk -F. '{if(($1>=1)&&($1<=15)) print $0}' | awk '{print "chmod 660 /dev/rdsk/"$2"s6"}'
chmod 660 /dev/rdsk/c9t50060E8012612D00d0s6
chmod 660 /dev/rdsk/c9t50060E8012612D00d1s6
chmod 660 /dev/rdsk/c9t50060E8012612D00d2s6
chmod 660 /dev/rdsk/c9t50060E8012612D00d3s6
chmod 660 /dev/rdsk/c9t50060E8012612D00d4s6
chmod 660 /dev/rdsk/c9t50060E8012612D00d5s6
chmod 660 /dev/rdsk/c9t50060E8012612D00d6s6
chmod 660 /dev/rdsk/c9t50060E8012612D00d7s6
chmod 660 /dev/rdsk/c9t50060E8012612D00d8s6
chmod 660 /dev/rdsk/c9t50060E8012612D00d9s6
chmod 660 /dev/rdsk/c9t50060E8012612D00d10s6
chmod 660 /dev/rdsk/c9t50060E8012612D00d11s6
chmod 660 /dev/rdsk/c9t50060E8012612D00d12s6
chmod 660 /dev/rdsk/c9t50060E8012612D00d13s6
chmod 660 /dev/rdsk/c9t50060E8012612D00d14s6
##查看当前的磁盘组和磁盘信息
SQL> set linesize 300
SQL> set pages 1000
SQL> col name for a15
SQL> col path for a60
SQL> select adg.name,adg.TOTAL_MB group_TOTAL_MB,adg.free_mb group_free_mb,ad.path,ad.TOTAL_MB disk_totle_mb,ad.free_mb disk_free_mb from v$asm_diskgroup adg,v$asm_disk ad where adg.GROUP_NUMBER=ad.GROUP_NUMBER;
NAME            GROUP_TOTAL_MB GROUP_FREE_MB PATH                                                         DISK_TOTLE_MB DISK_FREE_MB
--------------- -------------- ------------- ------------------------------------------------------------ ------------- ------------
ARCH_DG01              1095562        923066 /dev/rdsk/c9t50060E80103511A0d10s6                                  547781       461538
ARCH_DG01              1095562        923066 /dev/rdsk/c9t50060E80103511A0d0s6                                   547781       461528
DATA_DG01              6573372       2940641 /dev/rdsk/c9t50060E80103511A0d14s6                                  547781       245046
DATA_DG01              6573372       2940641 /dev/rdsk/c9t50060E80103511A0d1s6                                   547781       245050
DATA_DG01              6573372       2940641 /dev/rdsk/c9t50060E80103511A0d2s6                                   547781       245050
DATA_DG01              6573372       2940641 /dev/rdsk/c9t50060E80103511A0d3s6                                   547781       245048
DATA_DG01              6573372       2940641 /dev/rdsk/c9t50060E80103511A0d4s6                                   547781       245061
DATA_DG01              6573372       2940641 /dev/rdsk/c9t50060E80103511A0d5s6                                   547781       245066
DATA_DG01              6573372       2940641 /dev/rdsk/c9t50060E80103511A0d6s6                                   547781       245047
DATA_DG01              6573372       2940641 /dev/rdsk/c9t50060E80103511A0d7s6                                   547781       245051
DATA_DG01              6573372       2940641 /dev/rdsk/c9t50060E80103511A0d8s6                                   547781       245066
DATA_DG01              6573372       2940641 /dev/rdsk/c9t50060E80103511A0d12s6                                  547781       245055
DATA_DG01              6573372       2940641 /dev/rdsk/c9t50060E80103511A0d11s6                                  547781       245053
DATA_DG01              6573372       2940641 /dev/rdsk/c9t50060E80103511A0d13s6                                  547781       245048
FLASH_DG01              547781        547725 /dev/rdsk/c9t50060E80103511A0d9s6                                   547781       547725

15 rows selected.

##形成添加磁盘语句
-bash-3.2# bash format.sh | awk -F. '{if(($1>=1)&&($1<=15)) print $0}' | awk '{print "alter diskgroup  add disk ""'\''""/dev/rdsk/"$2"s6""'\''"";"}'
alter diskgroup  add disk '/dev/rdsk/c9t50060E8012612D00d0s6';
alter diskgroup  add disk '/dev/rdsk/c9t50060E8012612D00d1s6';
alter diskgroup  add disk '/dev/rdsk/c9t50060E8012612D00d2s6';
alter diskgroup  add disk '/dev/rdsk/c9t50060E8012612D00d3s6';
alter diskgroup  add disk '/dev/rdsk/c9t50060E8012612D00d4s6';
alter diskgroup  add disk '/dev/rdsk/c9t50060E8012612D00d5s6';
alter diskgroup  add disk '/dev/rdsk/c9t50060E8012612D00d6s6';
alter diskgroup  add disk '/dev/rdsk/c9t50060E8012612D00d7s6';
alter diskgroup  add disk '/dev/rdsk/c9t50060E8012612D00d8s6';
alter diskgroup  add disk '/dev/rdsk/c9t50060E8012612D00d9s6';
alter diskgroup  add disk '/dev/rdsk/c9t50060E8012612D00d10s6';
alter diskgroup  add disk '/dev/rdsk/c9t50060E8012612D00d11s6';
alter diskgroup  add disk '/dev/rdsk/c9t50060E8012612D00d12s6';
alter diskgroup  add disk '/dev/rdsk/c9t50060E8012612D00d13s6';
alter diskgroup  add disk '/dev/rdsk/c9t50060E8012612D00d14s6';
##添加磁盘
oracle@cdb0cmsmcc01:~ $> su - grid
oracle@cdb0cmsmcc01:~ $> sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Mon Jan 22 10:25:08 2018
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
SQL> conn / as sysasm

SQL>  alter diskgroup ARCH_DG01 add disk '/dev/rdsk/c9t50060E8012612D00d0s6','/dev/rdsk/c9t50060E8012612D00d1s6';

SQL>  alter diskgroup DATA_DG01 add disk
'/dev/rdsk/c9t50060E8012612D00d2s6','/dev/rdsk/c9t50060E8012612D00d3s6',
'/dev/rdsk/c9t50060E8012612D00d4s6','/dev/rdsk/c9t50060E8012612D00d5s6',
'/dev/rdsk/c9t50060E8012612D00d6s6','/dev/rdsk/c9t50060E8012612D00d7s6',
'/dev/rdsk/c9t50060E8012612D00d8s6','/dev/rdsk/c9t50060E8012612D00d9s6',
'/dev/rdsk/c9t50060E8012612D00d10s6','/dev/rdsk/c9t50060E8012612D00d11s6',
'/dev/rdsk/c9t50060E8012612D00d12s6','/dev/rdsk/c9t50060E8012612D00d13s6';
SQL>  alter diskgroup FLASH_DG01 add disk '/dev/rdsk/c9t50060E8012612D00d14s6';
##删除磁盘
oracle@cdb0cmsmcc01:~ $> su - grid
oracle@cdb0cmsmcc01:~ $> sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Mon Jan 22 10:25:08 2018
Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn / as sysasm
SQL> alter diskgroup ARCH_DG01 drop disk 'ARCH_DG01_0000','ARCH_DG01_0001';
Diskgroup altered.

SQL> select * from v$asm_operation;

GROUP_NUMBER OPERA STAT      POWER     ACTUAL      SOFAR   EST_WORK   EST_RATE EST_MINUTES ERROR_CODE
------------ ----- ---- ---------- ---------- ---------- ---------- ---------- ----------- --------------------------------------------
           1 REBAL RUN           1          1      19757      52986       6331           5
        
SQL> alter diskgroup DATA_DG01 drop disk
  2     'DATA_DG01_0000',
  3     'DATA_DG01_0001',
  4     'DATA_DG01_0002',
  5     'DATA_DG01_0003',
  6     'DATA_DG01_0004',
  7     'DATA_DG01_0005',
  8     'DATA_DG01_0006',
  9     'DATA_DG01_0007',
10     'DATA_DG01_0008',
11     'DATA_DG01_0009',
12     'DATA_DG01_0010',
13     'DATA_DG01_0011' rebalance power 6;
    
SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA STAT      POWER     ACTUAL      SOFAR   EST_WORK   EST_RATE EST_MINUTES ERROR_CODE
------------ ----- ---- ---------- ---------- ---------- ---------- ---------- ----------- --------------------------------------------
           2 REBAL RUN           6          6       1483    1790755       3137         504
           

10G添加删除磁盘
##变更属组和权限
-bash-3.2# bash format.sh | awk -F. '{if(($1>=3)&&($1<=26)) print $0}' | awk '{print "chown grid:asmadmin /dev/rdsk/"$2"s6"}'
chown oracle:oinstall /dev/rdsk/c12t50060E8012612D00d0s6
chown oracle:oinstall /dev/rdsk/c12t50060E8012612D00d1s6
chown oracle:oinstall /dev/rdsk/c12t50060E8012612D00d2s6
chown oracle:oinstall /dev/rdsk/c12t50060E8012612D00d3s6
chown oracle:oinstall /dev/rdsk/c12t50060E8012612D00d4s6
chown oracle:oinstall /dev/rdsk/c12t50060E8012612D00d5s6
chown oracle:oinstall /dev/rdsk/c12t50060E8012612D00d6s6
chown oracle:oinstall /dev/rdsk/c12t50060E8012612D00d7s6
chown oracle:oinstall /dev/rdsk/c12t50060E8012612D00d8s6
chown oracle:oinstall /dev/rdsk/c12t50060E8012612D00d9s6
chown oracle:oinstall /dev/rdsk/c12t50060E8012612D00d10s6
chown oracle:oinstall /dev/rdsk/c12t50060E8012612D00d11s6
chown oracle:oinstall /dev/rdsk/c12t50060E8012612D00d12s6
chown oracle:oinstall /dev/rdsk/c12t50060E8012612D00d13s6
chown oracle:oinstall /dev/rdsk/c12t50060E8012612D00d14s6
chown oracle:oinstall /dev/rdsk/c12t50060E8012612D00d15s6
chown oracle:oinstall /dev/rdsk/c12t50060E8012612D00d16s6
chown oracle:oinstall /dev/rdsk/c12t50060E8012612D00d17s6
chown oracle:oinstall /dev/rdsk/c12t50060E8012612D00d18s6
chown oracle:oinstall /dev/rdsk/c12t50060E8012612D00d19s6
chown oracle:oinstall /dev/rdsk/c12t50060E8012612D00d20s6
chown oracle:oinstall /dev/rdsk/c12t50060E8012612D00d21s6
chown oracle:oinstall /dev/rdsk/c12t50060E8012612D00d22s6
chown oracle:oinstall /dev/rdsk/c12t50060E8012612D00d23s6

-bash-3.2# bash format.sh | awk -F. '{if(($1>=3)&&($1<=26)) print $0}' | awk '{print "chmod 640 /dev/rdsk/"$2"s6"}'
chmod 640 /dev/rdsk/c12t50060E8012612D00d0s6
chmod 640 /dev/rdsk/c12t50060E8012612D00d1s6
chmod 640 /dev/rdsk/c12t50060E8012612D00d2s6
chmod 640 /dev/rdsk/c12t50060E8012612D00d3s6
chmod 640 /dev/rdsk/c12t50060E8012612D00d4s6
chmod 640 /dev/rdsk/c12t50060E8012612D00d5s6
chmod 640 /dev/rdsk/c12t50060E8012612D00d6s6
chmod 640 /dev/rdsk/c12t50060E8012612D00d7s6
chmod 640 /dev/rdsk/c12t50060E8012612D00d8s6
chmod 640 /dev/rdsk/c12t50060E8012612D00d9s6
chmod 640 /dev/rdsk/c12t50060E8012612D00d10s6
chmod 640 /dev/rdsk/c12t50060E8012612D00d11s6
chmod 640 /dev/rdsk/c12t50060E8012612D00d12s6
chmod 640 /dev/rdsk/c12t50060E8012612D00d13s6
chmod 640 /dev/rdsk/c12t50060E8012612D00d14s6
chmod 640 /dev/rdsk/c12t50060E8012612D00d15s6
chmod 640 /dev/rdsk/c12t50060E8012612D00d16s6
chmod 640 /dev/rdsk/c12t50060E8012612D00d17s6
chmod 640 /dev/rdsk/c12t50060E8012612D00d18s6
chmod 640 /dev/rdsk/c12t50060E8012612D00d19s6
chmod 640 /dev/rdsk/c12t50060E8012612D00d20s6
chmod 640 /dev/rdsk/c12t50060E8012612D00d21s6
chmod 640 /dev/rdsk/c12t50060E8012612D00d22s6
chmod 640 /dev/rdsk/c12t50060E8012612D00d23s6
##查看当前磁盘组和磁盘信息
set linesize 300
set pages 1000
col name for a15
col path for a60
select adg.name,adg.TOTAL_MB group_TOTAL_MB,adg.free_mb group_free_mb,ad.path,ad.TOTAL_MB disk_totle_mb,ad.free_mb disk_free_mb from v$asm_diskgroup adg,v$asm_disk ad where adg.GROUP_NUMBER=ad.GROUP_NUMBER;
NAME            GROUP_TOTAL_MB GROUP_FREE_MB PATH                                                         DISK_TOTLE_MB DISK_FREE_MB
--------------- -------------- ------------- ------------------------------------------------------------ ------------- ------------
ARCH_DG01              2191124       1863341 /dev/rdsk/c12t50060E80103511A0d21s6                                 547781            0
ARCH_DG01              2191124       1863341 /dev/rdsk/c12t50060E80103511A0d19s6                                 547781            0
ARCH_DG01              2191124       1863341 /dev/rdsk/c12t50060E80103511A0d20s6                                 547781            0
ARCH_DG01              2191124       1863341 /dev/rdsk/c12t50060E80103511A0d18s6                                 547781            0
DATA_DG01              4930029        946612 /dev/rdsk/c12t50060E80103511A0d1s6                                  547781            0
DATA_DG01              4930029        946612 /dev/rdsk/c12t50060E80103511A0d6s6                                  547781            0
DATA_DG01              4930029        946612 /dev/rdsk/c12t50060E80103511A0d7s6                                  547781            0
DATA_DG01              4930029        946612 /dev/rdsk/c12t50060E80103511A0d22s6                                 547781            0
DATA_DG01              4930029        946612 /dev/rdsk/c12t50060E80103511A0d2s6                                  547781            0
DATA_DG01              4930029        946612 /dev/rdsk/c12t50060E80103511A0d3s6                                  547781            0
DATA_DG01              4930029        946612 /dev/rdsk/c12t50060E80103511A0d4s6                                  547781            0
DATA_DG01              4930029        946612 /dev/rdsk/c12t50060E80103511A0d5s6                                  547781            0
DATA_DG01              4930029        946612 /dev/rdsk/c12t50060E80103511A0d0s6                                  547781            0
DATA_DG02              4930029        952264 /dev/rdsk/c12t50060E80103511A0d23s6                                 547781            0
DATA_DG02              4930029        952264 /dev/rdsk/c12t50060E80103511A0d9s6                                  547781            0
DATA_DG02              4930029        952264 /dev/rdsk/c12t50060E80103511A0d8s6                                  547781            0
DATA_DG02              4930029        952264 /dev/rdsk/c12t50060E80103511A0d15s6                                 547781            0
DATA_DG02              4930029        952264 /dev/rdsk/c12t50060E80103511A0d14s6                                 547781            0
DATA_DG02              4930029        952264 /dev/rdsk/c12t50060E80103511A0d13s6                                 547781            0
DATA_DG02              4930029        952264 /dev/rdsk/c12t50060E80103511A0d12s6                                 547781            0
DATA_DG02              4930029        952264 /dev/rdsk/c12t50060E80103511A0d11s6                                 547781            0
DATA_DG02              4930029        952264 /dev/rdsk/c12t50060E80103511A0d10s6                                 547781            0
FLASH_DG01             1095562        273752 /dev/rdsk/c12t50060E80103511A0d16s6                                 547781            0
FLASH_DG01             1095562        273752 /dev/rdsk/c12t50060E80103511A0d17s6                                 547781            0

##添加磁盘
oracle@ofs0accmcc01:~ $> export ORACLE_SID=+ASM
oracle@ofs0accmcc01:~ $> sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Jan 22 10:59:38 2018
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
SQL> conn / as sysdba
Connected.
SQL> show parameter name
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert                 string
db_name                              string
db_unique_name                       string      +ASM
global_names                         boolean     FALSE
instance_name                        string      +ASM
lock_name_space                      string
log_file_name_convert                string
service_names

SQL>  alter diskgroup ARCH_DG01 add disk '/dev/rdsk/c12t50060E8012612D00d0s6','/dev/rdsk/c12t50060E8012612D00d1s6','/dev/rdsk/c12t50060E8012612D00d2s6','/dev/rdsk/c12t50060E8012612D00d3s6';

SQL> alter diskgroup DATA_DG01 add disk
'/dev/rdsk/c12t50060E8012612D00d4s6','/dev/rdsk/c12t50060E8012612D00d5s6',
'/dev/rdsk/c12t50060E8012612D00d6s6','/dev/rdsk/c12t50060E8012612D00d7s6',
'/dev/rdsk/c12t50060E8012612D00d8s6','/dev/rdsk/c12t50060E8012612D00d9s6',
'/dev/rdsk/c12t50060E8012612D00d10s6','/dev/rdsk/c12t50060E8012612D00d11s6',
'/dev/rdsk/c12t50060E8012612D00d12s6';

SQL>  alter diskgroup DATA_DG02 add disk
'/dev/rdsk/c12t50060E8012612D00d13s6','/dev/rdsk/c12t50060E8012612D00d14s6',
'/dev/rdsk/c12t50060E8012612D00d15s6','/dev/rdsk/c12t50060E8012612D00d16s6',
'/dev/rdsk/c12t50060E8012612D00d17s6','/dev/rdsk/c12t50060E8012612D00d18s6',
'/dev/rdsk/c12t50060E8012612D00d19s6','/dev/rdsk/c12t50060E8012612D00d20s6',
'/dev/rdsk/c12t50060E8012612D00d21s6';

SQL>  alter diskgroup FLASH_DG01 add disk '/dev/rdsk/c12t50060E8012612D00d22s6','/dev/rdsk/c12t50060E8012612D00d23s6’;

##删除磁盘
oracle@ofs0accmcc01:~/admin/BEIMCCE/bdump $> export ORACLE_SID=+ASM
oracle@ofs0accmcc01:~ $> sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Jan 22 10:59:38 2018
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
SQL> conn / as sysdba
Connected.
SQL> show parameter name
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert                 string
db_name                              string
db_unique_name                       string      +ASM
global_names                         boolean     FALSE
instance_name                        string      +ASM
lock_name_space                      string
log_file_name_convert                string
service_names                        string      +ASM

SQL> alter diskgroup ARCH_DG01 drop disk
  2     'ARCH_DG01_0000',
  3     'ARCH_DG01_0001',
  4     'ARCH_DG01_0002',
  5     'ARCH_DG01_0003' rebalance power 6;

Diskgroup altered.

SQL> set linesize 300
SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA STAT      POWER     ACTUAL      SOFAR   EST_WORK   EST_RATE EST_MINUTES
------------ ----- ---- ---------- ---------- ---------- ---------- ---------- -----------
           1 REBAL RUN           6          6       3471     127806       4633          26

SQL> alter diskgroup DATA_DG01 drop disk
  2     'DATA_DG01_0000',
  3     'DATA_DG01_0001',
  4     'DATA_DG01_0002',
  5     'DATA_DG01_0003',
  6     'DATA_DG01_0004',
  7     'DATA_DG01_0005',
  8     'DATA_DG01_0006',
  9     'DATA_DG01_0007',
10     'DATA_DG01_0008' rebalance power 6;

Diskgroup altered.

SQL> alter diskgroup DATA_DG02 drop disk
  2     'DATA_DG02_0000',
  3     'DATA_DG02_0001',
  4     'DATA_DG02_0002',
  5     'DATA_DG02_0003',
  6     'DATA_DG02_0004',
  7     'DATA_DG02_0005',
  8     'DATA_DG02_0006',
  9     'DATA_DG02_0007',
10     'DATA_DG02_0008' rebalance power 6;

Diskgroup altered.

SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA STAT      POWER     ACTUAL      SOFAR   EST_WORK   EST_RATE EST_MINUTES
------------ ----- ---- ---------- ---------- ---------- ---------- ---------- -----------
           2 REBAL RUN           6          6     144286    1995242       4154         445
           3 REBAL WAIT          6          0          0          0          0         445

SQL> alter diskgroup FLASH_DG01 drop disk 'FLASH_DG01_0000','FLASH_DG01_0001' rebalance power 6;

Diskgroup altered.

SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA STAT      POWER     ACTUAL      SOFAR   EST_WORK   EST_RATE EST_MINUTES
------------ ----- ---- ---------- ---------- ---------- ---------- ---------- -----------
           4 REBAL RUN           6          6        271     405529       2539         159



来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28572479/viewspace-2150416/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28572479/viewspace-2150416/

cpc84938
关注
oracle asm 加盘,ASM添加磁盘最佳实践
weixin_30039755的博客
04-03 2079
当FRA区或者DATA区磁盘空间不够的时候，我们需要为ASM添加磁盘。添加磁盘的high level的步骤为：1. SA分配共享磁盘，要求在多个节点都能看到这些磁盘。2. 将共享磁盘分区，将分区后的磁盘，创建成asmdisk3. 将asmdisk加入到asm的diskgroup中下面是具体的实施步骤：(一). SA分配共享磁盘，要求在多个节点都能看到这些磁盘。1. 在SA未加磁盘之前，记下/dev...
linux磁盘分区绑定asm磁盘,使用UDEV绑定ASM多路径磁盘
weixin_35275162的博客
05-04 1580
OS版本：RHEL6.41) 找出目标磁盘的分区别名# dmsetup ls |grep datadata01 (253:9)data04 (253:4)data03 (253:3)data02 (253:2)# dmsetup ls |grep crscrs03 (253:8)crs02 (253:7)crs01 (253:5)2) 编写/etc/udev/rules.d/1...
asm添加删除磁盘
weixin_33692284的博客
11-12 124
一、 ASM_POWER_LIMIT 参数 　这个参数 ASM_POWER_LIMIT 参数控制 ASM 后台进程 ARBx 的数量。ARBx 进程用来进行 ASM 磁盘数据重新分布打散。ASM_POWER_LIMIT 取值 从 0 到 11(据说从 10gR2 开始可以设置为 0 ). 当新添加磁盘或者删除磁盘后，ASM 会启动 ARBx 进行 IO...
从ASM磁盘组中删除磁盘
weixin_33895695的博客
01-16 218
ASM的一大卖点是联机地重新配置存储的能力。ASM的一个有用特性是使用它从一个磁盘组中的一组磁盘移植到另一个，或从一个存储队列移植到另一个。 　　这基本上是可以实现的，因为ASM在一个磁盘组中的所有磁盘上均匀地分布数据，假定你具有足够的空间，你可以删除一个磁盘组中的磁盘，而ASM将无缝地将这些数据移植到这个磁盘组中的已有磁盘上。 SQL> select group...
asm删除磁盘
cishu8308的博客
12-24 157
11r2 asm和db 分离，如果想用asm 需要先安装grid。 安装grid时推荐添加 grid用户。 #su - grid $ sqlplus "/as sysdba" SQL*Plus: Release 11.2...
ASM磁盘组删除磁盘
weixin_33877885的博客
08-05 487
ASM磁盘组删除磁盘 [oracle@dbserver1 ~]$ su - gridsqlplus / as sysasmConnected.SQL> alter diskgroup data drop disk data_0001;Diskgroup altered.SQL> select disk_number, state, name, total_mb, free_mb fr...
ASM磁盘组删除DISK操作
08-23 155
ASM接触了很长时间，从磁盘组中删除磁盘的操作还是第一次。 没想到这么简单的操作，由于不熟悉还碰到了两个小问题。 [oracle@dbserver1 ~]$ sqlplus / as sysdba SQL*Plus...
Oracle ASM 磁盘组扩容方案
01-26
当现有的ASM磁盘组无法满足存储需求时，可以通过添加新的磁盘来扩展ASM磁盘组的空间。本文档提供了一个标准的ASM磁盘组扩容方案，该方案已经在多个生产环境中得到验证和应用。 #### 目标环境 本方案适用于Oracle ...
asm添加硬盘
04-21
### asm添加硬盘 #### 关键知识点： 1. **ASM (Automatic Storage Management) 概念** - ASM 是 Oracle 提供的一种存储管理技术，用于管理数据库的文件系统。 - 它能够自动平衡磁盘组中的数据分布，提高数据访问...
ASM操作加盘.7z
07-03
5. **ASM操作的步骤**：可能包括创建ASM实例、启动ASM实例、添加磁盘到ASM实例、创建磁盘组、分配磁盘到磁盘组、监控磁盘组性能、删除磁盘、调整磁盘组属性等。每个步骤都有其特定的语法和注意事项。 6. **ASM磁盘...
ASM如何删除/增加磁盘
hijk139的专栏
01-05 1万+
ASM如何删除/增加磁盘 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 ASM磁盘创建、删除
最新发布
の正在缓存99%
05-29 571
【代码】Oracle ASM磁盘创建、删除。
hpux oracle rac添加、删除asm磁盘
old boy的博客
07-28 2133
oracle rac数据库的磁盘组空间不足，需要从存储上划分磁盘进行磁盘组的扩容，主要分为以下几步。 环境： 内容 版本 数据库 oracle 11.2.0.4 rac 操作系统 hpux 11.31 一、存储划分磁盘，并同时映射到rac的两个节点 ...
ASM磁盘组及磁盘 添加、删除
热门推荐
我的博客
12-23 1万+
一、相关概念 1.ASM 磁盘组 ASM存储管理除了ASM实例之外，最大的组成部分就是ASM磁盘组。一个ASM磁盘组由过多个ASM磁盘组成 一个磁盘组内可以存放多个数据文件，一个数据文件仅仅只能位于一个磁盘组内，不能跨磁盘组 多个数据库可以共享相同的或多个磁盘组 磁盘组的冗余类型可以分为三类：标准冗余，高度冗余，外部冗余 对于已创建的磁盘组，不能够更改其冗余级别，如要更改，需要删除该磁
Oracle RAC asm磁盘管理--添加--删除--扩容
freelove_2005的专栏
03-09 1159
SQL> select group_number,mount_status,name,path from v$asm_disk; GROUP_NUMBER MOUNT_STATUS NAME PATH ------------ -------------- ------------------------------------------------------------ ---.
oracle alter disk,【日常管理】Asm Diskgroup增加磁盘add disk
weixin_35815766的博客
04-10 1474
show parameter poweralter system set asm_power_limit=0;alter diskgroup MACLEAN add FAILGROUP FailgroupA disk '/asmdisks/asmdiskA28';alter diskgroup MACLEAN add FAILGROUP FailgroupA disk '/asmdisks/asm...
linux的chmod命令权限说明
wanglinliujia的博客
09-23 726
-rw------- (600) 只有拥有者有读写权限。 -rw-r--r-- (644) 只有拥有者有读写权限；而属组用户和其他用户只有读权限。 -rwx------ (700) 只有拥有者有读、写、执行权限。 -rwxr-xr-x (755) 拥有者有读、写、执行权限；而属组用户和其他用户只有读、执行权限。 -rwx--x--x (711) 拥有者有读、写、执行权限；而属组用户和其他用户只有执行权限。 -rw-rw-rw- (666) 所有用户都有文件读、写权限。-r
2020-11-03
weixin_47622231的博客
11-03 214
权限简介 可选项： -c, --changes like verbose but report only when a change is made (若该档案权限确实已经更改，才显示其更改动作) -f, --silent, --quiet suppress most error messages （若该档案权限无法被更改也不要显示错误讯息） -v, --verbose output a diagnostic for every file processed（显示权限变更的详细资料） --no-preser
【Linux】基本权限&特殊权限
weixin_49383196的博客
03-17 1395
一个要努力学习的菜鸟的技术进阶之路4······
Oracle12c ASM磁盘组管理详解
3. **删除磁盘组**：`DROP DISKGROUP`用于永久性地删除一个磁盘组，但在此之前需确保磁盘组未被使用且已卸载。 4. **挂载磁盘组**：`MOUNT DISKGROUP`将磁盘组挂载到ASM实例，使其可供使用。 5. **卸载磁盘组**：`...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值