Create and Configure ASM Instance and ASM DISK Groups
We can use two methods “DBCA” or “Manual”, for creating ASM Instance and Disk group. Here I will describe both methods. You can choose one…
Category: ASM
Fail Groups mirroring
Mirroring is not implemented like RAID 1 arrays (where a disk is partnered with another disk) ASM does not mirror actual disks but does it’s…
ASM Performance
ASM will maximize the available bandwidth of disks by striping file extents across all disks in a DG Two stripe widths are available: coarse which…
ASM exists to manage file storage for the RDBMS
ASM does NOT perform I/O on behalf of the RDBMS I/O is performed by the RDBMS processes as it does with other storage types Thus,…
ASM Storage/Disk Group
A Disk Group in ASM which is visible to the RDBMS as a file beginning with ”+DB_DATA01″; When tablespaces are created, they refer to a…
ASM vs Hardware RAID
ASM & RAID striping are complimentary to each other. When a SAN or disk array provides striping that can be used in a manner which…
ASM Redundancy / High Availability
ASM can perform mirroring to recover from device/disk failures. ASM provide External, Norma and High redundancy mirroring When, we implement hardware level (RAD) mirroring, called…
How to Copy ASM datafile From Primary Database to Standby Database on ASM
Method: 1 On Primary database:- Step 1:- Take an copy of the file to normal file system RMAN > Copy datafile ‘‘ to ‘‘ ;…
How to move ASM database files from one diskgroup to another
The steps involved in moving a datafile from a diskgroup to another is as given below. 1) Identify the data file to be moved. 2)…
How to copy a datafile from ASM to a file system by using dbms package
Step 1. Log onto the target database that is local to the ASM instance as the sys user. Step 2. create source directory within the…