Applicable platform: aixhzinuxwinsolaris applicable version: all databases 10.1.0.2to12.1.0.1 apply to rac and standalone. Take the RAC environment as an example: Suppose
Applicable platform: AIX hp linux win Solaris applicable version: all databases 10.1.0.2 to12.1.0.1 applicable to rac and standalone take the RAC environment as an example: Suppose
Applicable platform: AIX hp linux win Solaris
Applicable versions: all databases 10.1.0.2 to12.1.0.1
Applicable to rac and standalone
Take the RAC environment as an example: Assume that Oracle is an oracle rdbms group, and grid is a gi group;
For ASMLIB users:
In the RAC environment, the gi owner executes the following command:
1. #/etc/init. d/oracleasm scandisks # (executed by the root user)
$> Id
$>/Etc/init. d/oracleasm listdisks
$>/Etc/init. d/oracleasm querydisk <具体磁盘路径>
All nodes must be executed;
2. At the operating system level, check whether the disk can be read and written (each node) (oracle user or grid user)
# 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. Use kfed to verify whether the disk is a candidate disk;
Kfed read | Grep kfbh. type
Kfbh. type: 0; 0x002: KFBTYP_INVALID if such a result is displayed, the disk is available.
4. Create a temporary disk group. It mainly uses the ASM instance to check that all the disks to be attached are correct. Even if a problem occurs, the original production system will not be affected. Although there are many steps to check, it is annoying, but there is no accident in the production system.
Create diskgroup lixora external redundancy disk '/dev/rhdisk *';
5. Check whether the created dg has been automatically mounted?
Select state, name from v $ ASM_DISKGROUP;
6. If there is no mount, try to manually mount
Alter diskgroup test mount;
--- Confirm the status of dg
Select state, name from v $ ASM_DISKGROUP;
7. If Step 6 queries lixora successfully (if rac is used, make sure that each ASM instance is successfully mounted)
It indicates that all the asm disks to be added are normal and can be used normally. Then we can add them to the production dg.
----- Uninstall dg (execute this command in ASM instance)
Alter diskgroup test dismount;
---- Delete the temporary dg used for testing (execute this command in ASM instance)
Drop diskgroup test;
8. Here we can add the candidate disk to the production dg.
ALTER DISKGROUP ADD disk' ';
The Standalone environment is the same. We also recommend that you perform the above test steps.
How to change the password of ASM sys
How to copy data files in ASM to the Operating System
Restoration After all Oracle 11g rac asm disks are lost
Oracle 11g from entry to proficient in PDF + CD source code
Installing Oracle 11g R2 using RHEL6 ASM
Oracle 10g manual creation of the ASM Database
Solutions to various problems after installing Oracle 11gR2 in Ubuntu 12.04 (amd64)
How to change the sys password of Oracle 10g ASM