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 ASMFD: Migrate from ASMLIB to ASM Filter Driver

Migrate Oracle ASM storage from ASMLIB to Oracle ASMFD (ASM Filter Driver) in Oracle 12.1.0.2+. Complete step-by-step: verify ASMLIB, label...

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

Register for Simple Talk

Anju Garg

Anju Garg's content

Policy-Managed Oracle RAC One Node Databases

Duplicate Point-In-Time Recovered PDB Using Backup

Re-registering Databases In A Cluster With srvctl: Problems and Solutions

Migrate Oracle Database To ASM Using ASMCMD

Oracle Database 12.1.0.2c: Hot Cloning Of Pluggable Databases

Oracle Database 12.1.0.2c : Hot Cloning of Non-Container Databases

Incomplete / Complete recovery using RMAN cold backup

Defragmentation Can Degrade Query Performance

Automatic Big Table Caching in RAC

Oracle Database 12.1.0.2c: Automatic Big Table Cache

ASM Proxy: New Instance Type in Oracle 12c

Split Brain: What’s new in Oracle Database 12.1.0.2c?

Oracle Data Pump in RAC

Oracle 12c Cluster: ACFS Leverages Flex ASM

TSPITR Using ACFS Snapshots

Integrating ACFS Snapshots With RMAN

12c: Database Backups Using ACFS Snapshots

Oracle ASMFD: Migrate from ASMLIB to ASM Filter Driver

Oracle Multitenant: Convert single instance PDB to RAC by plugging it into a RAC CDB

Oracle Multitenant : Super-fast Provisioning of Standby Databases