Database table backup method and device

Abstract

The invention provides a database table backup method and device. The database table backup method comprises the flowing steps of (1) obtaining a backup table inventory and generating into a backup table inventory file according to a backup mode; (2) generating into backup tasks according to backup parameter information; (3) generating into an operational control file according to information of the backup tasks; (4) reading the operational control file, judging operational states of the backup tasks and carrying out a step (51) if the operational state is that the backup is unfinished; (51) submitting the backup tasks and starting backing up; (6) performing monitoring scanning on the operational states of the backup tasks until all backup tasks achieve backup. The database table backup method has the advantages of greatly shortening the database backup time and being safe and efficient; enabling interfaces to be integrated and being capable of timely displaying the backup operational states and faults such as abnormal termination; accordingly improving the backup operating speed, speeding up fault response speed and reducing backup operational risks.

Description

technical field [0001] The invention relates to a method and a device for backing up a database table in a database, in particular to a method and a device for automatically backing up a database table in batches. Background technique [0002] Before the core banking system processes data in batches, in order to ensure the recoverability of the system and provide a rollback mechanism after batch operation errors, it is necessary to back up all the files and database tables of the system, and to ensure normal business hours, batch The processing time needs to be compressed as much as possible. Therefore, under certain resource conditions, it is necessary to shorten the backup time as much as possible. [0003] In the process of running backups in batches, most systems only manually prepare all the backup jobs for backup, and due to the limitation of system resources and lack of automation, it is necessary to manually check and process the backup process all the time. [0004...

AI Technical Summary

Problems solved by technology

[0010] It is difficult to collect backup information, which is not conducive to data statistics, wrong judgment and processing;

[0011] Poor portability, a core banking system may have multiple environments with different functions, such as disaster recovery environment, drill environment, etc. Their parameters are different, the version is different, the backup content may also be different, and the backup job must be restarted. to develop

Images