Database Design Of China Geological Library United Catalog Based On Oracle Rac

Library united Catalog System can help establish the China Geological Library Geology Library Catalogue Center's resource sharing system, to achieve the automation system and the joint museum united catalog system completely seamless connection to the most convenient way of division of labor, to achieve data sharing, to the rational distribution of resources, rational utilization purposes. The topics to Library united Catalog Database as the background, the united catalog system uses C/S and B/S and the pattern connect to the database, the client user requirements into the system at any time with queries and cataloging, for reliability and database high performance requirements.In this paper, Oracle RAC solution, using Oracle lOg RAC's Failover and Load Balance properties, establishment of a united catalog database colony environment, to achieve high availability requirements of customers 7X24. In the paper introduces the topic of the source, the need to establish a united catalog system and the issues the task, and Oracle RAC technology, history, and at this stage in the application status in the industry to explain the basic concept of the RAC, classification and structural system, the basic principle and so on. Through the China Geological Library united Catalog database running status of the collection and analysis, clearly the user needs. The needs of users of the united catalog compare Oracle rac and host HA, Data Guard pros and cons of such programs is proposed Oracle rac solution. According to the official Oracle implementation requirements given colony, the united library catalog database from the actual situation, complete the Oracle 10g RAC database shared memory, file storage and network settings such as planning and installation for system deployment. Described in the text-based service's server-side TAF configuration method, simulation database downtime on the service-based model has been tested fail to realize automatic without any user intervention fail to meet the high availability requirements. By configuring client-side and server-side load balancing strategy hybrid to simulate a number of user connection requests, the load balancing test, the database obtained long-running case, the mixed-mode load balancing obvious conclusion. In the final paper work on the subject of a summary, Oracle RAC is an instance of class redundancy protection, not on the store level, the network-level fault protection, which is the Oracle RAC solutions inadequate and Oracle can Data Guard to combine in order to achieve higher availability.Through the system of trial operation, the actual results to meet the user database with high availability and load balancing requirements. Database running within a year than planned maintenance downtime, no service disruption occurred in the phenomenon, providing a 7X24 hours of reliable service; by observing the server CPU utilization, process distribution and the listener log and found that the connection request is basically in equilibrium, improved server utilization and database performance.