Posts by Rahul Subramanian

Automatic Storage Management Cluster File System(ACFS) mount point creation

ACFS concept was introduced in 11.2.0.1 it only manages the non-database files.  Oracle ACFS (Automatic Storage Management Cluster File System) is the preferred file manager for non-database files. It is…

Read More

Oracle Cloud 19c Grid and Database Installation in Silent mode.

Now we are going to create an instance in cloud. Create a VM instance. Click compute —>instance—>create instance. Give name to your instance and choose in which compartment you want…

Read More

Upgrading a CDB & PDB from 12c to19c using Manual Upgrade

In this article we are going to see how to upgrade a oracle 12c container database from 12c to 19c using manual upgrade method. Here we are going to proceed…

Read More

DATABASE UPGRADE USING AUTOUPGRADE TOOL FROM 12c to 19c.

It is a feature that is enhanced in oracle 19c and it is mainly used to automate the upgrade process.it not only automates the database upgrade but also performs the pre-upgrade steps…

Read More

MANUAL DATAGUARD SWITCHOVER 19c

MANUAL DATAGUARD SWITCHOVER 19c Switch over: It is reversal of role between a standby database and a primary database. The primary database assumes role of standby database and the standby…

Read More

Oracle Dataguard physical Standby configuration in 19c(Active method)

  Oracle Dataguard physical Standby configuration in 19c:(Active method-without using rman backup) Overview steps: Step:1 we have to enable the archive log mode ,flashback  on primary databases. Step:2 Then enable the force…

Read More

Converting a physical standby database into snapshot standby database

What is snapshot standby database? It allows to perform read-write operation on the standby database.ie converting the physical standby to snapshot standby database. On that, we can do all types…

Read More

How to change the db name using nid utility

Introduction to Nid Utility: NID is an utility which is used to change the database internal name and dbname of a database. The utility is placed in the $ORACLE_HOME/bin directory.…

Read More

Restore A Loss Of Controlfile Using Autobackup

Follow the steps to Restore A Loss Of Controlfile Using Autobackup:   Step:1 connect to RMAN and view the default parameters using SHOW ALL. Step:2 see the location of control…

Read More

BACKUP DATABASE USING RECOVERY CATALOG.

Steps in Backuping database using Recovery Catalog: What is a Recovery Catalog? RMAN metadata can be stored in either of the two places, Controlfile Recovery catalog Hence recovery catalog is…

Read More