I have a question regardingASM. Our 2 node RAC database's ASM disk group is getting full. We need to add a disk to the disk group "DATADG", which is in Normal redundancy, which means two-way mirroring. Now, if w
In Oracle, tablespaces are logical storage units containing various types of database objects like tables, indexes, and others. To check the details of tablespaces in an Oracle database, you can use SQL queries against the data dictionary views Here in this article, we will check how to check...
, they are adding a raw disk as an ASM disk in system. Navigate to the following article, if you would like tomanage oracleasm servicesuch as start, stop, restart, enable, disable and status of the service. Once we add a disk at OS level then Database admin can able to see them a...
Provide Type of ACFS (Cluster File System), Mount point (/u02), owner/username of the file system (oracle), Group name(oninstall) and the volume name which is created in above step from the drop down (ACFS-/dev/asm/acfs-476-50G) Execute the acfs_script.sh file as root user [root...
Oracle RAC—which is an option to Oracle Database, Enterprise Edition—is a cluster database with a shared-cache architecture that overcomes the limitations of traditional shared-nothing and shared-disk approaches.Using Oracle VM Templates to deploy Oracle RAC can reduce deployment time from weeks ...
For example, to use the/dev/md/setname/rdsk/dpath for the ASM disk group, add the value/dev/md/*/rdsk/d*to theASM_DISKSTRINGparameter. If you are modifying this parameter by editing the Oracle initialization parameter file, edit the parameter as follows: ...
e.g. to create Oracle ASM disk /dev/oracleasm/asm01 using above multipath device mpathd following udev rule could be used: $ cat /etc/udev/rules.d/96-asmmultipath.rules ACTION=="add|change", ENV{DM_UUID}=="mpath-1234567890abcdefghijklmnopqrstuvwxyz", SYMLINK+="oracleasm/asm01", GROUP...
ASM Fast Disk Resync Overview 1) When we take a disk offline in case the disk is corrupted or database is not able to read or write from the disk. In case of Oracle database 10g, oracle engine use to balance the other disks with the content of offline disk. This process was a rela...
As a result, the Oracle ASM application causes disks to be offline. Solution Run the lsattr -E -a rw_timeout -F value -l Name command to view the rw_timeout value of the device. Table 5-1 Parameter description Parameter Description Name Indicates the device name of a virtual disk....
ORACLE_HOME=/u01/app/12.1.0/grid Invoke asmca [grid@Rac1 ~]$ asmca Click on volumes tab and click on create button Provide the volume name(acfs), from which diskgroup (DATA_T2), Size (50G) and click Ok button. Click on ASM Cluster File System Tab and click on create button ...