A method for automatic operation and maintenance of database

Abstract

The invention discloses a method for maintaining automatic operation of a database. The method comprises the following steps: a) arranging a monitor server, a Web terminal and at least one monitored terminal, and performing monitoring configuration on the monitored terminal in the Web terminal, wherein the monitored terminal comprises a database server host and network equipment; b) collecting data from the database server host of the monitored terminal in a way of installing Agent, and collecting the data from the network equipment of the monitored terminal through an SNMP way; c) collecting the data transmitted through the SNMP and the Agent in a B / S mode by the monitor server and the monitored terminal, and displaying monitoring results on the Web terminal in a B / S mode by the monitor server and the Web terminal. According to the method, the monitoring configuration and the display of the monitor results are performed on the monitored terminal by the Web terminal, so that scripts can be flexibly applied to early warning and processing various database scenes, the manual operations are reduced greatly, and the work efficiency is improved.

Description

technical field [0001] The invention relates to a database processing method, in particular to a database automatic operation and maintenance method. Background technique [0002] Modern enterprises need various IT systems to support the efficient operation of enterprises; even in some enterprises, IT systems have become the key to business operations. In these IT systems, the database plays a very important role in the system, so the operation and maintenance of the database has become one of the concerns of enterprises. [0003] In the existing database market, Oracle database has the largest share. On July 8, 2013, Oracle China announced that the new generation of Oracle Database 12c was officially launched, which indicated that the development of Oracle Database is becoming more and more intelligent and automated. How to make full use of Oracle database technology to achieve automatic operation and maintenance has become the focus of enterprise system operation and mai...

AI Technical Summary

Problems solved by technology

[0015] For the above three automation methods of the Oracle database, it can basically meet the daily operation and maintenance of the database, and in general, the system can run normally and smoothly after using these three automation methods, but the system is for people to use , when some database problems are artificially caused, these automated means may not guarantee the normal operation of the system

To give a simple example, in a personnel database, when personnel A needs to modify the salary of an employee, there are other things interfering in the middle, and he forgot to submit it. At the same time, personnel B does not know whether personnel A has modified , and do the same thing. At this time, personnel personnel B cannot complete the salary modification of an employee. This is actually a common lock problem in the database. Faced with this problem, the above three automated methods cannot solve this problem.

Images