This post covers the detailed steps for creating a physical standby database on a normal file system using RMAN for a primary database in ASM. Overview Here the Standby database can be created using the following 2 methods: Normal Restore and Recovery using RMAN. Creating a Duplicate database for Standby using RMAN. Method 1 Perform […]
ASM
How to Create a Physical Standby from ASM Primary
The Setup This post offers step by step procedure to create physical standby from ASM primary. Database Name: chicago Primary db_unique_name: chicago standby db_unique_name: boston Primary Hostname: prim.example.com standby Hostname: stdby.example.com Steps 1. Enable Force Logging: SQL> ALTER DATABASE FORCE LOGGING; Database altered. 2. On the primary node, create a staging directory. For example: [oracle@prim […]
Oracle 11g – New ASM features
This post is intended to introduce various new ASM features introduced in Oracle Database 11g. Please find below list of the features New SYSASM Role for Automatic Storage Management Administration Disk Group Compatibility attributes ASM Fast Rebalance ASM Fast Mirror Resync New ASMCMD commands Automatic Storage Management Preferred Mirror Read ASM Variable size extents,scalability and […]
ASM Fast Mirror Resync Feature – Example To Simulate Transient Disk Failure And Restore Disk
This post discusses the New 11g ASM feature called ASM Fast Mirror Resync. Also, an example is taken to show how this works. We will simulate the transient disk failure and recover the disk before disk repair time. ASM Fast Mirror Resync ASM fast resync keeps track of pending changes to extents on an OFFLINE […]
Oracle ASM – How ASM Disk Resync Works
Oracle 11g introduces new Scalability and Performance improvements for ASM, this is the case of ASM Fast Disk Resync Feature which quickly resynchronizes ASM disks within a disk group after transient disk path failures as long as the disk drive media is not corrupted. Any failures that render a failure group temporarily unavailable are considered […]
Oracle 11g new feature – ASM Fast Rebalance
This post talks about the 11g new feature – ASM Fast rebalance and how to implement in 11g ASM Instance. ASM Fast Rebalance In 11g, you can use the STARTUP RESTRICT command to control access to an ASM instance while you perform maintenance. This startup option is used to implement ASM Fast Rebalance feature. Rebalance […]
How to Verify if a Disk/Partition is in Use by Oracle ASM, was used by Oracle ASM or is never used by Oracle ASM
The below small C program will help us to identify if a Disk/Partition is still used by ASM, has been used by ASM or has not been used by ASM on Unix or Linux platforms. 1. First of all, we need to compile the below C code: #include <stdio.h> #include <fcntl.h> #define BLOCK_SIZE 4096 int […]
Oracleasm Service Fails to Start After Upgrade to oracleasm-support-2.1.11-1 RPM Package
The Problem After upgrading oracleasm-support package, unable to start the oracleasm service which was working properly before the upgrade. Attempts to start the service result in: # service oracleasm start oracleasm is not enabled, use ‘service oracleasm enable’ or ‘oracleasm init’ The Solution This is caused by a regression in oracleasm-support-2.1.11-1 where the oracleasm configuration […]
Oracle ASM 12c – New Features with examples
This post discusses a few 12C ASM new features with examples: Failgroup_repair_time Online disk replace Estimate Work V$ASM_OPERATION view 1. FAILGROUP_REPAIR_TIME For earlier ASM versions, we had disk_repair_time, from 12C onwards we have failgroup_repair_time at the ASM level. Because failure group outages are more likely to be transient in nature and because replacing all the […]
Interview Questions : Oracle Flex ASM 12c
What is Oracle Flex ASM? Oracle Flex ASM is an ASM instance which will be running in the cluster based on cardinality defined. The default cardinality is three, but you can change it using srvctl modify asm command. It means that ASM is not required to run on each node in the cluster. In the […]