The Problem 1. Several disks have been added to an existing diskgroup in RAC environment and sqlplus session initiating adding operation does not return the control which have to be disconnected manually. 2. Rebalance is not occuring from v$asm_operation: SQL> select * from gv$asm_operation; no rows selected 3. “disk validation pending” message in other nodes […]
ASM
Oracle 12c: Unplug/Plug PDB to new CDB using RMAN Active Database Duplication
This method takes advantage of a new feature of RMAN in 12c allowing you to clone database files and apply incrementals to those files from an active database without requiring staging areas. In addition, the source PDB application activity can continue while the cloning and incremental applies are being performed. To get the datafiles in […]
Oracle RAC: How to Change private network interface name, subnet or netmask
It may be necessary to change or update interface names, or subnet associated with an interface if there is a network change affecting the servers, or if the original information that was input during the installation was incorrect. It may also be the case that for some reason, the Oracle Interface Configuration Assistant (‘oifcfg’) did […]
How To Create “A CRS Managed” ACFS FileSystem On Oracle RAC Cluster (ASM/ACFS 11.2)
1. Create the mount points on all the nodes (as root user): # mkdir /goldengate 2. Connect to the ASM instance & create the ACFS diskgroup (from the +ASM1 instance): SQL> CREATE DISKGROUP ACFSTEST EXTERNAL REDUNDANCY DISK ‘ORCL:ASMDISK18’ SIZE 4157 M DISK ‘ORCL:ASMDISK19’ SIZE 4157 M ATTRIBUTE ‘compatible.asm’ = ‘11.2’, ‘compatible.advm’ = ‘11.2’; Diskgroup created. […]
How to Use Udev Rules to Create oracleasm Disks in CentOS/RHEL 8
This post will help to configure Oracleasm disks using Udev rules in 2 node cluster. On first node 1. List the disks: [root@node01 ~]# lsblk NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT sda 8:0 0 2G 0 disk sdb 8:16 0 2G 0 disk Note: Create partitions for the disks. 2. Find the disk ID: […]
How to Disable os-prober in CentOS/RHEL 7
What is os-prober The os-prober package detects all operating systems available on the machine and returns the results in a generic machine-readable format. Sometimes os-prober may cause problems when probing some special disks (Ex: Oracle ASM disks). This post describes how to disable os-prober. Disabling os-prober os-prober is invoked by the command grub2-mkconfig when generating […]
How to check and repair ACFS with FSCK
The Problem You noticed many inconsistencies in different asm metadata views, asmcmd and os outputs that are associated with the ACFS file system. Database shows corruption in RMAN or from dbverify. Database uses ACFS. ALTER DISKGROUP CHECK REPAIR comes back clean but you still see errors or check for corruption returns back positive, eg: $ […]
How to split BCV and open oracle ASM database
BCV (Business Continuance Volume ) is the target volume for EMC Symmetrix TimeFinder/Mirror process. When a BCV is fully synchronized with a data device, the BCV is separated or split, thus becomes available to a host for backup or other host processes. In short, a BCV split is a device to be a clone of […]
Unable to instantiate disk “ASM_DISK” – error on running ‘oracleasm scandisks’ command
The Problem The new disk has been assigned to a host and the user needs to run a scandisk. But the command fails to instantiate new disks with the below error. # oracleasm scandisks Reloading disk partitions: done Cleaning any stale ASM disks… Scanning system for ASM disks… Instantiating disk “ASM_DISK_01” Unable to instantiate disk […]
Understanding Device Persistence and Oracle ASMLib
Basics This post describes some advantages the Linux specific ASM library provided by Oracle (herein “ASMLib”) brings to the administration of a Linux system running Oracle. Linux often presents the challenge of disk name persistence. Change the storage configuration and a disk that appeared as /dev/sdg yesterday can appear as /dev/sdh after a reboot today. […]