Method and device for backing up database logs

Abstract

The application aims to provide a method and device for backing up database logs. The method comprises the specific steps: acquiring a list of database log files; placing the list of log files in a transmission queue, wherein logs in the list of files are arranged according to a preset log sequence; acquiring log files corresponding to the list of log files; transmitting the log files to a corresponding server according to the log sequence. Compared with the prior art, the application enables logs in an ASM system in an RAC (real application cluster) environment to be automatically backed up for the purpose of orderly transmission of complete log files by: acquiring the list of database log files, ranking and placing the files in the transmission queue, and transmitting the log files to the corresponding server according to the log sequence of the transmission queue after the log files corresponding to the list of log files are acquired; labor cost is reduced, backup efficiency is improved, and original settings in a database by a user are unaffected.

Description

technical field [0001] The present application relates to the computer field, in particular to a technology for database log backup. Background technique [0002] With the advent of the era of big data, data security issues have been paid more and more attention. Backing up archived logs in the database is an effective means to protect data security. In the existing technology, the database often adopts the RAC (Real Application Clusters, real-time application cluster) environment Ensure its high availability, and in the RAC environment, logs are usually stored in the ASM (Automatic Storage Management, automatic storage management) file system. In this file system, data needs to be read by tools, and the method of real-time monitoring of file generation and backup cannot be carried out. Therefore, only manual backup can be used when archiving log backup, or automatic backup can be performed with the help of tools provided by ASM. However, manual backup has problems such as ...

AI Technical Summary

Problems solved by technology

[0002] With the advent of the era of big data, data security issues have been paid more and more attention. Backing up archived logs in the database is an effective means to protect data security. In the existing technology, the database often adopts the RAC (Real Application Clusters, real-time application cluster) environment Ensure its high availability, and in the RAC environment, logs are usually stored in the ASM (Automatic Storage Management, automatic storage management) file system. In this file system, data needs to be read by tools, and the method of real-time monitoring of file generation and backup cannot be carried out. Therefore, only manual backup can be used when archiving log backup, or automatic backup can be performed with the help of tools provided by ASM

However, manual backup has problems such as uncertain backup cycle and low efficiency, automatic backup with tools has repeated backup, will be interfered by the external environment, and backup will affect user settings, etc.

Images