This post provides information on enhancements available in RMAN within Oracle 12c. Support for Container and Pluggable Databases RMAN in 12c provides full backup and recovery support for a Pluggable Database environment. You can perform the backup of the entire container database (CDB), either full or using an incremental backup strategy, or one/many pluggable databases (PDB). SYSBACKUP Privilege In 12c, Oracle support for separation of database administration (DBA) duties by … [Read more...] about Oracle RMAN 12c – New Features
oracle 12c
Beginners Guide to Working with spfile in Oracle ASM
Introduction Starting with ASM version 11.2, the ASM spfile can be stored in an ASM disk group. Indeed, during a new ASM installation, the Oracle Universal Installer (OUI) will place the ASM spfile in the disk group that gets created during the installation. This is true for both Oracle Restart (single instance environments) and Cluster installations. It should be noted that the first disk group created during the installation is the default spfile location, but not a requirement. The spfile … [Read more...] about Beginners Guide to Working with spfile in Oracle ASM
Script to verify the Oracle DataPump Data Dictionary Catalog
The package VERIFY_DATAPUMP checks the objects created by different DataPump specific scripts located in $ORACLE_HOME/rdbms/admin, which are automatically called within catproc.sql. Different versions have different DataPump objects in the data dictionary. At this moment the package works only with 11gR2 and 12c. The procedure CHECK_ALL is the core of the package. It calls other internal procedures (similar to corresponding scripts) and fills a global collection which is verified and … [Read more...] about Script to verify the Oracle DataPump Data Dictionary Catalog
How to Rename Diskgroup having OCR, Vote File and SPILE
Consider an 11.2 Grid Infrastructure with CLUSTER setup having OCR, Vote File and ASM SPFILE on a diskgroup. Under certain circumstances, you may wish to rename that diskgroup. "renamedg" utility can be used to rename of the diskgroup when the diskgroup is dismounted. But since the diskgroup contains OCR and Vote File we need to use an intermediate diskgroup for storing OCR and Vote File temporarily while renaming the actual diskgroup. Basic Steps to rename the diskgroup : Create a … [Read more...] about How to Rename Diskgroup having OCR, Vote File and SPILE
12c ASM: PRCR-1001 : Resource ora.proxy_advm Does Not Exist (Flex ASM with Cardinality = ALL)
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)
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
How to Find OCR Master Node
Function of OCR Master Node OCR master is in charge of OCR update and is the only one that's allowed to update, the post shows a way to find OCR master. 1. The default OCR master is always the first node that's started in the cluster. 2. When OCR master (crsd.bin process) stops or restarts for whatever reason, the crsd.bin on surviving node with lowest node number will become new OCR master. Finding OCR Master Node The following method can be used to find OCR master: 1. By … [Read more...] about How to Find OCR Master Node
TSPITR fails With RMAN-06553
The Problem TSPITR fails With RMAN-06553 when the tablespace (using OMF files) is dropped including contents and datafiles: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 10/22/2015 16:43:08 RMAN-03015: error occurred in stored script Memory Script RMAN-06553: DB_CREATE_FILE_DEST … [Read more...] about TSPITR fails With RMAN-06553
How to Recover A Dropped Tablespace Using TSPITR
The Basics RMAN automatic Tablespace Point-In-Time Recovery ( TSPITR) enables you to quickly recover one or more tablespaces in an Oracle database to an earlier time, without affecting the state of the rest of the tablespaces and other objects in the database. Prior to the 11.2 version, the TSPITR had a restriction of not being able to recover the dropped tablespace. From 11.2 this limitation no longer exists. We can recover the dropped tablespace using TSPITR. Example The below example … [Read more...] about How to Recover A Dropped Tablespace Using TSPITR