Gurpreet Singh, Sikander Singh
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.
English 
Chinese 
Russian 
German 
French 
Japanese 
Portuguese 
Hindi