Case 2: All members of a log group lost
In this case an incomplete recovery is the best we can do. We will lose all transactions from the missing log and all subsequent logs.…
Category: Blog
Your blog category
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,…
Time-Based, Change-Based, or SCN-based Incomplete Recovery
Incomplete recovery uses a backup to produce a non-current version of the database. In other words, you do not apply all of the redo records…
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…
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…