适用平台: AIX hp linux win Solaris 适用版本:所有数据库10.1.0.2 to12.1.0.1 适用于 rac和 standalone 以RAC 环境为例: 假设
适用平台: AIX hp linux win Solaris
适用版本:所有数据库10.1.0.2 to12.1.0.1
适用于 rac和 standalone
以RAC 环境为例: 假设 Oracle 为oracle rdbms 属组;grid 为 gi 属组;
For ASMLIB users:
RAC 环境 gi owner 执行以下命令
1、# /etc/init.d/oracleasm scandisks #( root用户执行)
$> id
$> /etc/init.d/oracleasm listdisks
$> /etc/init.d/oracleasm querydisk
所有节点都要执行;
2、在操作系统层面检查磁盘是否可以读写(每个节点)(oracle 用户或者grid用户)
# raw device
$> dd if=/dev/raw/raw1 of=/dev/null count=100 bs=8192
# ASMLIB device
$> dd if=/dev/oracleasm/disks/PRODA07 of=/dev/null count=100 bs=8192
# raw device
$> dd if=/dev/rdsk/c1t3d0s6 of=/dev/null count=100 bs=8192
3、适用kfed 验证磁盘是否为候选盘;
kfed read
kfbh.type: 0 ; 0x002: KFBTYP_INVALID 如果看到这么一个结果,表明该磁盘是可用的。
4、创建临时磁盘组,主要是用ASM 实例来检验下所有要加的盘没有问题,,即使出问题,也不会影响原来的生产系统。虽然要检查的步骤比较多,比较烦,但是对于生产系统来说出不了任何意外。
CREATE DISKGROUP lixora EXTERNAL REDUNDANCY DISK '/dev/rhdisk*';
5、检查刚创建的dg 是否已经自动mount 了?
SELECT STATE, NAME FROM V$ASM_DISKGROUP;
6、如果没有mount,尝试手工mount
ALTER DISKGROUP TEST MOUNT;
---确认dg状态
SELECT STATE, NAME FROM V$ASM_DISKGROUP;
7、如果step6 查询lixora成功mount(如果rac ,则确保每个ASM实例都成功mount)
则说明我们需要添加的asm 盘都正常的,可以正常使用。那么我们就可以把他们加到生产的dg中了。
-----卸载dg(在ASM instance中执行这个命令)
alter diskgroup test dismount;
----删除测试用临时dg (在ASM instance 中执行这个命令)
DROP DISKGROUP TEST;
8、到这里就可以吧候选盘加到生产的dg里了。
ALTER DISKGROUP
Standalone 环境也是一样的,同样建议执行上述测试步骤。
如何修改ASM的sys密码
如何将ASM中的数据文件复制到操作系统中
Oracle 11g RAC ASM磁盘全部丢失后的恢复
Oracle 11g从入门到精通 PDF+光盘源代码
RHEL6 ASM方式安装Oracle 11g R2
Oracle 10g 手工创建ASM数据库
Ubuntu 12.04(amd64)安装完Oracle 11gR2后各种问题解决方法
如何修改Oracle 10g ASM的sys密码
本文永久更新链接地址:

This article explores optimizing MySQL memory usage in Docker. It discusses monitoring techniques (Docker stats, Performance Schema, external tools) and configuration strategies. These include Docker memory limits, swapping, and cgroups, alongside

This article addresses MySQL's "unable to open shared library" error. The issue stems from MySQL's inability to locate necessary shared libraries (.so/.dll files). Solutions involve verifying library installation via the system's package m

The article discusses using MySQL's ALTER TABLE statement to modify tables, including adding/dropping columns, renaming tables/columns, and changing column data types.

This article compares installing MySQL on Linux directly versus using Podman containers, with/without phpMyAdmin. It details installation steps for each method, emphasizing Podman's advantages in isolation, portability, and reproducibility, but also

This article provides a comprehensive overview of SQLite, a self-contained, serverless relational database. It details SQLite's advantages (simplicity, portability, ease of use) and disadvantages (concurrency limitations, scalability challenges). C

This guide demonstrates installing and managing multiple MySQL versions on macOS using Homebrew. It emphasizes using Homebrew to isolate installations, preventing conflicts. The article details installation, starting/stopping services, and best pra

Article discusses configuring SSL/TLS encryption for MySQL, including certificate generation and verification. Main issue is using self-signed certificates' security implications.[Character count: 159]

Article discusses popular MySQL GUI tools like MySQL Workbench and phpMyAdmin, comparing their features and suitability for beginners and advanced users.[159 characters]


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

SublimeText3 English version
Recommended: Win version, supports code prompts!

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools
