MAINTAINING CLIENT CONNECTIVITY AND ZERO FAILOVER USING ORACLE DATAGUARD GRID COMPUTING
Gurpreet Singh*1, Sikander Singh2
University College OF Engineering, Punjabi University, Patiala, Punjab, India
|Corresponding Author: Gurpreet Singh, E-mail: [email protected]|
|Related article at Pubmed, Scholar Google|
The Data Guard is best management monitoring tool provided by ORACLE to reduce the failover time when Primary system goes down. Data Guard helps in transferring the redo data files to the Standby site. Data Guard maintains Standby databases as transactional consistent copies of production database. When the Primary system fails due to some error the Data Guard can switch to any Standby database. The tight integration of Oracle Data Guard with Oracle Database provides a unique level of data protection that is impossible to achieve with any other solution. In this paper we try to achieve zero down time and maintain user connectivity to Primary system active by using Data Guard Observer. Our approach is based on changing the parameters of TNS file and prevent the users to reconnect to Primary database again and again after Primary system failure. Keywords: Switchover, Failover, Logical Standby Database, Data Guard Broker, Log Shipping.