Rac Voting Disk The Voting Disk File is a file on the shared cluster system or a shared raw device file. Voting disk a key component of clusterware and its …
Read More »RAC Management Commands
Basic RAC Management Commands Cluster Related Commands crs_stat -t Shows HA resource status (hard to read) crsstat Ouptut of crs_stat -t formatted nicely ps -ef|grep d.bin crsd.bin evmd.bin ocssd.bin …
Read More »CRS Administration
CRS Administration CRS Administration starting ## Starting CRS using Oracle 10g R1 not possible ## Starting CRS using Oracle 10g R2 $ORA_CRS_HOME/bin/crsctl start crs stopping ## Stopping CRS using …
Read More »How To Add Redo Logfiles In Standby Database
How To Add Redo Logfiles In Standby Database Step 1. First, Check MEMBER present in Standby Database. SQL> select member from v$logfile; MEMBER ———————————- E:\STANDBYLOGS\REDO03.LOG E:\STANDBYLOGS\REDO02.LOG E:\STANDBYLOGS\REDO01.LOG Step 2. …
Read More »How To Drop Redo Logfiles on Physical Standby Database
How To Drop Redo Logfiles on Physical Standby Database Step 1. First, Cancel the Standby Recovery Process. SQL> alter database recover managed standby database cancel; Step 2. Check …
Read More »RAC General Administration
RAC General Administration Managing the Cluster starting /etc/init.d/init.crs start crsctl start crs stopping /etc/init.d/init.crs stop crsctl stop crs enable/disable at boot time /etc/init.d/init.crs enable /etc/init.d/init.crs disable crsctl enable crs …
Read More »Oracle RAC Daemons and Processes
Oracle RAC Daemons and Processes OPROCd Process Monitor provides basic cluster integrity services EVMd Event Management spawns a child process event logger and generates callouts OCSSd Cluster Synchronization Services …
Read More »RAC Useful Parameters
RAC Useful Parameters cluster_interconnects specify a specific IP address to use for the inetrconnect _gcs_fast_config enables fast reconfiguration for gcs locks (true|false) _lm_master_weight controls which instance will hold or (re)master …
Read More »RAC Useful Views And Tables
RAC Useful Views And Tables GCS and Cache Fusion Diagnostics v$cache contains information about every cached block in the buffer cache v$cache_transfer contains information from the block headers in SGA …
Read More »RAC Acronyms in Used
Real Application Cluster Acronyms GCS Global Cache Services in memory database containing current locks and awaiting locks, also known as PCM GES Global Enqueue Services coordinates the requests of all …
Read More »