Check ASM Diskgroup Space and Directory Size

The script below can be used to check the Disk Group Space Free and also Check Directory sizes for each Disk Group The script is written by somebody at Pythian but i cannot re-collect the original link to the blog. eg: ./asmcmd_du.sh DiskGroup Total_MB Free_MB % Free --------- -------- ------- ------ DATAC1 15962112 11215880 70 … Continue reading Check ASM Diskgroup Space and Directory Size

Oracle 12c Dataguard RAC Primary to RAC Standby with Dataguard Broker (on Exadata)

Setup for the Environment ------------------- Exadata X4-2 Quater Rack n Primary and Standby Site Grid Version : 12.1.0.2 DB Home Version : 12.1.0.2 Primary, 2 Node RAC, db_unique_name = primeprd Instance 2 : primeprd1 Instance 2 : primeprd2 TNS entry: PRIMEPRD, but below entry in tnsnames.ora files on both node with DB Home user, most … Continue reading Oracle 12c Dataguard RAC Primary to RAC Standby with Dataguard Broker (on Exadata)

Oracle Dataguard Broker 12c with password file in ASM

Configure 12c dataguard broker using the below command onPrimary database server primeprd - > tnsnames for primary database primedr-> tnsnames for standby database /home/oracle::11g-->dgmgrl DGMGRL> connect sys/******** DGMGRL> create configuration dg_primeprd as primary database is primeprd connect identifier is primeprd; DGMGRL> add database primedr as connect identifier is primedr maintained as physical; Configuration "dg_primeprd" created … Continue reading Oracle Dataguard Broker 12c with password file in ASM

Add Members for Online Relog File Group on RAC ASM

Let's say you have already created logfiles from Group 1 to Group 8 on a 2 node RAC cluster on Diskgroup :+RECOC1. Now it is always highly recommended to mutiplex the relog files. This is how we will add new members to existing groups. First let us see the commands to create the logfile groups … Continue reading Add Members for Online Relog File Group on RAC ASM

Move SPFILE to ASM RAC

-- Move SPFILE to ASM RAC --Already we have a PFILE called initmove.ora which was created previously from spfileSQL> show parameter spfileNAME TYPE VALUE------------------------------------ ----------- ------------------------------spfile string /u02/app/oracle/product/11.2.0 /dbhome_1/dbs/spfiletest1.oraAs you can see the spfile is in FilesystemSQL> create spfile='+DATAC1/test/spfiletest.ora' from pfile='/u03/rman/initmove.ora';File created.SQL> exitCreate a pfile called inittest.ora and add only below line only in it … Continue reading Move SPFILE to ASM RAC

Copy File from Filesystem to ASM

In this exercise we will copy a file residing on a filesystem onto ASM disk. [sourcecode language="sql"] SQL> create or replace directory asm_dir as '+FRA/BACKUP'; Directory created. SQL> grant read, write on directory asm_dir to public; Grant succeeded. SQL> create or replace directory export_dump as '/filesystem/exportdump'; Directory created. SQL> grant read,write on directory export_dump to … Continue reading Copy File from Filesystem to ASM

Multiple Standby Databases Dataguard Oracle

We will create 2 standby databases from a single RAC primary database. 11gR2 allows upto 30 standby databases.  The most important part is to consider the dataguard parameters, the rest is a normal dataguard creation. The important parameters are as below : db_file_name_convert log_archive_config log_archive_dest_1 log_archive_dest_2 log_archive_dest_3 LOG_ARCHIVE_DEST_STATE_1 LOG_ARCHIVE_DEST_STATE_2 LOG_ARCHIVE_DEST_STATE_3 log_file_name_convert remote_login_passwordfile STANDBY_FILE_MANAGEMENT fal_client fal_server … Continue reading Multiple Standby Databases Dataguard Oracle

ORA-29701: unable to connect to Cluster Synchronization Service

Problem ------ Error on starting ASM from SQLPLUS or ASMCMD SQL> startup; ORA-01078: failure in processing system parameters ORA-29701: unable to connect to Cluster Synchronization Service SQL> exit Disconnected Solution -------- As Grid User $ crsctl start res ora.cssd CRS-2672: Attempting to start 'ora.cssd' on 'prmdb' CRS-2672: Attempting to start 'ora.diskmon' on 'prmdb' CRS-2676: Start … Continue reading ORA-29701: unable to connect to Cluster Synchronization Service