Research And Design Of Database System High Availability Architecture Based On Oracle Database 10g

With development of information technology and the increasingly fierce competition among enterprises, IT systems are used by more and more companies in handling routine business in order to improve their economic benefits and competitive strength. The more that the enterprises depend on IT systems, the higher level of data security and system availability is required. That means the high availability of IT systems turns out to be the vitals of enterprises. Meanwhile, high availability and disaster tolerance of the database system, the core of IT system, play a vital role in maintaining the business continuity and data integrity of the enterprises. It constitutes the cornerstone of the enterprises'normal operation.For example, a company specializes in stevedoring of containers and needs its key business system to run 7*24 hours uninterruptedly due to the unique feature of dock operation. If the key system collapses, all the stevedoring operation will stop, which will result in a multimillion or even tens of millions of economic loss. More seriously, the company will suffer a credit loss, which will finally leads to a loss of clients as they refuses to call at the dock. This kind of situation proposes a higher requirement for the availability of the database system as the core and base of the business system.The purpose of this paper is to design a feasible, efficient and cost-effective high availability frame of Oracle Database 10g for enterprises to ensure the normal operation of their database systems. Upon the analysis of user needs, the research of current status of database systems used by most enterprises, and the study of high availability resolutions provided by Oracle 10g and other relevant products, the author analyses the factors that affect the system availability and approaches to improve it, investigates the guidelines and principles to design high availability frame resolutions, and finally develop a high availability frame of Oracle 10g. The resolution integrates a series of high availability technologies like Real Application Cluster, Oracle Data Guard, and RMAN, etc. Furthermore, a series of tests were conducted under such a frame environment, including the complete and incomplete recovery test of media using RMAN, the test on recovery of the incorrectly revised or deleted data using Flashback, Oracle RAC failover test, and Oracle Data Guard Switchover and failover test, etc. All these tests lead to the conclusion that this high availability frame resolution can deal with multiple faults in very short time and recover the data and database service effectively and rapidly.The high availability frame resolution of Oracle lOg as described in this paper has been put into use in the above mentioned company and proved to be a very good practice.