oracle_rac_asm磁盘扩容

最新推荐文章于 2024-04-03 15:11:19 发布

运维林先生

最新推荐文章于 2024-04-03 15:11:19 发布

阅读量1k

点赞数

文章标签： oracle 数据库 dba

本文链接：https://blog.csdn.net/m0_46213479/article/details/128637795

版权

1.查看存储空间

select (select name from v$database) db_name,name diskgroup_name,total_mb,free_mb,round(free_mb/total_mb*100,1) FREE_Uti_PCT from v$asm_diskgroup order by 4;

在这里插入图片描述

2.查看新增硬盘

[root@rac1 ~]# fdisk -l | grep " /dev/sd[a-i]"

3.使用udev配置Asm磁盘

[root@rac1 ~]#fdisk /dev/sdm

rac1和rac2两端都需要修改/etc/udev/rules.d/99-oracle-asmdevices.rules文件

[root@rac1 ~]# vi /etc/udev/rules.d/99-oracle-asmdevices.rules
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="360003ff44dc75adc99ce03b511761d49", SYMLINK+="asm-diskl", OWNER="grid", GROUP="asmadmin", MODE="0660"
[root@rac1 ~]# /sbin/udevadm trigger --type=devices --action=change
[root@rac2 ~]# /sbin/udevadm trigger --type=devices --action=change

查看宿主和组用户，这里必须要先创建用户和组之后才会显示正确

[root@rac1 ~]# ls -l /dev/sd?1
brw-rw---- 1 root disk     8,   1 11月 13 22:42 /dev/sda1
brw-rw---- 1 grid asmadmin 8, 193 11月 13 22:42 /dev/sdm1

添加一个测试用的磁盘组
在这里插入图片描述
查看磁盘组

SQL> select name,state,type,total_mb,free_mb from v$asm_diskgroup;
NAME			       STATE	   TYPE     TOTAL_MB	FREE_MB
------------------------------ ----------- ------ ---------- ----------
DATA			       CONNECTED   EXTERN      61424	  54024
MGMT			       MOUNTED	   EXTERN      30708	   5196
OCR			       MOUNTED	   NORMAL      15348	  14432
TEST			       CONNECTED   EXTERN      15356	  15012

查看当前数据库名称

SQL> show con_name

查看表空间

SQL> select file_name from dba_data_files;

创建用户C##text01

SQL> create user C##text01 identified by oracle;

给用户授权

SQL> grant dba to c##text01;

确认哪个是pdb

SQL> show pdbs;   
    CON_ID CON_NAME			  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
	 2 PDB$SEED			  READ ONLY  NO
	 3 PDB				  MOUNTED      //pdb未打卡

SQL> alter pluggable database PDB open;  //打开PDB
Pluggable database altered.

确认是否打开PDB

SQL> show pdbs;  //确认是否打开PDB
    CON_ID CON_NAME			  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
	 2 PDB$SEED			  READ ONLY  NO
	 3 PDB				  READ WRITE NO

切换pdb

SQL> alter session set container=PDB;

在pdb里面创建表空间

SQL>  create tablespace TEST02   
  2  datafile '+TEST'
  3  size 200m
  4   autoextend on
  5   next 50m maxsize unlimited
  6   extent management local;
Tablespace created.

将表空间分配给用户

SQL> alter user C##text01 default tablespace test02;

切换cdb

SQL> alter session set container=CDB$ROOT;

Windows连接oracle数据库

C:\Users\admin>sqlplus c##text01/oracle@//192.168.0.212:1521/orcdb
C:\Users\admin>sqlplus c##text01/oracle@//192.168.0.212:1521/pdb

4.添加asm硬盘

[root@rac1 ~]# su - grid
[grid@rac1 ~]$ sqlplus / as sysdba

查看刚才创建的硬盘

SQL> set lines 200 pages 50000
col name for a25
col path for a55
select group_number,disk_number,name,path,total_mb/1024 total_G,mode_status,repair_timer from v$asm_disk order by group_number,disk_number;
SQL> SQL> SQL> 
GROUP_NUMBER DISK_NUMBER NAME			   PATH 						      TOTAL_G MODE_ST REPAIR_TIMER
------------ ----------- ------------------------- ------------------------------------------------------- ---------- ------- ------------
	   0	       0			   /dev/sde1							    0 ONLINE		 0
	   0	       1			   /dev/sdg1							    0 ONLINE		 0
	   0	       2			   /dev/sdh1							    0 ONLINE		 0
	   0	       3			   /dev/sdd1							    0 ONLINE		 0
	   0	       4			   /dev/sdb1							    0 ONLINE		 0
	   0	       5			   /dev/sdf1							    0 ONLINE		 0
	   0	       6			   /dev/sdc1							    0 ONLINE		 0
	   0	       7			   /dev/sdi1							    0 ONLINE		 0
	   1	       0 DATA1			   AFD:DATA1						   14.9960938 ONLINE		 0
	   1	       1 DATA2			   AFD:DATA2						   14.9960938 ONLINE		 0
	   1	       2 DATA_0002		   /dev/sdj1						   14.9960938 ONLINE		 0
	   1	       3 DATA_0003		   /dev/sdk1						   14.9960938 ONLINE		 0
	   2	       0 MGMT1			   AFD:MGMT1						   9.99609375 ONLINE		 0
	   2	       1 MGMT2			   AFD:MGMT2						   9.99609375 ONLINE		 0
	   2	       2 MGMT3			   AFD:MGMT3						   9.99609375 ONLINE		 0
	   3	       0 OCR1			   AFD:OCR1						   4.99609375 ONLINE		 0
	   3	       1 OCR2			   AFD:OCR2						   4.99609375 ONLINE		 0
	   3	       2 OCR3			   AFD:OCR3						   4.99609375 ONLINE		 0

18 rows selected.

将查询到的硬盘添加到DATA

SQL>  alter diskgroup DATA add disk '/dev/sdm1' ;
Diskgroup altered.

5.查看添加进去的磁盘是否成功

--asm.sql
column name format a20
column free_mb format 999,999,999
select name,to_char(sysdate,'YYYY-MM-DD HH24:MI') SYSTEM_DATETIME from v$database;
select (select name from v$database) db_name,name diskgroup_name,total_mb,free_mb,round(free_mb/total_mb*100,1) FREE_Uti_PCT from v$asm_diskgroup order by 4;