Research On Oracle Database Disaster Technology

Along with the fast development of business enterprise, more and more dependence to the apply system, it need to apply system provide usable and dependable system. According to this kind of need, then build up disaster system to satisfy the demand that the business production. The disaster system means to be the system that been separated farther land, so build up two sets or several IT systems of function homologies, mutual systems can carry on healthy appearance surveillance and function to cut over and be a system stop because of accident (like a fire, earthquake...etc.) work, the whole applied system can cut over another palace, make that system function be able to continue normal work. The redundancy will bring additional funds devotion, but for decisive application, it is very necessary. Neither regardless artificial disaster nor a natural disaster, disaster can't avoid. This mean must have a safety system can as far as possible reduce time of instauration to at least.The research purpose of this article is for solving to existent relatively fall behind of method. First the present condition of analytical database application, EXP technique and the backup native data of the Rman technique of adoption database, usage log miner instauration the customer modify of data. Build up the environment that the native application permits a disaster on this foundation, then OCM, Oracle, and establish a database, install node; the constitution permits the environment of disaster system. Then, test a great deal of circumstance that the data throws to lose. Use IMP, Rman to carry on instauration first, the time of result manifestation is longer, to continuous application influenced. Secondly use a Log miner instauration data, result time that elucidation need be shorter, but can carry on instauration to a part of customer's modification. Finally adopt a Rac technique to carry on a data test. Prove as a result that the Rac technique can without a break provide a service by assurance database system and even gather to have in the cluster of the node appear breakdown, as long as gather to exist 1 in the cluster can use node, the customer carry of the applied procedure be uninfluenced, and link to break down node of customer's carry will be transferred valid node automatically up.Through above-mentioned practice process, prove the Rac technique can prevent single node database from fail of circumstance, can attain the purpose that the anticipant native database permits a disaster application.