Oracle 19C RAC ASM扩容

最新推荐文章于 2024-06-11 10:22:27 发布
最新推荐文章于 2024-06-11 10:22:27 发布
阅读量585 收藏
点赞数
文章标签： 数据库 linux mysql shell python
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/hbhe0316/article/details/122701066
版权
这篇博客内容涉及检查Oracle RAC集群中数据库、ASM及Grid日志的错误信息，确认节点状态正常，并通过ASM磁盘组和磁盘检查确保数据完整性和可用性。此外，还记录了UDEV规则以管理和跟踪磁盘设备，并详细展示了如何在节点上添加新磁盘到ASM磁盘组，包括调整系统设置以允许不同大小的磁盘加入，并使用ASM命令监控磁盘变化。
摘要由CSDN通过智能技术生成

1.检查各个节点database、asm及grid日志是否有错误信息https://www.cndba.cn/hbhe0316/article/96101https://www.cndba.cn/hbhe0316/article/96101

https://www.cndba.cn/hbhe0316/article/96101 
SQL> set linesize 200
SQL> set pagesize 200
SQL> select instance_name,host_name,startup_time,status from gv$instance;

INSTANCE_NAME                    HOST_NAME                                                                                                                        STARTUP_TIME
-------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------
STATUS
------------------------
cxmtdb1                          rac01                                                                                                                            2021:12:2621:59:50
OPEN

cxmtdb2                          rac02                                                                                                                            2021:12:2621:59:52
OPEN
SQL> select instance_name,host_name,startup_time,status from gv$instance;

INSTANCE_NAME                    HOST_NAME                                                                                                                        STARTUP_TIME
-------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------
STATUS
------------------------
cxmtdb1                          rac01                                                                                                                            2021:12:2621:59:50
OPEN

cxmtdb2                          rac02                                                                                                                            2021:12:2621:59:52
OPEN

检查node01和node02节点数据库、ASM及grid日志是否有错误信息
2.ASM磁盘组及磁盘检查https://www.cndba.cn/hbhe0316/article/96101

SQL> select * from gv$asm_client order by 1,2;

   INST_ID GROUP_NUMBER INSTANCE_NAME                                                                                                                    DB_NAME
---------- ------------ -------------------------------------------------------------------------------------------------------------------------------- ----------------
CLUSTER_NAME                                                   STATUS
-------------------------------------------------------------- ------------------------
SOFTWARE_VERSION
------------------------------------------------------------------------------------------------------------------------
COMPATIBLE_VERSION                                                                                                           CON_ID
------------------------------------------------------------------------------------------------------------------------ ----------
         1            0 +ASM1                                                                                                                            cxmtdb
rac                                                            CONNECTED
19.0.0.0.0
19.0.0.0.0                                                                                                                        0

         1            1 +ASM1                                                                                                                            cxmtdb
rac                                                            CONNECTED
19.0.0.0.0
19.0.0.0.0                                                                                                                        0

         2            0 +ASM2                                                                                                                            cxmtdb
rac                                                            CONNECTED
19.0.0.0.0
19.0.0.0.0                                                                                                                        0

         2            1 +ASM2                                                                                                                            cxmtdb
rac                                                            CONNECTED
19.0.0.0.0
19.0.0.0.0                                                                                                                        0


SQL> select group_number,name,state,type,total_mb,free_mb,usable_file_mb,allocation_unit_size/1024/1024 unit_mb from v$asm_diskgroup order by 1;

GROUP_NUMBER NAME                                                         STATE                  TYPE           TOTAL_MB    FREE_MB USABLE_FILE_MB    UNIT_MB
------------ ------------------------------------------------------------ ---------------------- ------------ ---------- ---------- -------------- ----------
           1 DATA                                                         CONNECTED              NORMAL           102400      88096          44048          4
           2 MGMT                                                         MOUNTED                EXTERN            40960      39444          39444          4
           3 OCR                                                          MOUNTED                NORMAL            15360      14444           4662          4
SQL> select group_number,name,path,mount_status,state,redundancy,total_mb,free_mb,failgroup,create_date from v$asm_disk order by 1,2;

GROUP_NUMBER NAME
------------ ------------------------------------------------------------
PATH
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
MOUNT_STATUS   STATE            REDUNDANCY       TOTAL_MB    FREE_MB FAILGROUP                                                    CREATE_DATE
-------------- ---------------- -------------- ---------- ---------- ------------------------------------------------------------ ------------------
           0
/dev/asmdiskc
IGNORED        NORMAL           UNKNOWN                 0          0                                                              2021:09:2010:33:40

           0
/dev/asmdiske
IGNORED        NORMAL           UNKNOWN                 0          0                                                              2021:09:1921:59:38

           0
/dev/asmdiskf
IGNORED        NORMAL           UNKNOWN                 0          0                                                              2021:09:1921:59:38

           0
/dev/asmdiskb
IGNORED        NORMAL           UNKNOWN                 0          0                                                              2021:09:2010:33:40

           0
/dev/asmdiskg
IGNORED        NORMAL           UNKNOWN                 0          0                                                              2021:09:1922:05:26

           0
/dev/asmdiskd
IGNORED        NORMAL           UNKNOWN                 0          0                                                              2021:09:1921:59:38

           1 DATA1
AFD:DATA1
CACHED         NORMAL           UNKNOWN             51200      44048 DATA1                                                        2021:09:2010:33:40

           1 DATA2
AFD:DATA2
CACHED         NORMAL           UNKNOWN             51200      44048 DATA2                                                        2021:09:2010:33:40

           2 MGMT1
AFD:MGMT1
CACHED         NORMAL           UNKNOWN             40960      39444 MGMT1                                                        2021:09:1922:05:26

           3 OCR1
AFD:OCR1
CACHED         NORMAL           UNKNOWN              5120       4812 OCR1                                                         2021:09:1921:59:38

           3 OCR2
AFD:OCR2
CACHED         NORMAL           UNKNOWN              5120       4820 OCR2                                                         2021:09:1921:59:38

           3 OCR3
AFD:OCR3
CACHED         NORMAL           UNKNOWN              5120       4812 OCR3                                                         2021:09:1921:59:38


12 rows selected.

3.系统层面记录UDEV结果https://www.cndba.cn/hbhe0316/article/96101

[root@rac01 ~]# cat /etc/udev/rules.d/99-oracle-asmdevices.rules 
KERNEL=="sd*",ENV{DEVTYPE}=="disk",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VBa5ab3bca-9c189b9f", RUN+="/bin/sh -c 'mknod /dev/asmdiskb b  $major $minor; chown grid:asmadmin /dev/asmdiskb; chmod 0660 /dev/asmdiskb'"
KERNEL=="sd*",ENV{DEVTYPE}=="disk",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VB17b12e03-424103ce", RUN+="/bin/sh -c 'mknod /dev/asmdiskc b  $major $minor; chown grid:asmadmin /dev/asmdiskc; chmod 0660 /dev/asmdiskc'"
KERNEL=="sd*",ENV{DEVTYPE}=="disk",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VB3f81802d-73cb18e9", RUN+="/bin/sh -c 'mknod /dev/asmdiskd b  $major $minor; chown grid:asmadmin /dev/asmdiskd; chmod 0660 /dev/asmdiskd'"
KERNEL=="sd*",ENV{DEVTYPE}=="disk",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VB4012909d-8d5bac83", RUN+="/bin/sh -c 'mknod /dev/asmdiske b  $major $minor; chown grid:asmadmin /dev/asmdiske; chmod 0660 /dev/asmdiske'"
KERNEL=="sd*",ENV{DEVTYPE}=="disk",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VB5ce61d79-a21a8b8a", RUN+="/bin/sh -c 'mknod /dev/asmdiskf b  $major $minor; chown grid:asmadmin /dev/asmdiskf; chmod 0660 /dev/asmdiskf'"
KERNEL=="sd*",ENV{DEVTYPE}=="disk",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VB74167846-a84de8d0", RUN+="/bin/sh -c 'mknod /dev/asmdiskg b  $major $minor; chown grid:asmadmin /dev/asmdiskg; chmod 0660 /dev/asmdiskg'"

[root@rac01 ~]# ll /dev/asm*
brw-rw---- 1 grid asmadmin 8, 16 Dec 26 21:54 /dev/asmdiskb
brw-rw---- 1 grid asmadmin 8, 32 Dec 26 21:54 /dev/asmdiskc
brw-rw---- 1 grid asmadmin 8, 48 Dec 26 21:54 /dev/asmdiskd
brw-rw---- 1 grid asmadmin 8, 64 Dec 26 21:54 /dev/asmdiske
brw-rw---- 1 grid asmadmin 8, 80 Dec 26 21:54 /dev/asmdiskf
brw-rw---- 1 grid asmadmin 8, 96 Dec 26 21:54 /dev/asmdiskg

增加两块盘符

[root@rac01 ~]#  fdisk /dev/sdh
Welcome to fdisk (util-linux 2.23.2).

Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.

Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0xfa13b072.

Command (m for help): n
Partition type:
   p   primary (0 primary, 0 extended, 4 free)
   e   extended
Select (default p): 
Using default response p
Partition number (1-4, default 1): 
First sector (2048-41943039, default 2048): 
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-41943039, default 41943039): 
Using default value 41943039
Partition 1 of type Linux and of size 20 GiB is set

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.
[root@rac01 ~]#  fdisk /dev/sdi
Welcome to fdisk (util-linux 2.23.2).

Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.

Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0xbc2253c3.

Command (m for help): n
Partition type:
   p   primary (0 primary, 0 extended, 4 free)
   e   extended
Select (default p): 
Using default response p
Partition number (1-4, default 1): 
First sector (2048-41943039, default 2048): 
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-41943039, default 41943039): 
Using default value 41943039
Partition 1 of type Linux and of size 20 GiB is set

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.

[root@rac01 ~]# partx /dev/sdh
NR START      END  SECTORS SIZE NAME UUID
 1  2048 41943039 41940992  20G      
[root@rac01 ~]# partx /dev/sdi
NR START      END  SECTORS SIZE NAME UUID
 1  2048 41943039 41940992  20G
[root@rac01 ~]# fdisk -l | grep "Disk /dev/sd[a-i]"
Disk /dev/sdb: 53.7 GB, 53687091200 bytes, 104857600 sectors
Disk /dev/sde: 5368 MB, 5368709120 bytes, 10485760 sectors
Disk /dev/sdc: 53.7 GB, 53687091200 bytes, 104857600 sectors
Disk /dev/sdh: 21.5 GB, 21474836480 bytes, 41943040 sectors
Disk /dev/sdg: 42.9 GB, 42949672960 bytes, 83886080 sectors
Disk /dev/sdi: 21.5 GB, 21474836480 bytes, 41943040 sectors
Disk /dev/sdf: 5368 MB, 5368709120 bytes, 10485760 sectors
Disk /dev/sdd: 5368 MB, 5368709120 bytes, 10485760 sectors
Disk /dev/sda: 107.4 GB, 107374182400 bytes, 209715200 sectors

3、创建ASM磁盘(只需在节点1中操作即可)：
rac01和rac02两端都需要修改/etc/udev/rules.d/99-oracle-asmdevices.rules文件https://www.cndba.cn/hbhe0316/article/96101https://www.cndba.cn/hbhe0316/article/96101

[root@rac01 ~]# cat /etc/udev/rules.d/99-oracle-asmdevices.rules 
KERNEL=="sd*",ENV{DEVTYPE}=="disk",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VBa5ab3bca-9c189b9f", RUN+="/bin/sh -c 'mknod /dev/asmdiskb b  $major $minor; chown grid:asmadmin /dev/asmdiskb; chmod 0660 /dev/asmdiskb'"
KERNEL=="sd*",ENV{DEVTYPE}=="disk",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VB17b12e03-424103ce", RUN+="/bin/sh -c 'mknod /dev/asmdiskc b  $major $minor; chown grid:asmadmin /dev/asmdiskc; chmod 0660 /dev/asmdiskc'"
KERNEL=="sd*",ENV{DEVTYPE}=="disk",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VB3f81802d-73cb18e9", RUN+="/bin/sh -c 'mknod /dev/asmdiskd b  $major $minor; chown grid:asmadmin /dev/asmdiskd; chmod 0660 /dev/asmdiskd'"
KERNEL=="sd*",ENV{DEVTYPE}=="disk",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VB4012909d-8d5bac83", RUN+="/bin/sh -c 'mknod /dev/asmdiske b  $major $minor; chown grid:asmadmin /dev/asmdiske; chmod 0660 /dev/asmdiske'"
KERNEL=="sd*",ENV{DEVTYPE}=="disk",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VB5ce61d79-a21a8b8a", RUN+="/bin/sh -c 'mknod /dev/asmdiskf b  $major $minor; chown grid:asmadmin /dev/asmdiskf; chmod 0660 /dev/asmdiskf'"
KERNEL=="sd*",ENV{DEVTYPE}=="disk",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VB74167846-a84de8d0", RUN+="/bin/sh -c 'mknod /dev/asmdiskg b  $major $minor; chown grid:asmadmin /dev/asmdiskg; chmod 0660 /dev/asmdiskg'"
KERNEL=="sd*",ENV{DEVTYPE}=="disk",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VB418fc53c-4cd8ab78", RUN+="/bin/sh -c 'mknod /dev/asmdiskh b  $major $minor; chown grid:asmadmin /dev/asmdiskh; chmod 0660 /dev/asmdiskh'"
KERNEL=="sd*",ENV{DEVTYPE}=="disk",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VBbbba5b28-2b42c7b5", RUN+="/bin/sh -c 'mknod /dev/asmdiski b  $major $minor; chown grid:asmadmin /dev/asmdiski; chmod 0660 /dev/asmdiski'"
[root@rac01 ~]# /sbin/udevadm trigger --type=devices --action=change
[root@rac02 ~]# /sbin/udevadm trigger --type=devices --action=change
SQL> select name,path from v$asm_disk;

NAME
------------------------------------------------------------
PATH
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
OCR3
AFD:OCR3

DATA1
AFD:DATA1

OCR2
AFD:OCR2

MGMT1
AFD:MGMT1

OCR1
AFD:OCR1

DATA2
AFD:DATA2


/dev/asmdiskd


/dev/asmdiskb


/dev/asmdiski


/dev/asmdiskh


/dev/asmdiskf


/dev/asmdiske


/dev/asmdiskc


/dev/asmdiskg


14 rows selected.
SQL> conn / as sysasm
Connected.
SQL> alter diskgroup DATA add disk '/dev/asmdiskh' rebalance power 5;
alter diskgroup DATA add disk '/dev/asmdiskh' rebalance power 5
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15410: Disks in disk group DATA do not have equal size.

SQL> alter system set "_asm_disable_dangerous_failgroup_checking"=true;

System altered.

SQL> alter system set "_asm_disable_failgroup_size_checking"=true;

System altered.

SQL> alter diskgroup DATA add disk '/dev/asmdiskh' rebalance power 5;

Diskgroup altered.

SQL> alter diskgroup DATA add disk '/dev/asmdiski' rebalance power 5;

Diskgroup altered.

4.查看asm磁盘变化

https://www.cndba.cn/hbhe0316/article/96101
https://www.cndba.cn/hbhe0316/article/96101 https://www.cndba.cn/hbhe0316/article/96101 
[root@rac01 ~]# su - grid
Last login: Sun Dec 26 22:35:57 CST 2021 on pts/2
[grid@rac01 ~]$ asmcmd lsdg
State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  NORMAL  Y         512             512   4096  4194304    122880   108368            51200           28584              0             N  DATA/
MOUNTED  EXTERN  N         512             512   4096  4194304     40960    39444                0           39444              0             N  MGMT/
MOUNTED  NORMAL  N         512             512   4096  4194304     15360    14444             5120            4662              0             Y  OCR/
[grid@rac01 ~]$ asmcmd lsdg
State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  NORMAL  Y         512             512   4096  4194304    143360   128800            51200           38800              0             N  DATA/
MOUNTED  EXTERN  N         512             512   4096  4194304     40960    39444                0           39444              0             N  MGMT/
MOUNTED  NORMAL  N         512             512   4096  4194304     15360    14444             5120            4662              0             Y  OCR/
[grid@rac01 ~]$

版权声明：本文为博主原创文章，未经博主允许不得转载。

Linux,oracle

hbhe0316
关注
Oracle 19c RAC ASM磁盘扩容
m0_49929446的博客
04-10 3677
简介：日常工作中，会遇到很多数据库迁移的工作内容，当我们检查源机器和目标机器的数据盘空间对比，发现目标机器的空间不够时，需要申请扩容。 扩容步骤： 1.使用root用户分别在两个节点验证扩容后的硬盘是否存在 [orarquat@rqerpvura04 ~]$ sudo su - fdisk -l|grep sd Disk /dev/sdr: 1099.5 GB, 1099511627776 bytes, 2147483648 sectors Disk /dev/sds: 1099.5 GB, 1099511
oracle的asm下扩容表空间,oracle asm添加磁盘扩容
weixin_42280315的博客
04-02 816
1.存储上面挂载lun2.操作系统上面执行如下操作(不需重启操作系统)：echo "- - -" > /sys/class/scsi_host/host0/scanecho "- - - > /sys/class/scsi_host/host1/scan..........一步操作完成：echo "- - - > /sys/class/scsi_host/host**/sca...
Oracle 19C RAC ASM磁盘扩容
qq_41840833的博客
06-11 788
Oracle 19c RAC nfs ASM共享存储扩容
19c rac dbca创建实例前的asm扩容操作
weixin_61212661的博客
06-30 490
在dbca静默建库时出现了错误：报错提示闪回区最小限制是10,206MB，当前闪回区可用只有9616MB，选择足够空间大小的磁盘作为闪回区。为了演示扩容操作我们对FRA所在磁盘组进行扩容。
oracle ASM在线扩容-加盘
anshen_oracle的博客
03-19 690
oracle ASM磁盘组在线加盘 很多时候，我们DBA都会遇到ASM磁盘空间问题需要加盘，这个时候我们DBA一般都会申请停机，而很多时候，一些核心业务是不能停机的，但这个时候往往最尴尬。 接下来我们以AIX 小机和Linux 平台为例讲解ASM在线加盘。 AIX小鸡加盘姿势一： 存储工程师通知到我们存储已将lun 划好映射给主机。（注意：这个时候千万不要忘记了，lun有ldev号，一定跟存储工程师确认好，不然出事就是事故） 1.扫盘操作： cfgmgr 2.确定盘已经...
Oracle19c rac备份数据通过rman恢复到单实例
最新发布
07-02
### Oracle 19c RAC 数据库通过 RMAN 恢复至单实例流程详解 #### 背景概述 在进行Oracle 19c RAC（Real Application Clusters）数据库的数据备份与恢复操作时，可能会遇到需要将RAC集群环境下的备份数据恢复到单...
阿里云ECS环境下CentOS-linux 7.6系统Oracle 19C RAC双节点集群安装部署-优化-维护手册.pdf
12-17
阿里云ECS环境下的Oracle 19C RAC双节点集群安装部署是一个复杂的过程，涉及到多个环节和系统配置。在CentOS 7.6操作系统上搭建这样的环境，首先要确保满足Oracle 19C的软硬件需求。官方推荐的操作系统版本为Linux ...
Centos8安装Oracle 19C RAC超级手册
08-02
## CentOS8安装Oracle 19C RAC的详细步骤与知识点梳理 ### 一、安装准备 #### 1.1 系统版本及环境规划 - **操作系统版本要求**：确保安装的CentOS版本为8.0.1905（Core）。可以通过查看`/etc/redhat-release`文件...
RHEL 7环境下19c RAC安装之udev规则配置ASM共享存储.docx
09-23
在RHEL 7环境下搭建Oracle 19c的Real Application Clusters (RAC)时，配置udev规则以确保ASM(Automatic Storage Management)共享存储的稳定性和可预测性至关重要。udev是Linux系统中的设备管理器，它负责管理和命名...
Oracle集群管理ASM-扩容磁盘组报错ora-15137
oradbm的博客
03-27 794
匹配文档： [OCI] Scale-up Failed in DBCS With ORA-15032: not all alterations performed, ORA-15137: The ASM cluster is in rolling patch state (Doc ID 2681040.1)为两台计算节点补丁不一致，list of patches在计算节点1缺少一个， patch level值不一致。更新完补丁之后，会更新整个集群的patch level。今日对19c集群磁盘组进行扩容，
ASM上ORA-15032、ORA-15036、ORA-15036 的问题
文档搬运工
11-10 1052
RDBMS 19.3 在创建ASM磁盘组的时候，提示错误，错误现象如下： ORA-15032: not all alterations performed ORA-15036: disk 'ORCL:DATA10' is truncated ORA-15036: disk 'ORCL:DATA09' is truncated 这个原因查询MOS，有一种情况，就是ASM的磁盘组的元数据中记录的磁盘大小，和实际使用的磁盘大小不一样。具体可以参考MOSASM disk group mount...
Oracle 19c RAC报错ORA-15032 ORA15411
m0_37625564的博客
09-04 934
报错描述： select a.group_number,b.name,a.failgroup,a.path from v$asm_disk a,v$asm_diskgroup b where a.group_number=b.group_number and a.group_number=1 order by 3; GROUP_NUMBER NAME FAILGROUP PATH --------------------------
asm扩容流程_在线扩容ASM磁盘 - FusionCube DB 3.1 数据库最佳实践 03 (Oracle RAC 11g R2) - 华为...
weixin_29813667的博客
01-13 267
获得每个逻辑卷的SCSI ID之后，用root用户登录所有数据库节点，编辑UDEV规则文件，每一个设备对应一条配置项，每条配置项中包含多个参数，每个卷的scsi_id均不同，仔细查询配置规则。说明：其中需要注意并根据实际环境进行配置的参数是：RESULT——参数格式为RESULT=="3688860300000000ae036568967094421"，每个设备的值不一样，值为通过scsi_id ...
oracle 19c rac asm磁盘绑定的方法
chenqioulin的博客
07-11 861
网络至少2块网卡 心跳和对外服务各一块hosts文件至少配置每个机器的对外服务网卡IP，心跳网卡IP ，VIP，scanIP 先介绍一下什么叫SCAN，SCAN(Single Client Access Name)是Oracle从11g R2开始推出的，客户端可以通过SCAN特性负载均衡地连接到RAC数据库。SCAN提供一个域名来访问RAC，域名可以解析1个到3个（注意，最多3个）SCAN IP，我们可以通过DNS或者GNS来解析实现。其中DNS大家都很熟悉，这里不多说。GNS(Grid Naming Se
oracle ASM磁盘扩容（不关机）
我的博客
08-09 1272
oracle rac扩容asm磁盘（不关机）
oracle asm 增加数据文件,ORACLE 数据库 ASM磁盘组上添加控制文件
weixin_33218985的博客
04-10 717
ORACLE使用ASM存储，建库时默认只有一个控制文件，如果想多加几个控制文件，需要通过手工来添加，以下是我测试文档，贴出来分享下。1.查看当前数据库的控制文件SQL> select name from v$controlfile;NAME------------------------------------------------+DATA01/orcl/controlfile/curr...
oracle11g sp 1503,Oracle 12.2报错ORA-15032、ORA-15410或ORA-15411解决
weixin_33895554的博客
04-05 656
**现象：**在Oracle 12.2.0.1 RAC环境，在其ASM实例中，如果添加不同大小或者不同数量的LUN到failgroup中，会报错：ORA-15032: not all alterations performedORA-15410: Disks in disk group OCRVT do not have equal size.或者ORA-15032: not all altera...
Oracle12c udev管理的asm磁盘组扩容
kadwf123的专栏
10-22 1204
1、环境 grid@r9ithzmedcc01[/home/grid]$cat /etc/redhat-release CentOS Linux release 7.4.1708 (Core) grid@r9ithzmedcc01[/home/grid]$ oracle：12.2.0.1.0 rac双节点 2、添加共享存储 本次使用的是中兴的tecs虚拟化平台： 然后针对刚添...
Oracle 常用命令之二：ASM磁盘组扩容
Eric.zhong
08-20 815
文章目录问题描述问题分析问题解决 问题描述 CRM系统出现异常无法访问，系统反馈如下告警错误： java.sql.SQLException: ORA-00257: archiver error. Connect internal only, until freed. 问题分析 数据库归档日志空间400GB突然被写满，归档日志存放在ASM DataGroup磁盘组。 由于业务已经停滞必须要立刻恢复，归档日志突发增长只能稍后分析。现阶段必须要扩容满足继续保存日志。 问题解决 存储增加磁盘sdm ASM标签制
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值