What is a Container Database? A 12c database is either a non-Container Database or a Container Database - from here on referred to as non-CDB or CDB respectively. All databases created prior to 12c are non-CDBs. A CDB is an Oracle database that includes zero, one, or many customer-created Containers or Pluggable Databases referred to as PDB. The CDB has: one ROOT container (CDB$ROOT) containing SYSTEM, SYSAUX, UNDO, and TEMP tablespaces, Controlfiles and Redologs one SEED container … [Read more...] about RMAN Pluggable Database Backup and Recovery in a Multitenant Environment
oracle 12c
Oracle RMAN Pluggable Database Point in Time Recovery
Point in time recovery of a Pluggable Database (from hereon referred to as a PDB) requires ALL files including UNDO to be restored and recovered to the specified time. As all PDBs write to the ROOT UNDO tablespace, point in time recovery of a PDB will use an auxiliary instance and will restore the CDB$ROOT UNDO, SYSTEM, SYSAUX, and SYSEXT tablespaces into the ROOT of the auxiliary instance. The datafiles of the PDB itself are restored and recovered in-situ. The auxiliary database is created … [Read more...] about Oracle RMAN Pluggable Database Point in Time Recovery
Oracle RMAN 12c – New Features
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
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