Recover Tablespace
To recover from a case of a dropped tablespace, the Tablespace Point In Time Recovery (TSPITR) method cannot be used. When you drop a tablespace,…
Category: Oracle Database
Create Database – using DBCA
We can use two methods “DBCA” or “Manual”, for creating RAC Enable Database. Here I will describe both methods. You can choose one of them.…
Configure Oracle Listener
The Network Configuration Assistant (NETCA) should only be launched and configured on one node. At the end of the configuration process, the NETCA starts up…
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…
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…