CN113806138A

CN113806138A - Backup recovery detection method and device for database, electronic equipment and storage medium

Info

Publication number: CN113806138A
Application number: CN202110163863.0A
Authority: CN
Inventors: 张立
Original assignee: Jingdong Technology Holding Co Ltd
Current assignee: Jingdong Technology Holding Co Ltd
Priority date: 2021-02-05
Filing date: 2021-02-05
Publication date: 2021-12-17

Abstract

The application provides a database recovery detection method, a database recovery detection device and electronic equipment, wherein the recovery detection method comprises the steps of obtaining first attribute information of a backup file needing backup recovery; acquiring second attribute information of candidate database instances which can be used for backup recovery; matching the first attribute information and the second attribute information, and determining a target database instance from the candidate database instances; and performing recovery detection on the backup file based on the target database instance. According to the method and the device, the real-time availability of the backup file is checked, the backup file can provide correct and effective backup data in backup recovery, the problems that the backup file is damaged and invalid and the database cannot be started due to no real-time test are avoided, the alarm and the processing are not timely, the availability of the backup file is enhanced, and the success rate of the backup recovery of the database is improved.

Description

Backup recovery detection method and device for database, electronic equipment and storage medium

Technical Field

The present application relates to the field of computer technologies, and in particular, to a method and an apparatus for detecting backup and recovery of a database, an electronic device, and a storage medium.

Background

With the extensive application of database technologies in various industries and various fields, important data may be damaged and lost due to human misoperation, malicious damage, system instability, damage to storage media and the like in the database application process, and therefore, the problem to be solved is to recover damaged or lost data.

In the related art, a real-time validity test cannot be performed on a backup file of file data to be restored, so that whether the backup file can provide a correct and effective data source when the backup file needs to be restored cannot be determined in time.

Disclosure of Invention

The present application is directed to solving, at least to some extent, one of the technical problems in the related art.

Therefore, the first aspect of the present application provides a method for detecting backup and recovery of a database.

The second aspect of the present application further provides a device for detecting backup and recovery of a database.

A third aspect of the present application provides an electronic device.

A fourth aspect of the present application is directed to a computer-readable storage medium.

A fifth aspect of the present application proposes a computer program product.

A first aspect of the present application provides a method for detecting backup recovery of a database, including obtaining first attribute information of a backup file that needs to be backed up and recovered; acquiring second attribute information of candidate database instances which can be used for backup recovery; matching the first attribute information and the second attribute information, and determining a target database instance from the candidate database instances; and performing recovery detection on the backup file based on the target database instance.

In addition, the method for detecting backup and recovery of a database provided by the first aspect of the present application may further have the following additional technical features:

according to an embodiment of the present application, the detecting the recovery of the backup file based on the target database instance includes: loading the backup file to the target database instance, calling a data recovery script program, and executing a data recovery flow; and responding to the end of the data recovery process, and detecting the loaded target database instance.

According to an embodiment of the present application, after detecting the loaded target database instance, the method further includes: and monitoring the detection process, and restoring the target database instance to an initial state in response to the monitoring that the detection is finished.

According to an embodiment of the present application, the method for detecting backup and recovery of a database further includes: and responding to the detection end, generating a detected mark for the backup file, and marking the backup file.

According to an embodiment of the present application, the method for detecting backup and recovery of a database further includes: and generating reminding information of the backup file in response to the detection result indicating that the backup file fails to be restored.

According to an embodiment of the present application, before performing recovery detection on the backup file based on the target database instance, the method further includes: acquiring a storage path of the backup file from the first attribute information; and acquiring the backup file from a backup file system based on the storage path.

According to an embodiment of the present application, the obtaining second attribute information of the candidate database instance available for backup restoration includes: sending a query request to a server where the candidate database instances are located, wherein the candidate database instances are stored in a resource pool of the server; receiving the second attribute information of the server.

In order to implement the method for detecting backup recovery of a database according to the first aspect, a second aspect of the present application further provides a device for detecting backup recovery of a database, including a first obtaining module, configured to obtain first attribute information of a backup file that needs to be backed up and recovered; the second acquisition module is used for acquiring second attribute information of the candidate database instances which can be used for backup recovery; the matching module is used for matching the first attribute information and the second attribute information and determining a target database instance from the candidate database instances; and the recovery detection module is used for carrying out recovery detection on the backup file based on the target database instance.

The backup restoration detection apparatus for a database according to the second aspect of the present application may further have the following additional technical features:

according to an embodiment of the application, the recovery detection module includes: the data recovery unit is used for loading the backup file to the target database instance, calling a data recovery script program and executing a data recovery flow; and the detection unit is used for responding to the end of the data recovery process and detecting the loaded target database instance.

According to an embodiment of the present application, the recovery detection module further includes: and the initialization unit is used for monitoring the detection process and restoring the target database instance to an initial state in response to the monitoring that the detection is finished.

According to an embodiment of the present application, the recovery detection module further includes: and the detection marking unit is used for responding to the detection end, generating a detected mark for the backup file and marking the backup file.

According to an embodiment of the present application, the recovery detection module further includes: and the reminding unit is used for responding to the detection result to indicate that the backup file fails to be restored, and then generating reminding information of the backup file.

According to an embodiment of the present application, the apparatus for detecting backup and recovery of a database further includes: and the file acquisition module is used for acquiring a storage path of the backup file from the first attribute information and acquiring the backup file from a backup file system based on the storage path.

According to an embodiment of the application, the second obtaining module includes: a request sending unit, configured to send a query request to a server where the candidate database instance is located, where the candidate database instance is stored in a resource pool of the server; a receiving unit, configured to receive the second attribute information sent by the server. According to one embodiment of the present application,

to achieve the above object, a third aspect of the present application provides an electronic device, comprising: at least one processor; and a memory communicatively coupled to the at least one processor; wherein the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to execute the method for detecting backup restoration of a database according to the first aspect.

A fourth aspect of the present application proposes a computer-readable storage medium, wherein the computer instructions are configured to cause the computer to execute the backup restoration detection method for a database as proposed in the first aspect.

A fifth aspect of the present application proposes a computer program product comprising a computer program which, when executed by a processor, implements the backup restoration detection method for a database proposed according to the first aspect described above.

According to the data backup recovery detection method, the data backup recovery detection device and the electronic equipment, after the backup recovery requirement is determined, the first attribute information of the backup file and the second attribute information of the candidate database instance are obtained, the first attribute information and the second attribute information are matched, the target database instance is determined, the backup recovery operation of the backup file is completed, and then the recovery detection of the backup file is completed. According to the method and the device, the real-time availability of the backup file is checked, the backup file can provide correct and effective backup data in backup recovery, the problems that the backup file is damaged and invalid and the database cannot be started due to no real-time test are avoided, the alarm and the processing are not timely, the availability of the backup file is enhanced, and the success rate of the backup recovery of the database is improved.

It should be understood that the description herein is not intended to identify key or critical features of the embodiments of the disclosure, nor is it intended to be used to limit the scope of the disclosure. Other features of the present application will become apparent from the following description.

Drawings

The foregoing and/or additional aspects and advantages of the present application will become apparent and readily appreciated from the following description of the embodiments, taken in conjunction with the accompanying drawings of which:

fig. 1 is a schematic flowchart illustrating a method for detecting backup restoration of a database according to an embodiment of the present application;

FIG. 2 is a schematic flowchart illustrating a method for detecting backup restoration of a database according to another embodiment of the present application;

FIG. 3 is a schematic flowchart illustrating a method for detecting backup restoration of a database according to another embodiment of the present application;

FIG. 4 is a schematic flowchart of a database backup recovery detection method according to another embodiment of the present application;

FIG. 5 is a block diagram of a database backup recovery detection system according to another embodiment of the present application;

FIG. 6 is a schematic structural diagram of a backup recovery detection apparatus for a database according to an embodiment of the present application;

FIG. 7 is a schematic structural diagram of a backup recovery detection apparatus for a database according to another embodiment of the present application;

fig. 8 is a schematic structural diagram of an electronic device according to an embodiment of the present application.

Detailed Description

Reference will now be made in detail to embodiments of the present application, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to the same or similar elements or elements having the same or similar function throughout. The embodiments described below with reference to the drawings are exemplary and intended to be used for explaining the present application and should not be construed as limiting the present application.

A backup restoration detection method and apparatus for a database, an electronic device, and a storage medium according to embodiments of the present application are described below with reference to the accompanying drawings.

Fig. 1 is a schematic flowchart of a method for detecting backup and recovery of a database according to an embodiment of the present application, where as shown in fig. 1, the method for detecting backup and recovery of a database includes:

s101, first attribute information of a backup file needing backup and recovery is acquired.

The backup file is a file copied to the storage medium for backup, and can provide backup for files stored in the system or the medium when system hardware or the storage medium is in failure or damaged, so as to help to protect file data, and recover the stored backup file by technical means.

In the embodiment of the application, the backup file is a file generated by the instance during the operation, and can be used for restoring the instance. Alternatively, the backup files are generally stored in the backup file system, and the first attribute information of the backup files is stored in the set location, and when a recovery check needs to be performed on one of the backup files, the first attribute information of the backup file may be acquired from the set location in advance.

The first attribute information of the backup file includes, but is not limited to, the file storage name, the file storage path, the file size, the file version, the format, the storage type, and other related attribute information of the backup file.

Optionally, the backup recovery detection may be started for the backup files in a time sequence, the backup recovery detection task is suspended in the task queue according to the time of generating the backup files, the first attribute information of the backup files required for the backup recovery is sequentially acquired according to the sequence of the backup recovery detection task, and the backup recovery detection task is started.

Optionally, the user may configure a backup file recovery detection order according to the importance or urgency of the backup file, hang the backup recovery detection task in the task queue according to the order configured by the user, sequentially acquire the first attribute information of the backup file required for backup recovery according to the order in the task queue, start the backup recovery detection task, and configure the task order by the user, so that the important backup file completes the recovery test in advance.

S102, second attribute information of the candidate database instances which can be used for backup and recovery is obtained.

In order to perform backup recovery detection on a backup file to determine the availability of the backup file, in the embodiment of the present application, a blank database instance may be prepared in advance, the blank database instance is used as a candidate database instance, and recovery detection is performed on the backup file through the candidate database instance to verify the availability of the backup file, so that it can be ensured that when the backup file is actually used for backup recovery, recovery of a real database instance can be completed.

Optionally, the candidate database instance is generally stored in a resource pool of the server, the second attribute information of the candidate database instance is stored in the set position at the same time, and when the recovery requirement of the backup file is determined, the second attribute information of the candidate database instance may be obtained from the set position first.

The candidate database instance has attribute information, including but not limited to file version, storage format, belonging system, Internet Protocol (IP) information of the database instance, port information, and other related information.

S103, matching the first attribute information and the second attribute information, and determining a target database instance from the candidate database instances.

The first attribute information and the second attribute information comprise storage formats, affiliated systems, version numbers and the like, different backup files have different first attribute information, and meanwhile, different candidate database instances have different second attribute information. In the related art, there is a problem that different storage formats, different systems or versions are incompatible with each other.

Optionally, the first attribute information and the second attribute information need to be completely matched, so that the target database instance can be determined.

Optionally, in the first attribute information and the second attribute information, the corresponding attribute information has a relationship that the second attribute information is upper attribute information and the first attribute information is lower attribute information, and meanwhile, the upper attribute information has a function of being compatible with the lower attribute information, and at this time, based on a matching result that the attribute information of the first attribute information and the second attribute information can be compatible, the target database instance can also be determined.

In the embodiment of the application, the acquired first attribute information and the acquired second attribute information are matched, and then the target database instance is determined.

For example, the file storage Format in the first attribute information of the backup file is a Portable Document Format (PDF), and the first attribute information is matched with the second attribute information to screen out at least one candidate database instance whose second attribute information includes attribute information of which the file storage Format is a PDF Format, so as to determine the target database instance.

For another example, the version number in the first attribute information of the backup file is 2.0, and the version number is matched with the second attribute information, so as to screen out at least one candidate database instance of which the second attribute information contains attribute information with the version number of 2.0, and further determine the target database instance.

And S104, based on the target database example, carrying out recovery detection on the backup file.

In the embodiment of the application, the backup file can be restored through the target database instance, after the target database instance is determined, the server calls the backup file restoration script program of the database to start the restoration operation of the backup file, and after the backup file restoration operation is finished, the restored target database instance can be operated to provide services so as to perform restoration detection on the target database instance subjected to backup restoration through the backup file, and further determine whether the backup file is available.

According to the method for detecting the backup recovery of the database, after the backup recovery requirement is determined, the first attribute information of the backup file and the second attribute information of the candidate database instance are obtained, the first attribute information and the second attribute information are matched, the target database instance is determined, the backup recovery operation of the backup file is completed, and then the recovery detection of the backup file is completed. According to the method and the device, the real-time availability check of the backup files is realized, so that the backup files can provide correct and effective backup data in backup recovery, the alarms and the processing untimely of the problems of backup file damage, invalidation, database incapability of starting and the like caused by no real-time test are avoided, the availability of the backup files is enhanced, and the success rate of the backup recovery of the database is improved.

Fig. 2 is a schematic flowchart of a method for detecting backup and recovery of a database according to another embodiment of the present application, and as shown in fig. 2, the method for detecting backup and recovery of a database includes:

s201, first attribute information of a backup file needing backup and recovery is acquired.

S202, second attribute information of the candidate database instances which can be used for backup and recovery is obtained.

S203, matching the first attribute information and the second attribute information, and determining a target database instance from the candidate database instances.

The steps S201 to S203 can refer to the related details, and are not described herein again.

S204, loading the backup file to the target database instance, calling a data recovery script program, and executing a data recovery process.

Optionally, the storage path, the storage name, and other related information of the backup file included in the first attribute information of the backup file may be based on the storage location of the backup file, and further obtain the required backup file from the backup file system according to the storage path, the storage name, and other related information. In the embodiment of the application, after the backup file recovery task is obtained, the backup file is queried from the backup file system according to the storage path in the first attribute information of the backup file.

In order to perform recovery detection on the backup file, after the backup file is acquired, the backup file needs to be loaded into the determined target database instance, a preset data recovery script program is called, the data recovery script program starts recovery operation of the backup file, and a data recovery flow is executed.

In the implementation, the file sizes, file types, and other related information of different backup files are different, and therefore, the backup recovery times corresponding to different backup files are also different. Optionally, a backup restore time may be anticipated based on the size of the backup file and the backup restore duration may be reminded or exposed.

And S205, responding to the end of the data recovery process, and detecting the loaded target database instance.

In the embodiment of the application, the progress of the data recovery process can be monitored, and when the data recovery process is finished, the target database instance after data recovery can be detected, optionally, the target database instance after recovery can be started, and whether the service function of the target database instance after recovery can be normally started and used is detected.

Optionally, in response to the detection ending, a detected mark is generated for the backup file and the backup file is marked.

And starting the restored target database instance, and when the function of the target database instance can be normally started or used, judging that the restoration of the backup file is successful, the backup file is available, and abnormal conditions such as damage do not exist.

In the embodiment of the application, the detected mark is carried out on the backup file based on the detection result of the backup file recovery detection. A backup file detection marker program may be written in the server, the backup file detection marker program may be started in response to a detection result of the backup file restoration detection, and the execution program may generate a detected marker and mark the detected marker on the backup file. Through the detected mark, the related information of the backup file in the backup recovery detection can be obtained, which may include, but is not limited to, the recovery duration of the backup file, whether the backup file is successfully recovered, the reason for the recovery failure of the backup file, and the like.

The information of the detected mark comprises a backup recovery detection result, and for the backup file with successful backup recovery, the detected backup file can be determined as the backup file passing availability detection, so that correct and effective backup data can be provided for backup recovery.

Optionally, in response to the detection result indicating that the backup file fails to be restored, generating a reminding message of the backup file.

And when the restored target database instance is operated and cannot be normally started or used, judging that the backup file restoration fails. In the embodiment of the application, based on the detection result of the backup file recovery failure, the backup file detection marking program is started, meanwhile, the reminding information of the backup file is generated, an information reminding alarm program can be written in the server, the information reminding alarm program is started in response to the detection result of the backup file recovery failure, and the execution program generates the reminding information of the backup file recovery failure and sends the reminding information to the staff.

An alarm reminding module can be arranged in the server, and the alarm reminding module is called in response to the generation of the recovery failure reminding information of the backup file and is sent to the staff in different modes, such as information of communication software, mails and the like.

The recovery failure reminding information of the backup file and the content of the detected mark of the backup file may include, but are not limited to, the name of the backup file, the time of the backup recovery, the reason of the backup recovery failure, and the like.

S206, monitoring the detection process, and restoring the target database instance to the initial state in response to the detection completion.

And responding to the generation and marking of the detected mark of the backup file or the generation and sending of the recovery failure reminding information of the backup file, and ending the backup recovery detection process. In the embodiment of the application, after the detection process is finished, the target database embodiment after backup recovery is initialized, so that the target database embodiment after backup recovery is recovered to an initial state to wait for the initiation of a backup file recovery task of the next round.

According to the backup recovery detection method for the database, after the backup recovery requirement is determined, first attribute information of a backup file and second attribute information of a candidate database instance are obtained, and the first attribute information and the second attribute information are matched to determine the target database embodiment. And acquiring the backup file based on the first attribute information, loading the backup file into the target database instance, and starting the backup recovery process. And after the backup recovery process is finished, starting a backup file detection process, responding to the result of the detection process, and performing detected marks on the backup files, wherein the detected marks comprise the backup recovery result, time and other related information of the backup files. And generating reminding information of the recovery failure of the backup file in response to the detection failure result. And after the detection is finished, restoring the target database embodiment after the backup recovery to the initialization state so as to wait for the initiation of the backup recovery task of the next round. According to the method and the device, the backup file is marked and reminded according to the recovery detection result of the target database embodiment after backup recovery, so that real-time availability check of the backup file is realized, the backup file can provide correct and effective backup data in the backup recovery, the warning and processing untimely problems of backup file damage, invalidation, database startup failure and the like caused by no real-time test are avoided, the availability of the backup file is enhanced, and the success rate of the backup recovery of the database is improved.

To better understand the above embodiments, as shown in fig. 3, fig. 3 is a schematic flowchart of a backup recovery detection method for a database according to another embodiment of the present application, where the backup recovery detection method for the database includes:

s301, a storage path of the backup file is obtained from the first attribute information.

The backup file has attribute information including, but not limited to, a file name, a storage type, a storage path, a file profile, a backup date, a backup file size, etc. of the backup file. In the embodiment of the application, the attribute information of the backup file can be listed separately and stored in a set position, so as to generate the first attribute information of the backup file. After the backup file recovery request is determined, the storage path of the backup file can be acquired by inquiring the first attribute information of the backup file.

S302, based on the storage path, the backup file is obtained from the backup file system.

In the embodiment of the application, the backup file is acquired from the backup file system according to the acquired storage path of the backup file. For example, in the acquired first attribute information of the backup file, if the storage path of the backup file is in the folder B under the folder a, the server queries the folder a in the backup file system, then queries the folder B under the folder a, and further acquires the backup file.

The setting position of the first attribute information storage of the backup file and the backup file system of the backup file storage are respectively in different storage positions.

According to the backup recovery detection method for the database, the storage path of the backup file is obtained through the first attribute of the backup file, and the backup file is obtained from the backup file system based on the storage path. According to the method and the device, the backup file is acquired in the backup file system based on the storage path in the first attribute information, so that the time for inquiring and acquiring the backup file in the backup file system is shortened, the recovery time of the backup file is shortened, and the recovery and recovery detection efficiency of the backup file in the database is improved.

Fig. 4 is a schematic flowchart of a method for detecting backup and recovery of a database according to another embodiment of the present application, and as shown in fig. 4, the method for detecting backup and recovery of a database includes:

s401, sending a query request to a server where the candidate database instance is located, wherein the candidate database instance is stored in a resource pool of the server.

In a server for providing file backup and restoring backup file service, a resource pool for storing database instances is set, and the resource pool comprises all candidate database instances capable of providing backup file restoring service.

In the embodiment of the application, after first attribute information of a backup file is acquired, a query request acquired by second attribute information is sent to a server where a resource pool is located, second attribute information of a database instance is stored in a set position, after the query request is acquired, the second attribute information of the database instance is queried in the set storage position, at least one blank database instance which can provide backup file recovery service and does not execute a backup file recovery task is screened out to serve as a candidate database instance, and meanwhile, the second attribute information of the candidate database instance is acquired.

S402, receiving the second attribute information sent by the server.

In the embodiment of the application, second attribute information of the candidate database instance sent by the server is received, where the second attribute information includes, but is not limited to, version information, file type, system information, and the like of the candidate database instance.

According to the backup recovery detection method for the database, the candidate database instance is obtained by sending the query request to the server, and then the second attribute information sent by the server is obtained. In the method and the device, the candidate database instances are screened out by inquiring the second attribute information of the set position, the second attribute information of the candidate database instances is obtained at the same time, the obtaining process is simple, the screening duration caused by directly inquiring and screening in the resource pool is avoided from being too long, the obtaining duration of the second attribute information is shortened, and the overall efficiency of backup file recovery detection is improved.

To better understand the backup recovery detection method for a database provided in the foregoing embodiment, with reference to fig. 5, as shown in fig. 5, fig. 5 is a schematic structural diagram of a database recovery detection system provided in another embodiment of the present application, where the backup recovery detection system for a database includes: a scheduling module 52, a metadata module 51, a backup file system 53, and a resource pool 54. Where the resource pool 54 stores candidate database instances 55. The backup recovery detection system of the database is used for executing the backup recovery detection method of the database proposed by the above embodiment.

The scheduling module 52 obtains first attribute information of the backup file from the metadata module 51 according to the query request, obtains second attribute information of the candidate database instance 55 from the resource pool 54, matches the first attribute information with the second attribute information, and obtains the target database instance. According to the acquired first attribute information of the backup file, the scheduling module 52 acquires the backup file from the backup file system 53, loads the backup file into the target database instance, and starts a backup file recovery process.

After the backup file recovery process is finished, the scheduling module 52 starts the recovered target database instance to start the backup recovery detection process. After the recovery detection process is finished, in response to the detection result of successful recovery detection, the backup file is subjected to detection marking, and the detection result of successful detection is sent to the metadata module 51 and recorded in the first attribute information of the backup file. And responding to the detection result of the recovery detection failure, producing the reminding information of the recovery failure of the backup file, and reminding workers.

After the detection result processing is finished, the scheduling module 52 restores the target database instance after the backup restoration to the initial state to wait for the backup file restoration task of the next round to be started.

According to the method and the device, the real-time availability of the backup file is checked, the backup file can provide correct and effective backup data in backup recovery, the problems that the backup file is damaged and invalid and the database cannot be started due to no real-time test are avoided, the alarm and the processing are not timely, the availability of the backup file is enhanced, and the success rate of the backup recovery of the database is improved.

Corresponding to the database recovery detection methods proposed in the foregoing embodiments, an embodiment of the present application further proposes a database recovery detection device, and since the database recovery detection device proposed in the embodiment of the present application corresponds to the database recovery detection methods proposed in the foregoing embodiments, the embodiments of the database recovery detection method are also applicable to the database recovery detection device proposed in the embodiment of the present application, and will not be described in detail in the following embodiments.

As shown in fig. 6, fig. 6 is a schematic structural diagram of a database backup recovery detection apparatus according to an embodiment of the present application, and the database backup recovery detection apparatus 600 includes a first obtaining module 61, a second obtaining module 62, a matching module 63, and a recovery detection module 64, where the first obtaining module 61, the second obtaining module 62, the matching module 63, and the recovery detection module 64

The first obtaining module 61 is configured to obtain first attribute information of a backup file that needs to be backed up and restored.

A second obtaining module 62, configured to obtain second attribute information of the candidate database instance that is available for backup restoration.

And the matching module 63 is configured to match the first attribute information and the second attribute information, and determine the target database instance from the candidate database instances.

And a recovery detection module 64, configured to perform recovery detection on the backup file based on the target database instance.

The device for detecting the backup recovery of the database acquires the first attribute information of the backup file and the second attribute information of the candidate database instance after determining the backup recovery requirement, matches the first attribute information with the second attribute information, determines the target database instance, completes the backup recovery operation of the backup file, and further completes the recovery detection of the backup file. According to the method and the device, the real-time availability check of the backup files is realized, so that the backup files can provide correct and effective backup data in backup recovery, the warning and the untimely processing of the problems of backup file damage, invalidation, database incapability of starting and the like caused by no real-time test are avoided, and the success rate of the backup recovery of the database is improved.

Fig. 7 is a schematic structural diagram of a database backup recovery detection apparatus according to another embodiment of the present application, and as shown in fig. 7, a database recovery detection apparatus 700 includes a first obtaining module 71, a second obtaining module 72, a matching module 73, a recovery detection module 74, and a file obtaining module 75.

It should be noted that the first obtaining module 61, the second obtaining module 62, the matching module 63, and the recovery detecting module 64 have the same structure and function as the first obtaining module 71, the second obtaining module 72, the matching module 73, and the recovery detecting module 74.

The backup recovery detection apparatus for a database, provided by the embodiment of the present application, includes a recovery detection module 74:

the data recovery unit 741 is configured to load the backup file into the target database instance, call a data recovery script program, and perform a data recovery procedure;

a detecting unit 742, configured to detect the loaded target database instance in response to the end of the data recovery process.

The backup recovery detection apparatus for a database provided in the embodiment of the present application, the recovery detection module 74, further includes:

and an initialization unit 743, configured to monitor the detection process, and in response to the monitoring that the detection is finished, restore the target database instance to an initial state.

The database recovery detection device provided in the embodiment of the present application, the recovery detection module 74, further includes:

and a detection marking unit 744 for generating a detected mark for the backup file in response to the detection being finished, and marking the backup file.

a reminding unit 745, configured to generate reminding information of the backup file in response to the detection result indicating that the backup file fails to be restored.

The backup recovery detection apparatus for a database provided in the embodiment of the present application further includes a file obtaining module 75, where:

the file obtaining module 75 is configured to obtain a storage path of the backup file from the first attribute information, and obtain the backup file from the backup file system based on the storage path.

The backup recovery detection apparatus for a database provided in the embodiment of the present application, the second obtaining module 72, includes:

a request sending unit 721, configured to send a query request to a server where a candidate database instance is located, where the candidate database instance is stored in a resource pool of the server;

the receiving unit 722 is configured to receive the second attribute information sent by the server.

The device for detecting the backup recovery of the database acquires the first attribute information of the backup file and the second attribute information of the candidate database instance after determining the backup recovery requirement, matches the first attribute information with the second attribute information, determines the target database instance, acquires the backup file from the backup file system according to the first attribute information of the backup file, loads the backup file into the target database instance, and starts the backup file recovery. And after the backup file recovery is finished, starting the recovered target database example and starting a backup recovery test. And responding to the detection result of the backup file recovery detection, generating a detected mark, and recording relevant information such as whether the backup file recovery is successful or not. If the restored target database instance can be normally started and used, judging that the backup restoration test result is successful and the backup file is available, and feeding back the result of the backup file restoration detection to the first attribute of the backup file; and if the restored target database instance cannot be normally started or used, judging that the backup recovery test result is failure, and the backup file is abnormal, responding to the failure test result, generating a reminding message of the failure of the backup file recovery test, and sending the reminding message to a worker. And after the judgment and the processing of the detection result are finished, initializing the loaded target database instance to wait for the starting of the backup recovery task of the next round. According to the method and the device, the real-time availability of the backup file is checked, the backup file can provide correct and effective backup data in the backup recovery process, the alarms of the related problems of backup file damage, invalidation, database incapability of starting and the like caused by no real-time test and the untimely processing are avoided, and the success rate of the backup recovery of the database is improved.

To achieve the above embodiments, the present application also proposes an electronic device, a computer-readable storage medium, and a computer program product.

FIG. 8 shows a schematic block diagram of an example electronic device 800 that may be used to implement embodiments of the present application. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. The electronic device may also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices, and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be examples only, and are not meant to limit implementations of the present application that are described and/or claimed herein.

As shown in fig. 8, the apparatus 800 includes a memory 810, a processor 820 and a computer program stored in the memory 810 and executable on the processor 820, and when the processor 820 executes the program instructions, the backup recovery detection method for the database proposed in the above embodiment is implemented.

The electronic device provided in the embodiment of the application executes a computer program stored in the memory 810 through the processor 820, acquires first attribute information of a backup file and second attribute information of a candidate database instance after determining a backup recovery requirement, matches the first attribute information and the second attribute information, determines a target database instance, acquires the backup file from a backup file system according to the first attribute information of the backup file, loads the backup file into the target database instance, and starts the backup file recovery. And after the backup file recovery is finished, starting the recovered target database example and starting a backup recovery test. And responding to the detection result of the backup file recovery detection, generating a detected mark, and recording relevant information such as whether the backup file recovery is successful or not. If the restored target database instance can be normally started and used, judging that the backup restoration test result is successful and the backup file is available, and feeding back the result of the backup file restoration detection to the first attribute of the backup file; and if the restored target database instance cannot be normally started or used, judging that the backup recovery test result is failure, and the backup file is abnormal, responding to the failure test result, generating a reminding message of the failure of the backup file recovery test, and sending the reminding message to a worker. And after the judgment and the processing of the detection result are finished, initializing the loaded target database instance to wait for the starting of the backup recovery task of the next round. According to the method and the device, the real-time availability of the backup file is checked, the backup file can provide correct and effective backup data in the backup recovery process, the alarms of the related problems of backup file damage, invalidation, database incapability of starting and the like caused by no real-time test and the untimely processing are avoided, and the success rate of the backup recovery of the database is improved.

A computer-readable storage medium is provided, and stores thereon a computer program, which, when executed by the processor 820, implements the database backup recovery detection method provided in the foregoing embodiments.

The computer-readable storage medium of the embodiment of the application, by storing a computer program and being executed by a processor, executes the computer program stored in the memory 810 by the processor 820, after determining a backup recovery requirement, obtains first attribute information of a backup file and second attribute information of a candidate database instance, matches the first attribute information and the second attribute information, determines a target database instance, obtains the backup file from a backup file system according to the first attribute information of the backup file, loads the backup file into the target database instance, and starts the backup file recovery. And after the backup file recovery is finished, starting the recovered target database example and starting a backup recovery test. And responding to the detection result of the backup file recovery detection, generating a detected mark, and recording relevant information such as whether the backup file recovery is successful or not. If the restored target database instance can be normally started and used, judging that the backup restoration test result is successful and the backup file is available, and feeding back the result of the backup file restoration detection to the first attribute of the backup file; and if the restored target database instance cannot be normally started or used, judging that the backup recovery test result is failure, and the backup file is abnormal, responding to the failure test result, generating a reminding message of the failure of the backup file recovery test, and sending the reminding message to a worker. And after the judgment and the processing of the detection result are finished, initializing the loaded target database instance to wait for the starting of the backup recovery task of the next round. According to the method and the device, the real-time availability of the backup file is checked, the backup file can provide correct and effective backup data in the backup recovery process, the alarms of the related problems of backup file damage, invalidation, database incapability of starting and the like caused by no real-time test and the untimely processing are avoided, and the success rate of the backup recovery of the database is improved.

The computer program product provided by the embodiment of the present application includes a computer program, and when the computer program is executed by a processor, the method for detecting backup recovery of a database provided by the above embodiment is implemented.

Various implementations of the systems and techniques described here above may be implemented in digital electronic circuitry, integrated circuitry, Field Programmable Gate Arrays (FPGAs), Application Specific Integrated Circuits (ASICs), Application Specific Standard Products (ASSPs), system on a chip (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs that are executable and/or interpretable on a programmable system including at least one programmable processor, which may be special or general purpose, receiving data and instructions from, and transmitting data and instructions to, a storage system, at least one input device, and at least one output device.

Program code for implementing the methodologies themselves may be written in any combination of one or more programming languages. These program codes may be provided to a processor or controller of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the program codes, when executed by the processor or controller, cause the functions/operations specified in the flowchart and/or block diagram to be performed. The program code may execute entirely on the machine, partly on the machine, as a stand-alone software package partly on the machine and partly on a remote machine or entirely on the remote machine or server.

In the context of this application, a machine-readable medium may be a tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. The machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

To provide for interaction with a user, the systems and techniques described here can be implemented on a computer having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) by which a user can provide input to the computer. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic, speech, or tactile input.

The systems and techniques described here can be implemented in a computing system that includes a back-end component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such back-end, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), Wide Area Networks (WANs), the internet, and blockchain networks.

The computer system may include clients and servers. A client and server are generally remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The service end can be a cloud Server, also called a cloud computing Server or a cloud host, and is a host product in a cloud computing service system, so as to solve the defects of high management difficulty and weak service expansibility in the traditional physical host and VPS service (Virtual Private Server, or VPS for short). The server may also be a server of a distributed system, or a server incorporating a blockchain.

In the description herein, reference to the description of the term "one embodiment," "some embodiments," "an example," "a specific example," or "some examples," etc., means that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the application. In this specification, the schematic representations of the terms used above are not necessarily intended to refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples. Furthermore, various embodiments or examples and features of different embodiments or examples described in this specification can be combined and combined by one skilled in the art without contradiction.

Furthermore, the terms "first", "second" and "first" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one such feature. In the description of the present application, "plurality" means at least two, e.g., two, three, etc., unless specifically limited otherwise.

Any process or method descriptions in flow charts or otherwise described herein may be understood as representing modules, segments, or portions of code which include one or more executable instructions for implementing steps of a custom logic function or process, and alternate implementations are included within the scope of the preferred embodiment of the present application in which functions may be executed out of order from that shown or discussed, including substantially concurrently or in reverse order, depending on the functionality involved, as would be understood by those reasonably skilled in the art of the present application.

The logic and/or steps represented in the flowcharts or otherwise described herein, e.g., an ordered listing of executable instructions that can be considered to implement logical functions, can be embodied in any computer-readable medium for use by or in connection with an instruction execution system, apparatus, or device, such as a computer-based system, processor-containing system, or other system that can fetch the instructions from the instruction execution system, apparatus, or device and execute the instructions. For the purposes of this description, a "computer-readable medium" can be any means that can contain, store, communicate, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device. More specific examples (a non-exhaustive list) of the computer-readable medium would include the following: an electrical connection (electronic device) having one or more wires, a portable computer diskette (magnetic device), a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber device, and a portable compact disc read-only memory (CDROM). Additionally, the computer-readable medium could even be paper or another suitable medium upon which the program is printed, as the program can be electronically captured, via for instance optical scanning of the paper or other medium, then compiled, interpreted or otherwise processed in a suitable manner if necessary, and then stored in a computer memory.

It should be understood that portions of the present application may be implemented in hardware, software, firmware, or a combination thereof. In the above embodiments, the various steps or methods may be implemented in software or firmware stored in memory and executed by a suitable instruction execution system. If implemented in hardware, as in another embodiment, any one or combination of the following techniques, which are known in the art, may be used: a discrete logic circuit having a logic gate circuit for implementing a logic function on a data signal, an application specific integrated circuit having an appropriate combinational logic gate circuit, a Programmable Gate Array (PGA), a Field Programmable Gate Array (FPGA), or the like.

It will be understood by those skilled in the art that all or part of the steps carried by the method for implementing the above embodiments may be implemented by hardware related to instructions of a program, which may be stored in a computer readable storage medium, and when the program is executed, the program includes one or a combination of the steps of the method embodiments.

In addition, functional units in the embodiments of the present application may be integrated into one processing module, or each unit may exist alone physically, or two or more units are integrated into one module. The integrated module can be realized in a hardware mode, and can also be realized in a software functional module mode. The integrated module, if implemented in the form of a software functional module and sold or used as a stand-alone product, may also be stored in a computer readable storage medium.

The storage medium mentioned above may be a read-only memory, a magnetic or optical disk, etc. Although embodiments of the present application have been shown and described above, it is understood that the above embodiments are exemplary and should not be construed as limiting the present application, and that variations, modifications, substitutions and alterations may be made to the above embodiments by those of ordinary skill in the art within the scope of the present application.

It should be understood that various forms of the flows shown above may be used, with steps reordered, added, or deleted. For example, the steps described in the present application may be executed in parallel, sequentially, or in different orders, as long as the desired results of the technical solutions disclosed in the present application can be achieved, and the present invention is not limited herein.

The above-described embodiments should not be construed as limiting the scope of the present application. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions may be made in accordance with design requirements and other factors. Any modification, equivalent replacement, and improvement made within the spirit and principle of the present application shall be included in the protection scope of the present application.

Claims

1. A backup recovery detection method for a database is characterized by comprising the following steps:

acquiring first attribute information of a backup file needing backup and recovery;

acquiring second attribute information of candidate database instances which can be used for backup recovery;

matching the first attribute information and the second attribute information, and determining a target database instance from the candidate database instances;

and performing recovery detection on the backup file based on the target database instance.

2. The method for detecting backup restoration of a database according to claim 1, wherein the detecting restoration of the backup file based on the target database instance comprises:

loading the backup file to the target database instance, calling a data recovery script program, and executing a data recovery flow;

and responding to the end of the data recovery process, and detecting the loaded target database instance.

3. The method for detecting backup restoration of a database according to claim 2, wherein after detecting the loaded target database instance, the method further comprises:

and monitoring the detection process, and restoring the target database instance to an initial state in response to the monitoring that the detection is finished.

4. The method for detecting backup restoration of a database according to claim 2, further comprising:

and responding to the detection end, generating a detected mark for the backup file, and marking the backup file.

5. The method for detecting backup restoration of a database according to claim 2, further comprising:

and generating reminding information of the backup file in response to the detection result indicating that the backup file fails to be restored.

6. The method for detecting backup restoration of a database according to any one of claims 1-5, wherein before detecting restoration of the backup file based on the target database instance, the method further comprises:

acquiring a storage path of the backup file from the first attribute information;

and acquiring the backup file from a backup file system based on the storage path.

7. The method for detecting backup restoration of a database according to any one of claims 1 to 5, wherein the obtaining second attribute information of the candidate database instance available for backup restoration includes:

sending a query request to a server where the candidate database instances are located, wherein the candidate database instances are stored in a resource pool of the server;

and receiving the second attribute information sent by the server.

8. A backup recovery detection apparatus for a database, comprising:

the first acquisition module is used for acquiring first attribute information of a backup file needing backup and recovery;

the second acquisition module is used for acquiring second attribute information of the candidate database instances which can be used for backup recovery;

the matching module is used for matching the first attribute information and the second attribute information and determining a target database instance from the candidate database instances;

and the recovery detection module is used for carrying out recovery detection on the backup file based on the target database instance.

9. The apparatus for detecting backup restoration of a database according to claim 8, wherein the restoration detection module comprises:

the data recovery unit is used for loading the backup file to the target database instance, calling a data recovery script program and executing a data recovery flow;

and the detection unit is used for responding to the end of the data recovery process and detecting the loaded target database instance.

10. The apparatus for detecting backup restoration of a database according to claim 9, wherein the restoration detection module further comprises:

and the initialization unit is used for monitoring the detection process and restoring the target database instance to an initial state in response to the monitoring that the detection is finished.

11. The apparatus for detecting backup restoration of a database according to claim 9, wherein the restoration detection module further comprises:

and the detection marking unit is used for responding to the detection end, generating a detected mark for the backup file and marking the backup file.

12. The apparatus for detecting backup restoration of a database according to claim 9, wherein the restoration detection module further comprises:

and the reminding unit is used for responding to the detection result to indicate that the backup file fails to be restored, and then generating reminding information of the backup file.

13. The apparatus for detecting backup restoration of a database according to any one of claims 8-12, further comprising:

and the file acquisition module is used for acquiring a storage path of the backup file from the first attribute information and acquiring the backup file from a backup file system based on the storage path.

14. The database recovery detection apparatus according to any one of claims 8 to 12, wherein the second acquisition module includes:

a request sending unit, configured to send a query request to a server where the candidate database instance is located, where the candidate database instance is stored in a resource pool of the server;

a receiving unit, configured to receive the second attribute information sent by the server.

15. An electronic device, comprising:

at least one processor; and

a memory communicatively coupled to the at least one processor; wherein,

the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the method recited in any one of claims 1-7.

16. A computer-readable storage medium, wherein the computer instructions are for causing the computer to perform the method of any one of claims 1-7.

17. A computer program product comprising a computer program which, when executed by a processor, implements the method according to any one of claims 1-7.