Anju Garg Policy-Managed Oracle RAC One Node Databases Oracle RAC One Node, introduced in Oracle Database 11g Release 2 (11.2.0.2), is a single instance of an Oracle RAC-enabled... 09 February 2017 13 min read
Anju Garg Duplicate Point-In-Time Recovered PDB Using Backup At times, we might need to duplicate a production pluggable database to a Past Point in Time without disturbing the production... 25 January 2017 9 min read
Anju Garg Re-registering Databases In A Cluster With srvctl: Problems and Solutions Recently I wanted to create a policy managed database in my 12.1.0.2 flex cluster setup, but free servers are not... 30 November 2016 8 min read
Anju Garg Migrate Oracle Database To ASM Using ASMCMD Introduction Oracle Database 10g Release 1 introduced Automatic Storage Management (ASM), a new framework for managing Oracle database files. ASM... 29 September 2016 9 min read
Anju Garg Oracle Database 12.1.0.2c: Hot Cloning Of Pluggable Databases Cloning of a Pluggable Database (PDB) in Oracle Multitenant is a great feature and is very useful. Oracle Database 12c Release 1 has... 20 September 2016 8 min read
Anju Garg Oracle Database 12.1.0.2c : Hot Cloning of Non-Container Databases In the initial release of Oracle 12c (12.1.0.1c), a non-Container Database (non-CDB) could be converted to a pluggable database (PDB)... 05 September 2016 7 min read
Anju Garg Incomplete / Complete recovery using RMAN cold backup Offline backups (also known as Cold or consistent backups) are taken when the database is in a consistent state, i.e.... 29 June 2016 12 min read
Anju Garg Defragmentation Can Degrade Query Performance As data in tables is updated and / or deleted, pockets of empty space can be created, leading to fragmented... 16 June 2016 15 min read
Anju Garg Automatic Big Table Caching in RAC In an earlier article, I discussed Automatic big table cache (ABTC) which is a new feature introduced in Oracle Database... 13 April 2016 14 min read
Anju Garg Oracle Database 12.1.0.2c: Automatic Big Table Cache Serial direct path reads were first introduced in Oracle 11g to prevent wiping out a large number of buffers from... 11 March 2016 18 min read
Anju Garg ASM Proxy: New Instance Type in Oracle 12c Prior to Oracle Database 12c, an ASM instance ran on every node in the cluster and ASM Cluster File System... 15 February 2016 11 min read
Anju Garg Split Brain: What’s new in Oracle Database 12.1.0.2c? In an Oracle cluster prior to version 12.1.0.2c, when a split brain problem occurs, the node with lowest node number... 14 January 2016 10 min read
Anju Garg Oracle Data Pump in RAC Oracle Data Pump was introduced in Oracle Database 10g to enable very high-speed transfer of data and metadata between databases.... 10 December 2015 15 min read
Anju Garg Oracle 12c Cluster: ACFS Leverages Flex ASM In Oracle Database Releases earlier than 12c, an Automatic Storage Management (ASM) instance runs on every node in the cluster,... 30 September 2015 10 min read
Anju Garg TSPITR Using ACFS Snapshots Starting with Oracle Grid Infrastructure 12c (12.1), Oracle Cloud File system (ASM Cluster File System in cluster environment) supports database... 10 August 2015 16 min read
Anju Garg Integrating ACFS Snapshots With RMAN In my last article, I demonstrated that starting with Oracle Grid Infrastructure 12c (12.1), Oracle Cloud File system (ASM Cluster... 14 July 2015 10 min read
Anju Garg 12c: Database Backups Using ACFS Snapshots Starting with Oracle Grid Infrastructure 12c (12.1), Oracle Cloud File system (ASM Cluster File System in cluster environment ) supports... 29 June 2015 11 min read
Anju Garg Oracle Automatic Storage Management Filter Driver (Oracle ASMFD) Prior to Oracle Grid Infrastructure (GI) release 12.1.0.2, ASM Library (ASMLIB) was the only method to access storage devices by... 22 May 2015 17 min read
Anju Garg Oracle Multitenant: Convert single instance PDB to RAC by plugging it into a RAC CDB Prior to oracle database 12c, the procedures for converting from single-instance databases to Real Application Clusters involved following steps: Configure... 22 April 2015 11 min read
Anju Garg Oracle Multitenant : Super-fast Provisioning of Standby Databases In this article, I will demonstrate how to quickly create a standby database for a non-multitenant container database (NCDB) by... 07 April 2015 8 min read