Oracle : Rename ASM Disk Label in Oracle 12c (RAC)

Rename Disk Label for reallocating disks from one diskgroup to other diskgroup     Before :    login as    sysasm :   

Wait till rebalnce completes.  

Please perform “ asm scan” command on other nodes which exists in the cluster :  … Read More

Rise of NoSQL databases

Dear Readers, In this article we will see Rise of NoSQL databases. Over the last few years we have seen the rise of a new type of databases, known as NoSQL databases that are challenging the dominance of relational databases. Relational databases have dominated the software industry for a… Read More

Oracle : Generate Clear output for crs_stat -t

Oracle : Generate Clear output for crs_stat -t  

chmod 755 crsstat.sh   Output :  

 

Oracle : Storage Management

STORAGE MANAGEMENT     In oracle, database space demanding objects are called segments. There are 5 different segments i.e. tables, indexes, temporary, undo, rollback segments.     Within a single server, we can create multiple database. Database contains one or more tablespace. One tablespace can… Read More

ORACLE – Creating a Data Guard Physical Standby environment – Part2

Continuation to the Data Guard Physical standby creation   ORACLE – Creating a Data Guard Physical Standby environment – PART1   Enable Archiving   On 10g you can enable archive log mode by mounting the database and executing the archivelog command:  

  Set… Read More