Useful docs regarding Application Continuity

Graceful Application Switchover in RAC with No Application Interruption (Doc ID 1593712.1) Client and Application Failover Validation Matrix (Doc ID 1617163.1) PDB Failover in a Data Guard environment: Unplugging a Single Failed PDB from a Standby Database and Plugging into a New Container (Doc ID 2088201.1) Understanding Transparent Application Failover (TAF) and Fast Connection Failover… Continue reading Useful docs regarding Application Continuity

NetworkManager and team in RHEL7

https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Linux/7/html/Networking_Guide/sec-NetworkManager_and_the_Network_Scripts.html In previous Red Hat Enterprise Linux releases, the default way to configure networking was using network scripts. The term network scripts is commonly used for the script /etc/init.d/network and any other installed scripts it calls. The user supplied files are typically viewed as configuration, but can also be interpreted as an amendment to the… Continue reading NetworkManager and team in RHEL7

Recreating and restore controlfiles

Controlfile contains important information regarding instance and media recovery and here is how to understand its important role in several scenarios. My environment: OS: Redhat Linux 6.3 x86_64 DB: Oracle 11.2.0.3 Single instance 1 Control file contains backup information. [oracle@bcmsdbs01 bin]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Wed Nov 9 10:08:48 2016… Continue reading Recreating and restore controlfiles

step-by-step guide on configuring db2 hadr replication

Source: 192.168.91.59 Destination: 192.168.91.11 DB name: CMSDB DB2 version: 9.7.0.7 # as db2inst1 on primary, make sure LOGARCHMETH1 is set db2 get db cfg for cmsdb | grep LOGARCHMETH1 # Setting up HADR cfg parameters on Primary database. db2 update db cfg for CMSDB using HADR_LOCAL_HOST 192.168.91.59 db2 update db cfg for CMSDB using HADR_LOCAL_SVC… Continue reading step-by-step guide on configuring db2 hadr replication

Identifying multiple unused indexes in DB2 automatically

db2pd utility could be used to identify unused indexes in db2. Nevertheless, when the amount of unused index is significant, manually querying index information could be tedious. Here is how to retrieve unused index automatically. # retrieve db2pd tcbstats information db2pd -d cmsdb -full -tcbstats all file=/tmp/db2pd_tcb.txt # generate tables with index and not used… Continue reading Identifying multiple unused indexes in DB2 automatically