Legal claims defining the scope of protection. Each claim is shown in both the original legal language and a plain English translation.
1. A system, comprising: a first computing device at a first site, the first computing device including: at least one processor, and memory storing instructions that when executed at the first computing device cause the first computing device to perform operations including: pre-generating a database recovery job including Job Control Language (JCL) for a first phase to configure a database management system of the database and JCL for a second phase to recover the data of the database; transporting the database recovery job to a second site, generating an archive log after the act of generating the recovery job, the recovery data comprising at least one database archive log generated after the act of generating the database recovery job, and transporting the database archive log to the second site; and a second computing device at the second site, the second computing device including: at least one processor; and memory storing instructions that, when executed at the second computing device cause the second computing device to perform operations including: receiving the database recovery job, receiving the archive log, and executing the database recovery job to recover the database at the second site to an extended recovery point by modifying, during the first phase, a control file for the database to recognize the database archive log.
A system for database recovery at a disaster recovery (DR) site uses two computing devices. The first, at the primary site, pre-generates a database recovery job containing instructions (JCL) to configure the database system and recover data. After the job is created, any new database archive logs generated are also transported to the DR site. The second computing device, at the DR site, receives both the pre-generated recovery job and any new archive logs. When executed, the recovery job recovers the database to a more recent state by modifying the database control file to include these newer archive logs, effectively extending the recovery point closer to the time of failure.
2. The system of claim 1 , wherein the generating the recovery job comprises: generating a first job corresponding to a first member of a data-sharing group of computer systems at the first site; and generating a second job corresponding to a second member of the data-sharing group.
The system described for database recovery enhances the pre-generation of the recovery job. Instead of generating one job, it generates two jobs. The first job corresponds to a first computer system (member) in a data-sharing group, while the second job corresponds to a second computer system (member) in the same data-sharing group. This allows for recovery of a database spread across multiple systems.
3. The system of claim 2 , wherein the act of generating a first job comprises: generating instructions to extend a database recovery point to the extended recovery point, after execution of a first portion of the second job; and wherein the act of generating a second job comprises: generating instructions to indicate execution of the first portion of the second job to the first job.
In the data-sharing system recovery, the generation of the first job includes instructions to extend the database recovery point after a portion of the second job has executed. Conversely, the generation of the second job includes instructions to signal to the first job when its initial portion is complete, indicating that the first job can proceed with extending the recovery point. This ensures coordinated recovery across multiple systems in the data-sharing group.
4. The system of claim 2 , wherein the act of generating a first job comprises: generating instructions to extend a database recovery point determined during the act of generating the first job to the extended recovery point; generating instructions to signal the second job to perform a second portion of the second job responsive to the act of extending a database recovery point; and wherein the act of generating a second job comprises: generating instructions to perform the second portion of the second job when signaled by the first job.
In the data-sharing system recovery, the first job generation includes instructions to extend the database recovery point. It also generates a signal to the second job, triggering the second job to perform a specific portion related to extending the recovery point. The second job, upon receiving the signal from the first job, executes the signaled portion. This hand-off mechanism allows synchronized and ordered execution of the database recovery process across the data-sharing group, ensuring data consistency during recovery.
5. The system of claim 1 , wherein the database is a DB2 database and the control file is a BootStrap data set (BSDS): generating instructions to calculate a conditional restart point at the extended recovery point corresponding to the database archive log; and generating instructions to update a bootstrap dataset to indicate the conditional restart point and the database archive log.
When recovering a DB2 database, the system modifies a BootStrap Data Set (BSDS) which serves as the control file. The recovery process calculates a conditional restart point within the BSDS corresponding to the newest database archive log. The BSDS is then updated to reflect this new conditional restart point and to acknowledge the presence of the new archive log. This effectively extends the recovery point for the DB2 database, allowing recovery to a more recent state.
6. The method system of claim 1 , wherein executing the second phase of the database recovery job occurs after executing the first phase and starting the database in maintenance mode.
The system runs the database recovery job in two phases. First, it executes the initial phase to configure the database management system. After the initial phase completes, and the database is started in maintenance mode, the second phase is executed, which actually recovers the database data. This staged approach allows for controlled and safe database recovery.
7. The method system of claim 1 , wherein generating the recovery job comprises: generating instructions to determine a plurality of end points, each corresponding to an end point of a last archive log corresponding to each member of a data-sharing group; generating instructions to determine an oldest end point of the plurality of end points; and generating instructions to set a conditional restart point in the control file to the oldest end point.
When generating the recovery job for a data-sharing group, the system identifies the end point (last transaction) of the last archive log for each member in the group. It then determines the oldest end point among all members. Finally, it sets the conditional restart point in the database control file to this oldest end point. This ensures that the database is recovered to a consistent state across all members of the data-sharing group, preventing data inconsistencies.
8. The method system of claim 1 , wherein the recovery job includes: instructions to replace the control file a bootstrap dataset; and instructions to modify a conditional restart point in the control file with a conditional restart point corresponding to the extended recovery point.
The recovery job consists of instructions to replace the current database control file (bootstrap dataset). The instructions also modify the conditional restart point within the control file, setting it to a point corresponding to the extended recovery point provided by the newer archive logs. This ensures the database restarts from the correct, updated location, minimizing data loss.
9. A method, comprising: receiving, at a computer system of a recovery site, a pre-generated database recovery job to recover a database, the database recovery job being pre-generated on a periodic basis, the database recovery job including Job Control Language (JCL) for a first phase to configure a database management system of the database and JCL for a second phase to recover data of the database; receiving, at the computer system, a database archive log generated after the pre-generated database recovery job; and executing the pre-generated database recovery job on the computer system to recover the database to a recovery point corresponding to the database archive log by modifying, during the first phase, a control file for the database to recognize the database archive log.
A method for database recovery at a disaster recovery site involves receiving a pre-generated database recovery job, which includes instructions (JCL) to configure the database system and recover the database data. The recovery job is created on a schedule. The method also involves receiving database archive logs generated *after* the recovery job was created. Upon execution, the recovery job recovers the database to a more recent recovery point corresponding to the received archive logs by modifying a database control file to include the newly received archive logs.
10. The method of claim 9 , wherein the act of executing the pre-generated database recovery job is performed by a computer system of a first member of a data-sharing group.
The method described for database recovery is performed by a computer system that is one member of a data-sharing group of computers.
11. The method of claim 9 , wherein the act of receiving a pre-generated database recovery job comprises: receiving a first pre-generated database recovery job configured for execution by a first member of a data-sharing group of computer systems; and receiving a second pre-generated database recovery job configured for execution by a second member of a data-sharing group of computer systems; and wherein the act of executing the pre-generated database recovery job comprises: extending a first recovery point determined during generation of the first pre-generated database recovery job to the recovery point corresponding to the database archive log by the first pre-generated database recovery job; and recovering the database to the recovery point corresponding to the database archive log by the first pre-generated recovery job and the second pre-generated recovery job.
The database recovery method handles data-sharing groups. It receives a first recovery job configured for execution by the first member of the group and a second recovery job configured for the second member. The first job extends its initial recovery point to include the newer archive logs. Both jobs then collaborate to recover the database to the recovery point defined by the newer archive logs, ensuring consistency across the shared database.
12. The method of claim 11 , wherein the act of executing the pre-generated database recovery job further comprises: coordinating the execution of the first pre-generated database recovery job on a first computer system of the first member of the data-sharing group and the execution of the second pre-generated database recovery job on a second computer system of the second member of the data-sharing group.
The database recovery method for data-sharing groups coordinates the execution of the first recovery job on the first computer system and the second recovery job on the second computer system, ensuring they work together to recover the database.
13. The method of claim 12 , wherein the act of coordinating the execution of the first pre-generated database recovery job on a first computer system of the first member of the data-sharing group and the execution of the second pre-generated database recovery job on a second computer system of the second member of the data-sharing group comprises: delaying extension of the first recovery point by the first pre-generated recovery job until the execution of a first portion of the second pre-generated recovery job; and delaying execution of a second portion of the second pre-generated recovery job until extension of the first recovery point by the first pre-generated recovery job.
The coordination process delays extending the first recovery point by the first job until a portion of the second job has finished running. Conversely, it delays a portion of the second job until the first job signals that it has successfully extended the recovery point. This prevents race conditions and ensures ordered database recovery across the data-sharing group.
14. The method of claim 12 , wherein the act of coordinating the execution of the first pre-generated database recovery job on a first computer system of the first member of the data-sharing group and the execution of the second pre-generated database recovery job on a second computer system of the second member of the data-sharing group comprises: executing a first portion of the second pre-generated job to prepare the second member for extension of the first recovery point; signaling to the first pre-generated recovery job by the second pre-generated job that the second member of the data-sharing group is ready for extension of the first recovery point by the first pre-generated recovery job; signaling to the second pre-generated recovery job by the first pre-generated job that the first pre-generated recovery job has extended the first recovery point; and executing a second portion of the second pre-generated job to recover the database on the second member of the data-sharing group.
The coordination executes a portion of the second job to prepare the second member of the data-sharing group. Once ready, the second job signals to the first job that it can extend the recovery point. The first job then signals to the second job that it has extended the recovery point. Finally, the second job completes the database recovery on its member. This handshake mechanism guarantees data consistency.
15. The method of claim 11 , wherein the act of extending a first recovery point determined during generation of the first pre-generated database recovery job to the recovery point corresponding to the database archive log by the first pre-generated database recovery job comprises: determining a type of archiving performed for the database; performing a first set of acts if the type of archiving is of a first type, comprising: replacing the control file; calculating the recovery point corresponding to the database archive log; updating the control file with the recovery point corresponding to the database archive log; and updating the control file with information corresponding to the database archive log; and performing a second set of acts if the type of archiving is of a second type, comprising: reading a history file; calculating the recovery point corresponding to the database archive log; updating the control file with the recovery point corresponding to the database archive log; and updating the control file with information corresponding to the database archive log.
The method of extending the recovery point depends on the database archiving type. For a first archiving type, the process replaces the current control file, calculates the recovery point corresponding to the new archive logs, and updates the control file with the new recovery point and archive log information. For a second archiving type, the process reads a history file, calculates the new recovery point, and updates the control file with the new recovery point and archive log information.
16. The method of claim 15 , wherein the act of extending a first recovery point determined during generation of the first pre-generated database recovery job to the recovery point corresponding to the database archive log by the first pre-generated database recovery job further comprises: deleting older archive logs from the control file.
The process of extending the recovery point in database recovery further includes removing older archive logs from the control file. This cleanup ensures the control file doesn't become too large and focuses recovery efforts on the most relevant logs.
17. A tangible computer-readable storage device with instructions for a programmable control device stored thereon wherein the instructions cause a programmable control device to perform the method of claim 9 .
A computer-readable storage device contains instructions that, when executed, cause a computer to perform the database recovery method: receiving a pre-generated recovery job and newer archive logs, then executing the recovery job to recover the database to a recovery point corresponding to the newer archive logs by modifying a database control file.
18. The method of claim 9 , wherein modifying the control file includes: determining the archive log is a first archive type; replacing existing control file with a most recent database control file from the archive log; and setting a conditional restart point to a time of an end point for the archive log file.
The modification of the control file includes checking the archive log file type. If it is a first type, the existing control file is replaced with a more recent database control file obtained from the archive log. Then, a conditional restart point is set to the timestamp of the archive log file end point.
19. The method of claim 9 , wherein the first phase executes when the database is stopped and the second phase executes after the database has been re-started in a maintenance mode.
The database recovery job is divided into two phases. The first configuration phase executes while the database is stopped. After the first phase is completed and the database is restarted in maintenance mode, the second phase, which recovers the data, is executed.
20. A networked computer system comprising: a plurality of computers communicatively coupled, at least one of the plurality of computers programmed to perform the method of claim 9 .
A networked computer system includes several computers that are communicatively coupled. At least one of these computers is programmed to perform the database recovery method of receiving a pre-generated recovery job and newer archive logs, then executing the recovery job to recover the database to a recovery point corresponding to the newer archive logs by modifying a database control file.
21. A tangible computer-readable storage device with instructions for a programmable control device stored thereon wherein the instructions cause a programmable control device to perform the method of claim 9 .
A computer-readable storage device contains instructions that, when executed, cause a computer to perform the database recovery method: receiving a pre-generated recovery job and newer archive logs, then executing the recovery job to recover the database to a recovery point corresponding to the newer archive logs by modifying a database control file.
Unknown
September 19, 2017
Browse 5M+ US patents with plain-English claim translations and AI-generated analysis.