ORA-15073: Diskgroup Mounted By Another Instance

We know that in the database each and every  “Error “has its own reasons. Let’s have look on Error ORA-15073: Diskgroup Mounted By Another Instance. This article explains the cause and action for this error. Cause: An attempt was made to drop a diskgroup that is still mounted somewhere in the cluster by another instance. Action: dismount the […]

Read More

How To Rename ASM Diskgroup With RAC Database

  Below are the steps for renaming an ASM diskgroup with database files present inside for a running database.   EXAMPLE: In this article we will rename the diskgroup +DATATST to +NEWTST.  The database present inside the diskgroup is TESTDB2 . 1. Check configuration of the database: srvctl config database -d TESTDB2 srvctl config database -d […]

Read More

Steps for Copy ASM File From One Server To Another Server

In the world of Technology, we all know COPY and PASTE how much helpful for making any business operations. But in the field of Database, it is not same as in another area. Some different steps we have to use. Let’s have look on those steps which we use for Copy ASM File From One Server To Another Server. Copying file between […]

Read More

Move Datafile From File System To ASM Disk In 11g

Today, we are going to learn about those steps which use to move Datafile from file system to ASM disk in Oracle 11g.Being an Oracle DBA we have deep knowledge of Datafiles. We know there importance of Datafiles in the database. Somes lines explain about the technical definition. A data file is a file that is […]

Read More

Steps for Install Grid Infrastructure 12c On Standalone Server

Today, we are going to have look on the steps which is used for Install Grid Infrastructure 12c On Standalone Server. Grid installation on the standalone database server is also known as Oracle Restart. This is required if you wish you use ASM file system with Oracle restart feature. Oracle Restart Means, During any accidental Hardware or software […]

Read More

RMAN Active Cloning From RAC TO RAC

Being an Oracle DBA we know that what is cloning? This technical definition gives you a correct idea of the cloning. RMAN has the ability to duplicate, or clone, a database from a backup or from an active database. It is possible to create a duplicate database on a remote server with the same file structure, […]

Read More

Steps for Create RAC Database Manually

Manual Creation of Database is a big task for DBA. This is the initial steps for setup the IT project. We know that we can create the database in two ways one is DBCA and another is  Manual. Creation of Database in RAC environment different from the Standalone database. In this post we are going have look on […]

Read More

RAC Useful Srvctl Commands

Use the Server Control (SRVCTL) utility to manage various components and applications in your cluster. This appendix contains reference information for Server Control commands, including utility usage information and a comprehensive listing of the SRVCTL commands. SRVCTL is installed on each node in a cluster by default. To use SRVCTL, log in to the operating […]

Read More

RAC Useful CRSCTL Commands

CRSCTL is an interface between you and Oracle Clusterware, parsing and calling Oracle Clusterware APIs for Oracle Clusterware objects. Oracle Clusterware 11g release 2 (11.2) introduces cluster-aware commands with which you can perform check, start, and stop operations on the cluster. You can run these commands from any node in the cluster on another node […]

Read More

Multiplex Redolog In Oracle RAC

Being an Oracle DBA in the initial year of our we work on the standalone database. In the world of backup, we work on multiplexing of the redo log. But as in single instance database is different from RAC environment. Multiplexing means to keep multiple copies of redo log in different diskgroup. It is similar to […]

Read More