The Problem This a RAC cluster configuration composed of 2 nodes. Clusterware was upgrade from 11.2.0.4 to 12.1.0.2 release. And ASM was converted to "Flex ASM" with "Cardinality = ALL". Validating the "ora.proxy_advm" resource state reports the below error: $ srvctl status asm -proxy -n asmcloud2 -verbose PRCR-1001 : Resource ora.proxy_advm does not exist The Solution 1. ASM instances are running and available on both nodes: ora.asm 1 ONLINE ONLINE asmcloud1 … [Read more...] about 12c ASM: PRCR-1001 : Resource ora.proxy_advm Does Not Exist (Flex ASM with Cardinality = ALL)
ASM
How to Convert STANDARD ASM to FLEX ASM in 12C
You can convert an Oracle ASM configuration to an Oracle Flex ASM using ASMCA. This functionality is only available in an Oracle Grid Infrastructure 12c configuration. Before you convert an Oracle ASM configuration to an Oracle Flex ASM, you must ensure the following: Oracle Cluster Registry (OCR) is stored in a disk group. The server parameter file (SPFILE) is stored in a disk group. The password file (ORAPWD file) is stored in a disk group. The disk group where the OCR, SPFILE, and … [Read more...] about How to Convert STANDARD ASM to FLEX ASM in 12C
How to Restore ASM Based OCR After Complete Loss of the CRS Diskgroup on Linux/UNIX
It is not possible to directly restore a manual or automatic OCR backup if the OCR is located in an ASM disk group. This is caused by the fact that the command 'ocrconfig -restore' requires ASM to be up & running in order to restore an OCR backup to an ASM disk group. However, for ASM to be available, the CRS stack must have been successfully started. For the restore to succeed, the OCR also must not be in use (r/w), i.e. no CRS daemon must be running while the OCR is being restored. When … [Read more...] about How to Restore ASM Based OCR After Complete Loss of the CRS Diskgroup on Linux/UNIX
Step By Step Guide To Create Physical Standby On Normal File System For ASM Primary using RMAN
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 the backup of the ASM primary database ( Datafiles, Controlfile for standby and Archivelogs ) Make the backup pieces available on the Standby … [Read more...] about Step By Step Guide To Create Physical Standby On Normal File System For ASM Primary using RMAN
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 ~]$ mkdir –p /home/oracle/stage 3. Create the same exact … [Read more...] about How to Create a Physical Standby from ASM Primary
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 performance enhancements Automatic Storage Management Rolling Migration 1. New SYSASM Role for … [Read more...] about Oracle 11g – New ASM features
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 disk during an outage. The extents are resynced when the disk is brought back online or replaced. By default, ASM drops a disk shortly after it is taken offline. You can set the … [Read more...] about ASM Fast Mirror Resync Feature – Example To Simulate Transient Disk Failure And Restore Disk
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 transient failures. Disk path malfunctions, such as cable disconnections, host bus adapter or controller failures, or disk power supply interruptions, … [Read more...] about Oracle ASM – How ASM Disk Resync Works
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 operations that occur while a disk group is in RESTRICTED mode eliminate the lock and unlock extent map messaging between ASM instances in Oracle RAC environments. When an … [Read more...] about Oracle 11g new feature – ASM Fast 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 main(int argc, char *argv[]) { char buf[BLOCK_SIZE]; char *fname; int fd; int count; if (argc != 2) { fprintf(stderr, "Exactly one argument … [Read more...] about 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