Working method of database integrated supervision platform

Abstract

The invention relates to database cluster management technologies of power enterprises, in particular to a process management method for database cluster backups of the power enterprises. An integrated database supervisory platform mainly comprises a platform basic information management subsystem, a database cluster information acquisition subsystem and a backup task management subsystem. The platform basic information management subsystem is mainly used for maintaining and managing platform data. The database cluster information acquisition subsystem is mainly used for acquiring, maintaining and managing master catalogues of online application systems in clusters and background database information. The backup task management subsystem is mainly used for formulating backup strategies, managing backup scripts, remote backup task scheduling and the like. The process management method caters to operators of the power enterprises and enables the operators to be capable of delicately managing backup tasks of the application system of the database.

Description

technical field [0001] The invention relates to a database cluster management technology for electric power enterprises, in particular to an electric power enterprise-oriented database integrated supervision platform and its working method, and a business control method for backup task process management based on the platform. Background technique [0002] With the deepening of electric power informatization, enterprises have higher and higher requirements for information system security operation and maintenance management. Each power supply company is currently running nearly a hundred databases of various application systems (including different types such as DB2, Oracle, SQLServer, etc.), among the distributed server clusters, the management of application databases has remained in a relatively extensive manual management stage for a long time, and management efficiency and management Levels are increasingly unable to meet current requirements: [0003] 1. Manual script...

AI Technical Summary

Problems solved by technology

Each power supply company is currently running nearly a hundred databases of various application systems (including different types such as DB2, Oracle, SQLServer, etc.), among the distributed server clusters, the management of application databases has remained in a relatively extensive manual management stage for a long time, and management efficiency and management Levels are increasingly unable to meet current requirements:

[0003] 1. Manual script command backup method, the operator needs to be familiar with Windows and Linux server backup scripts, which has high requirements for operators, making it impossible for ordinary business personnel to back up the system database;

[0004] 2. There are a huge number of scripts for database backup of nearly a hundred application systems, and the maintenance and management of these scripts is complex and error-prone, resulting in the failure of the backup task;

[0005] 3. Due to the huge number of backup tasks and different backup times, it is difficult to perform manual backups on time and in an orderly manner, resulting in excessive load on the server, which eventually leads to the failure of the backup task

Images