Configuring RMAN Backup

Here I will explain how to configure very basic and very simple RMAN backup job to take daily backup (incremental level 0), which can be used by anyone at any OS platform and for any version of Oracle Database - difference will only be the file system paths which will be different in Windows and Unix based platforms.

ORA-03264 cannot drop offline datafile of locally managed tablespace

On one of my customer’s site, I was told that they want to drop a datafile which is offline for past one year. One year ago some novice person tried to add the datafile with a name which was not correct according to him and while trying to rename it,

Configuring Oracle Dataguard for RAC

Before we start, first you should check my article Configuring Oracle Dataguard, for a single node primary database and single node standby database; because configuring Dataguard for RAC is not much different than setting up Dataguard for single node database. During this article, I would be referring to the aforementioned document rather than

Configuring Oracle Dataguard

Following is a step by step guide to configure Oracle Dataguard using physical standby database for Oracle database. If you have RAC environment, you can follow this document to configure dataguard. OS platform for this example is Oracle Linux 6 (x86_64), but same steps can be followed to configure dataguard for other platforms. 

Database Growth History and Forecast for 10g and 11g

For 12c container/pluggable Database, you can use Database Growth History and Forecast for 12c and Above, and Tablespace Growth History and Forecast for 12c and Above scripts.

For 10g, 11g tablespace growth history and forecast, you can use Tablespace Growth History and Forecast for 10g and 11g) script. 

Performing Disaster Recovery using RMAN

Here I will be explaining how to perform disaster recovery of a database server where server has been lost because of hardware failure and needs everything to be prepared from scratch. This would require that a same type of server has been provisioned which has matching resources as we had on the actual production server. Before moving forward,

Converting a non-CDB database to a PDB

Here I would explain how do we convert a non-CDB (non-container database) to a PDB (pluggable database) in an existing CDB (container database) on the same host as well as on a different host.  For this example, I used Oracle 12.1.0.2 software version and this example assumes that there is already a container database with name “mycdb”

Upgrading Grid Infrastructure 11g to 12c

In this post I will be demonstrating the steps to upgrade Oracle Grid Infrastructure (GI) 11g (11.2.0.4) to Grid Infrastructure 12c (12.1.0.2). Since ASM runs from GI home, ASM would be upgraded automatically while the upgrade of GI. First release version of 12c was 12.1.0.1 and for this example, I would be using 12.1.0.2. As we know that

PRCA-1057 Failed to retrieve the password file location used by ASM asm

PRCA-1057 : Failed to retrieve the password file location used by ASM asm PRCR-1097 : Resource attribute not found: PWFILE

After upgrading your grid infrastructure 11g to 12c, you will notice that executing command “srvctl config asm” returns abovementioned error messages.

Upgrading Oracle 11g Database to 12c using DBUA

For manual upgrade guide from 11g to 12c or 12.1.0.1 to 12.1.0.2, click here

Here I would be discussing how to upgrade Oracle 11g (11.2.0.4) database to 12c (12.1.0.2) on the same server. This upgrade process was done on Linux 6 (x86_64). I used DBUA (Database Upgrade Assistant) to perform this upgrade. DBUA